| 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 | |
