Data connections

In the Data Connections dashboard, you define data connections within a specific application. Select Dashboards > Applications Administration > Data Connections.

Data connections provide access to these categories of data source:

OLAP
XMLA Providers
This category includes external OLAP providers.
Relational Providers
This provides access to an option to connect to the built-in staging database.

On the Usage tab, you can specify which clients and other applications the data source can be used with.

For XMLA and relational connections, you can edit the properties of connections only through the options on the Advanced tab, and on the Service Specific tab of a service in the Services dashboard. There is no interface in which to view or edit connection strings directly.

The Advanced tab for OLAP has an option to select the format of the unique names of elements. This enables you to create multiple data connections to the same OLAP database, each with a different unique name format.

Example

A requirement for a high availability connection can be configured with the Enable 'AlwaysOn Availability Groups' support check box and the command and connection timeout options on the Advanced tab. Additional parameters such as database recovery intervals and server idle times are available in the service-specific options of the repository service.

A connection string created from the selections on the Advanced tab and service-specific options might look like this:

Provider=MSOLEDBSQL;Server=tcp:DEVBILS.<customer>.com,1433;MultiSubnetFailover=Yes;Database=DB_Name; Connect Timeout=30;ConnectRetryCount=10;ConnectRetryInterval=10;