Upload Generic Connector Software | QueryGrid - Uploading Generic JDBC Connector Software - 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
You can upload the Generic JDBC connector software using one of the following options:
  • Viewpoint, version 22.10 or later
  • QueryGrid Manager REST API

Using Viewpoint

You can use the QueryGrid Portlet to upload the Generic JDBC connector software when running Viewpoint version 22.10 or later. See Uploading Connector Software.

When browsing to select the genericjdbc connector software, be sure to select the Upload JDBC driver for generic connector check box. Supported formats are jar, tar.gz, and zip.

The name you provide as the JDBC Custom Name is added to the re-bundled genericjdbc package.

Using REST API

The Generic JDBC connector must be uploaded with the JDBC 4.0 driver or later of the target database. When uploaded, QueryGrid Manager repackages the JDBC driver and the Generic JDBC connector and renames the file in the following format:
tdqg-genericjdbc-connector-connector version-custom name-build number
Example:
tdqg-genericjdbc-connector-02.19.00.00-redshift.3.5.04-1
Use the QueryGrid Manager REST API /api/v1/ software to upload the Generic JDBC connector. The API requires the following three arguments:
Argument Description
file Path for the Generic JDBC connector.
jdbcDriverFile Path for the JDBC driver.

Supported formats are: jar, tar.gz, and zip

jdbcDriverName A custom name to append to the repackaged connector name.
Rest API:
curl -X POST "QGM Cluster address:9443/api/v1/software" -H "accept: application/json" -H "Content-Type: multipart/form-data" -F "file=@path to generic connector package;type=application/x-gzip" -F jdbcDriverFile=”@path to driver file;type=application/x-gzip”  -F "jdbcDriverName=custom name"
Example:
curl -X POST "https://qgm12345.labs.teradata.com:9443/api/v1/software" -H "accept: application/json" -H "Content-Type: multipart/form-data"  -F "file=@/tmp/tdqg-genericjdbc-connector-02.19.00.00-1.tar.gz;type=application/x-gzip" -F “jdbcDriverFile=@/tmp/redshift-jdbc42-3.5.04.tar.gz;type=application/x-gzip” -F "jdbcDriverName=redshift.3.5.04"