Connection String Formats

Here are formats of connection strings used by relational databases that Essbase supports for configuring the RCU repository database.

These connection strings are useful when, while using the Essbase configuration tool, you get to the Database Connection screen.

The supported databases you can use for Essbase RCU schemas are listed in the Certification Matrix under Database.

Oracle Database

Here are examples of several supported connection string formats for specifying Oracle Database as the repository:

Syntax (PDB):

<host>:<port>/<PDB>

Example (PDB):

somedb99.example.com:1234/orclpdb

Syntax (SID):

<host>:<port>/<SID>

Example (SID):

somedb99.example.com:1234/ORCL

Syntax (Service_Name):

<host>:<port>/<service_name>

Example (Service_Name):

somedb99:1234/esscs.host1.oraclecloud.com

Syntax (Long service name):

(DESCRIPTION=(ADDRESS=(host=host_name)(protocol=protocol_name)(port=port_number))
      (CONNECT_DATA=(SERVICE_NAME=service_name)))

Example (Long service_Name):

(DESCRIPTION=(ADDRESS=(host=oracle://somedb.example.com)(protocol=TCP)(port=1521))
      (CONNECT_DATA=(SERVICE_NAME=orclpdb)))

Microsoft SQL Server

Here is an example of the connection string format for specifying Microsoft SQL Server as the repository:

In the example, DBschema (or myDBschema) is the name of the external source schema that contains tables and data.

Syntax:

<SQLServerHost>:<Port>:<DBschema>

Example:

MSSQLServerHost.example.com:1433:myDBschema