Uploading JDBC drivers for lineage import (IBM Knowledge Catalog)

For some data sources, you must upload specific JDBC drivers before you can import lineage.

The MANTA Automated Data Lineage for IBM Cloud Pak for Data lineage feature is an optional feature and must be explicitly enabled if you want to import lineage metadata.

The following connectors require JDBC drivers:

You must restart the respective manta-xxxx pod after you upload the driver.

See Importing JDBC drivers for the procedure and required permissions to upload the JAR file to Cloud Pak for Data. Important: By default, uploading JDBC driver files is disabled and users cannot view the list of JDBC drivers in the web client. An administrator must enable users to upload or view JDBC drivers.

Amazon Redshift

Upload the AWS Advanced JDBC Driver.

Download location: https://github.com/awslabs/aws-advanced-jdbc-wrapper/releases/download/1.0.1/aws-advanced-jdbc-wrapper-1.0.1.jar
Target location in the manta-admin-gui-xxxxx-xxxx pod: /opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Command :

oc cp <jar> <manta-admin-gui-pod-id>:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Example :

oc cp aws-advanced-jdbc-wrapper-1.0.1.jar manta-admin-gui-7b7558dcdc-dd94s:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Apache Hive

Upload a set of JDBC drivers. For the Apache Hive JAR files, replace srv-version in the filename with the version of the Apache Hive server that you use.

Download location

JAR file	Repository
hive-jdbc-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc/
hive-common-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-common/
hive-metastore-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-metastore/
hive-serde-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-serde/
hive-service-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-service/
hive-service-rpc-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-service-rpc/
hive-shims-srv-version.jar	https://mvnrepository.com/artifact/org.apache.hive/hive-shims/
libthrift-0.9.3.jar	https://mvnrepository.com/artifact/org.apache.thrift/libthrift/0.9.3
zookeeper-3.4.6.jar	https://mvnrepository.com/artifact/org.apache.zookeeper/zookeeper/3.4.6
curator-client-2.12.0.jar	https://mvnrepository.com/artifact/org.apache.curator/curator-client/2.12.0
curator-framework-2.12.0.jar	https://mvnrepository.com/artifact/org.apache.curator/curator-framework/2.12.0
hadoop-shaded-protobuf_3_7-1.1.1.jar	https://mvnrepository.com/artifact/org.apache.hadoop.thirdparty/hadoop-shaded-protobuf_3_7/1.1.1
commons-lang-2.6.jar	https://mvnrepository.com/artifact/commons-lang/commons-lang/2.6

Target location in the manta-admin-gui-xxxxx-xxxx pod: /opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext/

Command :

oc cp <jar> <manta-admin-gui-pod-id>:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Example :

oc cp hive-jdbc-3.1.2.jar manta-admin-gui-7d45bb44cc-7s9vv:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext/

IBM Cognos Analytics

Upload the following Cognos Analytics JDBC drivers.

The following JAR files are required:

axis.jar
axisCognosClient.jar
jaxrpc.jar
axisCrnpClient.jar

Download location: You can find these JAR files in your Cognos Analytics SDK installation directory <COGNOS_SDK_INSTALL_DIRECTORY>/sdk/java.
Target location in the manta-admin-gui-xxxxx-xxxx pod: /opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Command :

oc cp <jar> <manta-admin-gui-pod-id>:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Example :

oc cp axis.jar manta-admin-gui-7b7558dcdc-dd94s:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Teradata

Upload the following files:

terajdbc4.jar
tdgssconfig.jar

Download location: https://downloads.teradata.com/download/connectivity/jdbc-driver
Target location in the manta-admin-gui-xxxxx-xxxx pod: /opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Command :

oc cp <jar> <manta-admin-gui-pod-id>:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Example :

oc cp terajdbc4.jar manta-admin-gui-7b7558dcdc-dd94s:/opt/mantaflow/cli/scenarios/manta-dataflow-cli/lib-ext

Learn more

Parent topic: Administering IBM Knowledge Catalog