The Data Engine is a centralised place to configure database connections within Identity Broker. These data connections can be named for reference in other configuration files. The default configuration has a named connection of Unify.IdentityBroker which is used by other components to connect to the Microsoft SQL Server database. If the database was created or updated by the Identity Broker installer, the data engine will contain these settings.

The Data Engine file is named Unify.Framework.Data.DataEnginePlugInKey.extensibility.config.xml. The following is an example of the configuration of the Data Engine.

Data Engine configuration

<?xml version="1.0" encoding="utf-8" ?>
<DataEngine>
  <dataRepository>
    <dataConnection name="sql" repository="Unify.IdentityBroker" connectionString="Data Source=LOCALHOST;Initial Catalog=Unify.IdentityBroker;Integrated Security=True" />
  </dataRepository>
</DataEngine>

The pre-existing dataConnection XML element provides the base database connection for the Identity Broker service. The following table describes the attributes of the dataConnection element:

Attributes Description
name The type of database connection. This refers to a type of database connection. The allowable values are:
  • sql
  • oracle - currently only supported for third party connector data connections
  • impersonate
repository This is the name of the repository as referred to in other configuration files. This allows the configuration of a single database centrally in the Data Engine configuration.
connectionString This is the ADO.NET connection string used to connect to the actual database. It is consistent with those define in ADO.NET connection strings for the type of database being connected to. This attribute is not used for the impersonate name attribute value. For more information on SQL Server connection strings refer to Connection Strings below.
enableTransactions Set to true to allow Identity Broker to perform operations for this connection inside a transaction using Microsoft Distributed Transaction Coordinator.
domain For impersonate type connections, this identifies the domain of the user to impersonate when using this connection.
user For impersonate type connections, this identifies the user to impersonate when using this connection.
password For impersonate type connections, this identifies the password of the user to impersonate when using this connection.

If the impersonate type data connection is used, the dataConnection element must have a child element also named dataConnection specifying how to connect to the database once impersonation has occurred.

In order to correctly configure Identity Broker, the pre-existing dataConnection element for the Unify.IdentityBroker repository must be changed to connect to the database created in Manually installing the Identity Broker database.

Connection Strings

Is this article helpful for you?