catalog.url

The URL for the catalog database.

Syntax

catalog.url=database_tag\://host:port/

where host is a server name or server plus domain name, depending on your requirements.

Notes

The following database tags are supported:

oracle—Oracle
db2—IBM DB2
sqlserver—Microsoft SQL Server

When your catalog database is Oracle, using an Oracle ID (SID), you must append the Oracle SID to the catalog.url parameter, using the following syntax:

catalog.url=oracle\://host\:port\:OracleSID

When your catalog database is Oracle, using an Oracle Service Name, you must append the Oracle Service Name to the catalog.url parameter, using the following syntax:

catalog.url=oracle\://host\:port/OracleServiceName

When your catalog database is IBM DB2, you must append the database name to the catalog.url parameter, using the following syntax:

database tag://host:port;databaseName=database name

Examples

Oracle using SID:

catalog.url=oracle\://sequoia.efgco.com\:1521\:bpm
catalog.url=oracle\://sequoia\:1521\:bpm

Oracle using Oracle Service Name:

oracle://aspen123.us.xyzco.com\:1521/epmdb.us.xyzco.com
oracle://aspen123\:1521/epmdb.us.xyzco.com

IBM DB2:

catalog.url=db2\://cypress.abcco.com\:50000;databaseName=EPM_Db

catalog.url=db2\://cypress\:50000;databaseName=EPM_Db

Microsoft SQL Server:

catalog.url=sqlserver\://aspen3.us.oracle.com\:1433
catalog.url=sqlserver\://aspen3\:1433

See Server Properties File Examples for specific RDBMS examples.