Database URLs and drivers
BMC Atrium Orchestrator Grid Manager requires a URL and a driver to identify the database management system. This page lists the default URL and driver for each of the databases that can interface with BMC Atrium Orchestrator.
BMC Atrium Orchestrator supports Hibernate-compatible databases. While the databases listed in this page are known to work with BMC Atrium Orchestrator, some of them are untested.
Note
You should verify all database information with the database vendor's documentation. You might need to use a different URL and/or driver string based on the database version and driver provided by your vendor. URL drivers determine the URL and vendors may provide different drivers than those listed on this page.
For example, if you are using MS SQLServer v2005, you might change the information for the MS SQL JDBC driver as follows to use the new JDBC driver:
- URL:
Instead of
jdbc:microsoft:sqlserver://{<ipAddress>|<hostName>}:<port>;databaseName=<databaseName>
Use
jdbc:sqlserver://{<ipAddress>|<hostName>}:<port>;databaseName=<databaseName> - Driver:
Instead of
com.microsoft.jdbc.sqlserver.SQLServerDriver
Use
com.microsoft.sqlserver.jdbc.SQLServerDriver
The following URL templates use the following syntax. Replace the variables with the appropriate values for your machine and database.
- Variables enclosed by brackets [] are optional.
- Variables enclosed by angled brackets <> are required.
- Variables enclosed in curly brackets {} and separated by a vertical line | means that at least one of them is required.
Supported databases
Database | URL | Driver |
|---|---|---|
Oracle | jdbc:oracle:thin:@{<ipAddress>|<hostName>}:<port>:<SID> jdbc:oracle:thin:@{<ipAddress>|<hostName>}:<port>/<serviceName> | oracle.jdbc.driver.OracleDriver |
Sybase | jdbc:sybase:Tds:{<ipAddress>|<hostName>}:<port> | com.sybase.jdbc3.jdbc.SybDriver |
Other databases
Note
For Hypersonic and PostgreSQL databases, BMC recommends that you create the schema prior to setting parameters in the Database Configuration tab. Also, the schema name must be the same value as the user name.
Comments