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:



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



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:







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