JDBC trading partner

This trading partner performs queries against a database. MFT Server will initiate the connection to the trading partner. It is assumed that the database administrator has provided you with the details needed to set up this trading partner.

 

Adding the JDBC trading partner

 

In the desired domain, navigate to the AUTOMATION > Trading Partners module. Click on the Add button, or right-click anywhere in the grid area and select Add from the pop-up menu. In the Add Trading Partner dialog window, select JDBC as the Protocol, then click OK. The Add "JDBC" Trading Partner dialog will appear as depicted in the image below.

 

 

Basic

 

Name - The unique name to assign to this trading partner. Enter a name that best describes the trading partner, as you will be selecting the name when using the partner in MFT Server features that support it.

 

Company - The name of the company that this trading partner represents.

 

E-mail - The primary email address for this trading partner.

 

Connection

 

JDBC URL - The database URL, which will vary depending on the type of database you are connecting to. For example, a MySQL URL follows this format: jdbc:mysql://hostname:port/database_name.

 

UserName - The username to connect to the database.

 

Password - The username's password to connect to the database.

 

Tags

 

Tags - If specified, this is the one or more tags that are used to limit which administrators have access to the network.