This category enables you to set up additional databases that can be used in areas of the application (a reporting or BI database). Additional databases can be used to store output and to alleviate some of the load from the primary database.
|
Caution The database must already exist in Microsoft SQL Server (imported or configured on the database server) before you can add it. |
Database nodes contain the following properties.
Field |
Description |
Data Source |
Location of the database. |
Initial Catalog |
Database name. |
Integrated Security |
Currently not supported. |
Password |
Password to connect to the database. |
Persist Security Info |
Currently not supported. |
Provider |
SQLOLEDB.1 is the default database used and cannot be modified. |
User ID |
User ID to connect to the database. |
