Using the database servers

You can use a database server configuration anywhere that a SQL Server can be specified.

To refer to a database server configuration, put its name in < > (angle brackets), for example:

The angle brackets tell UNICOM Intelligence that the database server connection information is in DPM, and SQLServer1 is not the name of a database server.

You can also include “DatabaseServer” in the angle brackets, for example:

<DatabaseServer:SQLServer1>

In the FMRoot\Shared\Config\SampleMgtGUI.Config.Xml file, replace the angle brackets with < and >. For example:

All the database servers that you set up are displayed in UNICOM Intelligence (for example, in Launch or Participants). A list of databases includes both physical databases and database server configurations. For example, the dropdown list for Activate might contain SQLServerA, <SQLServer1>, and <AzureMI1>.

To set the default database for activation and participants, use DPM Explorer to change the DefaultCluster string under Site/Clusters. Set DBServer to the database server name, for example <AzureMI1>.

In the following example, the default database for activate and participants is <AzureMI1>, and mrInterviewData and mrUserData are hosted on a physical SQL Server called SQLServer1.

AUTHORSERVERLIST&=&Server1&;&REPORTSSERVERLIST&=& Server1&;&WEBREPORTSSERVERLIST&=& Server1&;&ACCESSORYSERVERLIST&=& Server1&;&DBSERVER&=&<AzureMI1>&;&DBDRIVER&=&MSOLEDBSQL&;&IVSERVERLIST&=&Server1&;&WEBSERVERLIST&=&Server1&;&CONNECTIONSDATABASE&=&Provider=MSOLEDBSQL;Integrated Security=SSPI;Initial Catalog=mrInterviewData;Data Source=SQLServer1

Reports marked as “across projects” or “across phone projects” in the Interviewing activity work only if mrInterviewData and the participant data are on the same database server.