UNIFYBroker Data Configuration
The Data Engine is a centralised place to configure database connections within UNIFYBroker. 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 UNIFYBroker 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 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:
|
| 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
- For more information on configuring a SQL Server connection string see: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx
- For more information on configuring an OLE DB connection string see: http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection.connectionstring.aspx
- For more information on configuration an Oracle connection string see: http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracleconnection.connectionstring.aspx
Customer support service by UserEcho
