Systems Configuration

This section allow administrator to configure connections with different third-party systems. It stores connection details of different systems and help communicate with these systems.

Below are the different types of connections which can be setup from this section:

Connection type Description
SMTP Used to setup SMTP connection. This will be further used by MDO to trigger emails notifications to different users.
SAP Used to setup SAP ECC connection. This connection will further help to push data to SAP from MDO. This is mainly used to trigger IDOC’s.
FTP Used to communicate with third party system using FTP folder, xml and flat files are dropped into the FTP folder, which is later picked by the target system to process data.
SFTP Used to communicate with third party system using SFTP (Secure FTP) folder. xml and flat files are dropped into the SFTP folder, which is later picked by the target system to process data.
SMS Used to setup SMS server. This will be further used by MDO system to trigger SMS alerts to users
IS This option is used to setup a connection between MDO and Integration server. Generally, MDO integration layer acts like a integration server for integration.
Database This option help storing third party Database connection details. MDO can further use the details to authenticate with database to push data.
Webservice This connection is used to process data using webservices. The authentication user id and password are maintained in connections which are further used by webservices during integration.
MDO MDO connection is used to communicate or process data between two MDO systems. This connection can also be used to send transports between two different MDO systems i.e. from DEV to QA to PROD
SF This connection is used to communicate between MDO and Salesforce.

 

SMTP

Whenever any data gets created or updated, MDO trigger emails to different users responsible to perform the task. SMTP connection is configured in MDO to enable emails notifications on different events.

Below is some key information required to configure SMTP settings:

 

Field Description
Server Name Provide SMTP server name i.e. smtp.gmail.com
Exchange user name Provide exchange user name
Password Enter valid password
Port Enter SMTP port
Is secure Check this checkbox if you are using TLS for SMTP.

 

SAP

There are various ways to integrate data from MDO to SAP, SAP connection is generally used to post data to SAP using IDOC’s and RFC’s from MDO.

Below is some key information required to configure SAP Connection from MDO:

Field Description
Connection Name Provide connection name for identification
Host IP Provide Host IP
System No Provide System number
User id Provide valid user id, in most of the cases its communication user id
Password Provide valid password
SAP Client Provide SAP Client
Language Provide language if any, mostly “EN” is used.
Alias Provide Alias name
Maximum Connection Put 100 as default

 

FTP

FTP connection is used to communicate with third party system using FTP folder, xml and flat files are dropped into the FTP folder, which is later picked by the target system to process data.

Below is some key information required to setup an FTP connection from MDO:

Field Description
Host IP Provide host IP
User ID Provide authentication user id
FTP Path Provide FTP path
Alias Provide Alias name
Upload Secure File In Case you are using file-based authentication then please upload .ppk file in this field.
Connection Name Provide connection name for identification
Port No Provide FTP port
Password Provide valid password
Language Default value is “EN”
Maximum Connection Default value is 100

 

SFTP

FTP connection is Used to communicate with third party system using SFTP (Secure FTP) folder. xml and flat files are dropped into the SFTP folder, which is later picked by the target system to process data.

Below is some key information required to setup an SFTP connection from MDO:

Field Description
Host IP Provide host IP
User ID Provide authentication user id
SFTP Path Provide FTP path
Alias Provide Alias name
Upload Secure File In Case you are using file-based authentication then please upload .ppk file in this field.
URL Provide SFTP URL
Connection Name Provide connection name for identification
Port No Provide FTP port
Password Provide valid password
Language Default value is “EN”
Maximum Connection Default value is 100

 

SMS

This option enables SMS notifications to users from MDO. MDO does not come with the inbuilt SMS packages or credits so you need to buy bulk SMS credits/services from SMS providers. Below are the some key information required to enable SMS from MDO:

Field Description
Host IP Enter host IP provided by your SMS provider
Connection Name Provide connection name for identification
Gateway Name Enter Gateway name provided by SMS provider
Gateway URL Enter Gateway URL provided by SMS provider

 

IS

This option is used to setup a connection between MDO and Integration server. Generally, MDO integration layer acts like an IS, however if organization wants to use some other integration server then we need to maintain below mentioned information in MDO:

 

Field Description
Host IP Provide host IP for IS, if you are using same MDO server for IS then host IP will be “localhost
User ID Provide authentication user id
URL Provide IS URL i.e. https://demo.masterdataonline.com/MDO-WS
Connection Name Provide connection name for identification
Port No Provide IS port
Password Provide valid password

 

Database

This option help storing third party Database connection details. MDO can further use the details in various integrations and internal API’s to authenticate with third party database and hence can push pull data from that database.

Below is some key information required for setting up Database connection:

Field Description
User ID Provide authentication user id
Password Provide valid password
Host IP Provide host IP for Database server.
Data base name Provide Data base name
Port Provide communication port on which data base server is working.

 

Web-Service

This connection is used to process data using web-services. The authentication user id and password are maintained in connections which are further used by MDO to push data through web services during integration.

Below is some key information required for setting up Web-services integration:

Field Description
User ID Provide authentication user id.
Connection Name Provide connection name for identification.
Password Provide valid password.
Host IP Provide host IP of SAP system.

 

MDO

MDO connection is used to communicate or process data between two or more MDO systems. This connection can also be used to send configuration transports between two different MDO systems i.e. from DEV to QA to PROD etc.

To Setup an MDO connection below are the required details:

Field Description
Host IP Provide host IP of MDO system
User ID Provide connection user ID
Connection name Provide connection name for identification
Password Provide valid password
URL Provide complete URL i.e. https://demo.masterdataonline.com/MDOSF

 

SF (Sales force)

SF (Salesforce) connection support integration between MDO and Sales force. To setup a salesforce connection below are the required details:

Field Description
User ID Provide authentication user id
Password Provide valid password
Grant Type To get authentication token from sales force you need to enter Grant type. Mostly MDO use password grant type so you need to enter “password” in this field.
Client Id Specify SF client id
Client Secret Please enter Sales force secret key provided by Salesforce.
Connection Name Provide connection name for identification