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:
<host>:<port>/<PDB>
somedb99.example.com:1234/orclpdb
<host>:<port>/<SID>
somedb99.example.com:1234/ORCL
<host>:<port>/<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)))
(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.
<SQLServerHost>:<Port>:<DBschema>
MSSQLServerHost.example.com:1433:myDBschema