When you run a Model, the DataManager will connect to an ODBC datasource. Which datasource to connect to is specified in the connection configuration file. The name and location of the connection configuration file is specified at the setting ITPDMINIFILE= in the ITP configuration file. You can set or change this setting with the ITP Administration Program. The value of this setting is the name of a file. The connection configuration file is called the DataManager ini file or Dm.ini file. You can change the contents of the Dm.ini file with the ITP Administration Program by selecting Connection configuration.
The connection configuration of the ODBC connection should at least contain a data source name (DSN). The DSN can be specified at the Connstr setting and in the DSN setting. The values specified in the DSN, Password, UserId and DSN setting will be combined to one connection string that will be used to connect to the data source.
If you want to connect to multiple data sources in a single DID you can specify the ODBC settings per DID Module.
If you omit settings for a certain DID Module, ITP uses the settings specified at DID level for this DID Modules.
Note
Please note that a password specified in Connstr is not encrypted and therefor readable to whomever has read-access to the dm.ini file! Use the setting Password, which can contain an encrypted version of the password. If the data source requires a password and it is not supplied through a setting in ITP/Workstation, the user is prompted for a password. ITP/BatchServer will consider this an error.
Please refer to the documentation of your ODBC Driver for information about connection strings.