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 |