Use the Map DSN tab when the trading partner and/or the log information are stored in databases that are accessed through ODBC. On this tab, enter the information that tells the program how to access the databases.
If you also use EC Gateway Server, you must use a different
DSN for the trading partner and the log, even if they both point
to the same database. Otherwise, you may experience problems with
some of your Gateway reports.
Defining DSN settings
Perform these steps for both the trading partner DSN and the log DSN
Select the Data Source Name text box up arrow
The Data Source Name window displays.
Double-click on a DSN to select it.
The DSN is entered in the Data Source Name text box and the driver connect string is automatically created.
If you have not created the DSN, select Configure Data Source to open the the ODBC configuration window. Once you have created your DSNs, proceed with the procedure.
For certain databases, such as MS SQL Server and Oracle,
you may need to manually edit the string in the text box to add
a user ID and password.
Select Test Trade Partner Connection or Test Log File Connection to test the connections.
If you select Clear TP Fields, the program removes all of the information entered in the text boxes on the Trade Partner section of this tab. If you select Clear Log Fields, the program removes all of the information entered in the text boxes on the Log section of this tab.
Select OK. You return to the Project/Map window.