Connection Strings for SQL-Based Connectivity
To design Essbase load rules that access external sources of data using SQL, you sometimes need to have a connection string. Supported formats for different sources are listed here.
The available OCI and DSN-less connection string types are listed, with syntax and examples.
In the examples, DBName
is the name of the external source database containing tables and data.
Oracle Call Interface (OCI)
Syntax: DatabaseServerName:PortNumber/ServiceName
Example: OracleServer123.example.com:1521/orcl.example.com
Oracle Database (DSN-less)
Syntax (SID): oracle://HostName:PortNumber/SID
Example (SID): oracle://somedb99:1234/ORCL
Syntax (ServiceName): ORACLESERVICE:oracle://HostName:PortNumber/Servicename
Example (ServiceName): ORACLESERVICE:oracle://somedb99:1234/esscs.host1.oraclecloud.com
Microsoft SQL Server (DSN-less)
Syntax: sqlserver://HostName:1433:DBName
Example: sqlserver://myMSSQLHost:1433:myDbName
DB2 (DSN-less)
Syntax: db2://HostName:PortNumber:DBName
Example: db2://myDB2Host:1234:myDbName
MySQL (DSN-less)
Syntax: mysql://HostName:3306:DBName
Example: mysql://someHostName:3306:myDbName
Teradata (DSN-less)
Syntax: teradata://host:port/DBName
Example: teradata://192.0.2.110:1025/myDBName