Skip to main content

Adding Custom JDBC Driver

· 6 min read
Pradeep Kadambar
Pradeep Kadambar
Creator

In this blog, we'll explore the process of adding support for additional database drivers in Governance and Lifecycle (G&L) version 8.0 and above. By default, G&L is shipped only with drivers for Oracle and Microsoft SQL databases.

Starting with G&L 8.0, all the individual JDBC connectors have been consolidated into a single generic database connector. This generic connector natively supports the following databases:

  • DB2
  • Oracle
  • Sybase
  • SQLServer
  • jTDS
  • MySQL
  • ODBC compliant databases

Steps

  1. Login to G&L console as system administrator.
  2. If you are creating a new connector proceed to step 4.
  3. For existing connector, click Test Connector Settings which should throw a driver class load error.

    img
  4. Go to AFX > Connector Templates and click on Generic Database.

    img
  5. Under File Content tab, click on Upload Jar.

    img
  6. Select the JDBC driver jar file and click OK.
  7. Go to the connector and edit the driver class and connector string as needed.
    img
  8. Click Test Connector Settings.