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. 

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

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.

Note

For information about databases tested for this BMC Atrium Orchestrator release, see BMC Solution and Product Availability and Compatibility Utility (SPAC requires a Support login). Log in using your support ID, search for BMC Atrium Orchestrator Platform and choose the current release to display compatibility information.

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

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
MySQLjdbc: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.jdbcUniversalDriver

PostgreSQLjdbc:postgresql://{<ipAddress>|<hostName>}:<port>/<databaseName>org.postgresql.Driver

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

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

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.