Uploading JDBC drivers for lineage import (Watson Knowledge Catalog)

For some data sources, before you attempt to import lineage, you must upload specific JDBC drivers first.

The MANTA Automated Data Lineage for IBM Cloud Pak for Data lineage feature is optional. If you want to import lineage metadata, you must explicitly enable the feature first.

The following four connectors require JDBC drivers:

After you upload the driver, you must restart the respective manta-xxxx pod.

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, you must replace srv-version in the filename with the version of the Apache Hive server that you want to 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 four JAR files are necessary:

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

Download location: These JAR files are available 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 a JDBC driver.

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 Watson Knowledge Catalog