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 Microsoft 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	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. jdbcUniversalDriver
PostgreSQL	jdbc: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.

Database URLs and drivers

Comments