Sample JDBC driver connection URL formats

Knowing the connection URL format and driver class name enables a direct connection to the underlying data source utilizing the drivers supported by the IBM® Cognos® Virtual View Manager server. This section provides examples.

This table lists JDBC driver example URL formats and the corresponding driver class names for supported data sources.

Database / data source URL format / driver name Value
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
MySQL URL format: jdbc:mysql://<HOST>:<PORT>/<DATABASE_NAME>
  Driver name:  
Netezza® URL format: jdbc:netezza://<HOST>:<PORT>/<DATABASE_NAME>
  Driver name: org.netezza.Driver
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
Microsoft SQL Server URL format: jdbc:microsoft:sqlserver://<HOST>:<PORT>;databaseName= <DATABASE_NAME>;SelectMethod=<SELECT_MODE>
  Driver name: com.microsoft.jdbc.sqlserver.SQLServerDriver
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