Configure JDBC Target Connector | QueryGrid - Configuring the Generic JDBC Target Connector - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem

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.