Configuring Database Connectivity

Enterprise Services supports relational database connectivity in addition to TM1.   This allows you to combine multi-dimensional and relational data when building applications using a single web service provider.  

 

In order to use a database connection in Enterprise Services, a new connection string must be added to the “connectionStrings” section of the web.config in the following format:

 

 <add name="<LocalMachineName>:DB" connectionString="<Valid Connection String>" providerName="SQL"/>

The attributes of the connection string element are:

 

name                        - Connection name in the format of the local machine name suffixed by ':DB'

connectionString        - A valid database connection string  (see note below)

providerName                - A valid database connection provider

 

A typical format for the connectionString may be:

 

 Server=myServerAddress;Database=myDatbaseName;UserID=myUserID;Password=myPassword;

Please consult your database documentation for proper connectionString and providerName values.

 

Note_200

NOTE:  Because various database provides have unique syntax requirements, you can optionally specify a Syntax= parameter in the connection string to designate the query syntax that Enterprise Services will conform to.   The valid values for the Syntax parameter are:

MSSQL

Oracle

PureData

MySQL

Access

 

If no value is provided, MSSQL will be the default syntax used by Enterprise Services