Database URLs and drivers
TrueSight Orchestration 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 TrueSight Orchestration.
TrueSight Orchestration supports Hibernate-compatible databases. While the databases listed in this table are known to work with TrueSight Orchestration, 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 |
|---|---|---|
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 |
MySQL | jdbc:mysql://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.mysql.jdbc.Driver |
MySQL 8 | jdbc:mysql://{<ipAddress>|<hostName>}:<port>/<databaseName> | com.mysql.cj.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 |
Related topic