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 table are known to work with BMC Atrium Orchestrator, some of them are untested.
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.
Database | URL template | Driver | Notes |
|---|---|---|---|
DB2 | jdbc:db2://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.ibm.db2.jcc.DB2Driver |
|
DB2 AS/400 | jdbc:db2://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.ibm.db2.jcc.DB2Driver |
|
DB2 OS 390 | jdbc:db2://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.ibm.db2.jcc.DB2Driver |
|
Firebird | jdbc:firebirdsql://{<ipAddress>|<hostName>}:<port>/<databaseName> | org.firebirdsql.jdbc.FBDriver |
|
FrontBase | jdbc:FrontBase://{<ipAddress>|<hostName>}/<databaseName> | com.frontbase.jdbc.FBJDriver |
|
Hypersonic | dbc:hsqldb:hsql://{<ipAddress>|<hostName>}:<port>/<databaseName> dbc:hsqldb:mem:<databaseName> dbc:hsqldb:file:<databaseName> | org.hsqldb.jdbcDriver |
|
Informix | jdbc:informix-sqli://{<ipAddress>|<hostName>}:<port>[/<databaseName>]:INFORMIXSERVER=<serverName> | com.informix.jdbc.IfxDriver |
|
Ingres | jdbc:ingres://{<ipAddress>|<hostName>}:<port>/<databaseName> | ca.ingres.jdbc.IngresDriver |
|
Interbase | jdbc:interbase://{<ipAddress>|<hostName>}:<port>/<databaseName> | interbase.interclient.Driver |
|
Mckoi SQL | jdbc:mckoi://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.mckoi.JDBCDriver |
|
Microsoft SQL Server | jdbc:microsoft:sqlserver://{<ipAddress>|<hostName>}:<port>;databaseName=<databaseName> | com.microsoft.sqlserver. jdbc.SQLServer Driver | Ensure that you use the exact format. If you specify a different format, you may have access to the Value Dashboard, but not be able to see Value reports. |
MySQL | jdbc:mysql://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.mysql.jdbc.Driver |
|
MySQL with InnoDB | jdbc:mysql://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.mysql.jdbc.Driver |
|
MySQL with MyISAM | jdbc:mysql://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.mysql.jdbc.Driver |
|
Oracle | jdbc:oracle:thin:@{<ipAddress>|<hostName>}:<port>:<SID> jdbc:oracle:thin:@{<ipAddress>|<hostName>}:<port>/<serviceName> | oracle.jdbc.driver.OracleDriver |
|
Pointbase | jdbc:pointbase:server://{<ipAddress>|<hostName>}/<databaseName> | com.pointbase.jdbc. |
|
PostgreSQL | jdbc:postgresql://{<ipAddress>|<hostName>}:<port>/<databaseName> | org.postgresql.Driver |
|
Progress | jdbc:jdbcprogress:T:{<ipAddress>|<hostName>}:<port>;databaseName=<databaseName> | com.progress.sql.jdbc. |
|
SAP DB | jdbc:sapdb://{<ipAddress>|<hostName>}/<databaseName> | com.sap.dbtech.jdbc.DriverSapDB |
|
Sybase | jdbc:sybase:Tds:{<ipAddress>|<hostName>}:<port> | com.sybase.jdbc3.jdbc.SybDriver |
|
Sybase Anywhere | jdbc:sybase:Tds:{<ipAddress>|<hostName>}:<port>/<databaseName> | com.sybase.jdbc3.jdbc.SybDriver |
|