This category enables you to set up additional databases that can be used in areas of the application (e.g. 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 to AudienceView. |
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 by AudienceView and cannot be modified. |
User ID |
User ID to connect to the database. |