Skip to main content
Kinetic Community

Database Bridges

Each of the specific database bridges are extensions of the Generic JDBC Bridge.  Java Database Connectivity (JDBC) is a Java technology that provides an abstract inferface for querying against different database systems, and requires basic configuration dependent on the target database vendor and version.

Details

The Generic JDBC Bridge can be used as a template for implementing a Kinetic Bridge for any database that supports JDBC connections.  The specific database bridges all extend the Generic JDBC Bridge with the following minor modifications:

  1. The configurable properties displayed on the AdminConsole are changed to use the database specific terminology.
  2. The .jar files necessary to connect to the specified database are included within the Bridge.
  3. The Bridge search methods are modified to improve compatibility (most notably, each database has a slightly different SQL syntax for executing server side pagination).
IDF guide rendered from cache
 
Topics
  • The Generic JDBC Bridge can be used as a template for implementing a Kinetic Bridge for any database that supports JDBC connections.  The Generic JDBC Bridge can be deployed as a usable database Bridge, however it requries the necessary JDBC library file to be added to the Java classpath in order to function.
  • The DB2 Bridge provides access into the IBM DB2 database.  It is an extension of the Generic JDBC Bridge, and has been customized to simplify the deployment and implement DB2 specific features.
  • The MSSQL Bridge provides access into the Microsoft SQL Server database.  It is an extension of the Generic JDBC Bridge, and has been customized to simplify the deployment and implement MSSQL specific features.
  • The Oracle Bridge provides access into the Oracle SQL Server database. It is an extension of the Generic JDBC Bridge, and has been customized to simplify the deployment and implement Oracle specific features.