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 numberExample:
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:
Rest API:
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. |
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"