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.
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
Database | URL template | Driver |
|---|---|---|
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.jdbc.sqlserver.SQLServer Driver |
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 |
PostgreSQL | jdbc:postgresql://{<ipAddress>|<hostName>}:<port>/<databaseName> | org.postgresql.Driver |
Pointbase | jdbc:pointbase:server://{<ipAddress>|<hostName>}/<databaseName> | com.pointbase.jdbc.jdbcUniversalDriver |
Progress | jdbc:jdbcprogress:T:{<ipAddress>|<hostName>}:<port>;databaseName=<databaseName> | com.progress.sql.jdbc.JdbcProgressDriver |
SAP DB | jdbc:sapdb://{<ipAddress>|<hostName>}/<databaseName> | com.sap.dbtech.jdbc.DriverSapDB |
Sybase Anywhere | jdbc:sybase:Tds:{<ipAddress>|<hostName>}:<port>/<databaseName> | com.sybase.jdbc3.jdbc.SybDriver |