Database / data source |
URL format / driver name |
Value |
Default port |
MySQL |
URL format: |
jdbc:mysql://<HOST>:<PORT>/<DATABASE_NAME> |
3306 |
|
Driver name: |
com.mysql.jdbc.Driver |
|
Microsoft SQL Server |
URL format: |
jdbc:microsoft:sqlserver://<HOST>:<PORT>;databaseName= <DATABASE_NAME>;SelectMethod=<SELECT_MODE> |
1433 |
|
Driver name: |
com.microsoft.jdbc.sqlserver.SQLServerDriver |
|
Oracle (thin), 9i, and 10g |
URL format: |
jdbc:oracle:thin@<HOST>:<PORT>:<DATABASE_NAME> |
|
|
Driver name: |
oracle.jdbc.driver.OracleDriver |
|
Oracle type2 (OCI) 9i, and 10g |
URL format: |
jdbc:oracle:oci:@<DATABASE_NAME> |
|
|
Driver name: |
oracle.jdbc.OracleDriver |
|
Virtual View Manager |
URL format: |
jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN>&dataSource=<DATABASE_NAME>Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default <DOMAIN> value unless an LDAP or dynamic domain user is negotiating the connection. |
|
|
Driver name: |
cs.jdbc.driver.CompositeDriver |
|
DataDirect Mainframe |
URL format: |
jdbc:neon:; APNA=<APP_NAME>; CPFX=<CATALOG_PREFIX>; DBTY=<DBMS_TYPE>; HOST=<HOST>; PORT=<PORT>; SUBSYS=<DATABASE_NAME>; TRLT=NO; DTFM=ODBC; |
|
|
Driver name: |
com.neon.jdbc.Driver |
|
|
Driver name: |
COM.ibm.db2.jdbc.net.DB2Driver |
|
DB2® v8 (type_2) |
URL format: |
jdbc:db2:<DATABASE_NAME> |
|
|
Driver name: |
Driver Name: |
|
DB2 v8 (type_4) |
URL format: |
jdbc:db2://<HOST>:<PORT>/<DATABASE_NAME> |
|
|
Driver name: |
com.ibm.db2.jcc.DB2Driver |
|
DB2 z/os v8 (type_4) mainframe |
URL format: |
jdbc:db2://<HOST>:<PORT>/<DATABASE_NAME> |
|
|
Driver name: |
com.ibm.db2.jcc.DB2Driver |
|
IBM Informix® |
URL format: |
jdbc:informix-sqli://<HOST>:<PORT>/<DATABASE_NAME>: informixserver=<IBM Informix instance name>;user=<user_name>; password=<password> |
|
|
|
The informixserver variable is the name of the IBM Informix instance, and not the server host name, and <user_name> and <password> are recognized by the IBM Informix server. |
|
|
Driver name: |
com.informix.jdbc.IfxDriver |
|
Netezza® |
URL format: |
jdbc:netezza://<HOST>:<PORT>/<DATABASE_NAME> |
5480 |
|
Driver name: |
org.netezza.Driver |
|
Sybase |
URL format: |
jdbc:sybase:Tds:<HOST>:<PORT>/<DATABASE_NAME> |
|
|
Driver name: |
com.sybase.jdbc3.jdbc.SybDriver |
|
Teradata |
URL format: |
jdbc:teradata://<HOST>/DBS_PORT=<PORT>/DATABASE= <DATABASE_NAME>/CHARSET=UTF8,COMPAT_DBS=true |
|
|
Driver name: |
com.ncr.teradata.TeraDriver |
|