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 ofjdbc: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. | |
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 |
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
Log in or register to comment.