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"