File Description
The imosEnv.xml file is a key file for configuring IMOS. Within this file you will configure the various IMOS Environments that a single Application Instance is able to access.
File Sample
Below is a sample of an imosEnv.xml file with two environments: prod and test
imosEnv.xml Sample
<?xml version="1.0"?>
<imosEnv>
<imosEnvironments>
<imosEnvironment name="prod" dbConnectString="Provider=Microsoft OLE DB Provider for SQL Server;Driver={SQL Server};Server={IMOS-SQL};Trusted_Connection={No};Database={prod};Uid={imos};Pwd={password}" dbSqlId="_sqlid" />
<imosEnvironment name="test" dbConnectString="Provider=Microsoft OLE DB Provider for SQL Server;Driver={SQL Server};Server={IMOS-SQL};Trusted_Connection={No};Database={test};Uid={imos};Pwd={password}" dbSqlId="_sqlid" />
</imosEnvironments>
</imosEnv>
Parameter Descriptions
The key to the imosEnv file is the individual <imosEnvironment> element that contains several attributes affecting your setup. This table includes these attributes:
| Attribute | Description | Value |
|---|---|---|
| name | Text used to identify different environments within an application instance | Text |
| dbConnectString | .NET Connection String used to identify different parameters necessary to connect to the IMOS Database Server | Each parameter requires a different value |
dbConnectString.Provider | .NET compatible database connection provider | DO NOT EDIT |
| dbConnectString.Driver | .NET compatible connection driver | DO NOT EDIT |
| dbConnectString.Server | Network Hostname\SQL Instance information | HOSTNAME\INSTANCE |
| dbConnectString.Trusted_Connection | Determines whether to use pass-through Windows Authentication per database connection | Yes: Set if each individual IMOS user also has a database server account No: Set if IMOS has a single dedicated database server account for all users |
| dbConnectString.Database | SQL Database name on the SQL Server | SQL Database Name |
| dbConnectString.Uid | SQL user name provided if Trusted_Connection is set to No | SQL Database User for IMOS |
| dbConnectString.Pwd | SQL user name password provided for the designated Uid if Trusted_Connection is set to no | SQL user name password |
| dbSqlId | Column title for the unique row identifier in all IMOS tables | Default to _sqlid |