Connection files reside under the Connections folder which is in the Integrator application folder. The default path of this folder is therefore:
C:\Program Files\Event 1\Integrator\Connections
Purpose
Connection files are plain text files and have a file extension of "eic". These files do not contain your integration settings but act instead as pointers to the connections that are defined in the Integrator database.
When opening a connection, the list of available connections is determined by reading the list of connection files in the Connections folder. If you need to access the same connectoin(s) on multiple workstations, the connection files can be copied from one workstation to another.
Contents
Most of the data contained in a connection file is duplicated in the connection data held in the Integrator database. The data held in the Integrator database will always override the data held in the connection file. This duplicate data is placed in the connection file only for the purpose of displaying it in the Open Connection window. If the data in the connection file is different than the data in the Integrator database, the connection file will be updated to reflect the correct information when the connection is opened. The only property in the connection file that affects the operation of Integrator is the name of the SQL Server.
The following properties are defined in a connection file:
[General]
Name
This is the name of the connection and must be identical to the connection filename (without the file extension).
Version
This entry provides the version of Integrator last used with the connection.
Flags
This property controls whether usre names and passwords will be saved in the connection file. The value for this property is a bitmask meaning that it is defined using the sum of the values of the desired options.
The options that are available are as follows and control whether each of these values are stored in the connection file. Note that if passwords are stored, they are encrypted.
1 = Sage Timberline Office Operator ID
2 = Sage Timberline Office Password
4 = Prolog User Name
8 = Prolog Password
16 = SQL Server User Name
32 = SQL Server Password
Therefore, a value of 23 would tell Integrator to store the following:
Sage Timberline Office Operator ID
Sage Timberline Office Password
Prolog User Name
SQL Server User Name
This is because 23 is the sum of their respective values (1+2+4+16=23).
[SQLServer]
ServerName
This specifies the name of the SQL Server (or MSDE Server). This is the server that Integrator will access when opening the connection.
IntegratedSecurity
This setting is no longer used since the Meridian AI-SDK does not support this authentication model.
UserName
This property stores the User Name that should be used when connecting to the SQL Server. The default value for this property is "sa".
Password
This property stores the Password that should be used when connecting to the SQL Server.
[PrologManager]
Database
This property stores the name of the Prolog Manager database on the SQL Server. Tihs is for display only.
UserName
This property stores the User Name that should be used when opening a Prolog Manager database. The default value for this property is "Admin".
Password
This property stores the Password that should be used when opening a Prolog Manager database.
[TimberlineGold]
Database
This property stores the path to the Sage Timberline Office database. This is for display purposes only.
UserName
This property stores the Sage Timberline Office Operator ID that should be used when connecting to the Sage Timberline Office database.
Password
This property stores the Password that should be used when connecting to the Sage Timberline Office database.