Transport Tab

The Transport tab identifies the source (type and location) of the imported data.

The Transport type list includes the data source types, described below. Other fields will appear, as needed, for each entry in this list.

File

The imported data will be coming from a file.

• Import From: The location of the file that contains the import data.

• Append Errors to: The location of the file to append the error/comments.

Note: The MES middleware user account must have access to the file directories that are used by Supply Chain Connector. For information about how the MES middleware user account is specified, see the MES Installation Guide.

Database Table

The imported data will be coming from a database table. The database used is the one identified on the Trigger tab.

• DB Connection String: Full connection string to access the database. For example:

  Provider=SQLOLEDB;Data Source=1.1.1.1\MES;Initial Catalog=MESDB;Integrated Security=SSPI;

• Test button: Tests the DB Connection string, to ensure the database is accessible.

• Query: Defines a valid database query, which will generate the import data.

• Test button: Tests the query.

To modify the transport definition, select the desired field and change its value. Click Save to keep your changes or Cancel to discard them.