The Generic JDBC target connector is designed for target databases that QueryGrid has no dedicated connector. Use the Generic JDBC connector to connect your Analytics Database environment with other ecosystem products. Data types from the target database are mapped to Analytics Database types based on the JDBC types returned by JDBC metadata APIs. Not all data types from the target database are necessarily supported by the JDBC metadata APIs.
To use the Generic JDBC connector and connect to any database, you must upload the JDBC 4.0 driver or later to QueryGrid Manager and load the connector software to the driver node.
The Generic JDBC connector uses JDBC APIs to pull the metadata off the target tables and expects the JDBC driver to support these APIs. Due to the generic nature of the connector, full or partial functionality with every JDBC-compliant database available should not be expected.