Uploading a CDM Link Driver

The Java Database Connectivity (JDBC) provides programmatic access to relational databases. Applications can execute SQL statements and retrieve data using the JDBC API.

Before connecting CDM to a relational database, you need to upload the JDK 8 .jar driver of the relational database.

Prerequisites

A cluster has been created.
You have downloaded one of the drivers listed in Table 1.
(Optional) An SFTP link has been created by referring to FTP/SFTP Link Parameters and the corresponding driver has been uploaded to the offline file server.

How Do I Obtain a Driver?

Select a driver version that adapts to the database type. Note that the version of the uploaded driver does not need to match the version of the database to be connected. Obtain the JDK8 .jar driver of the recommended version by referring to Table 1.

**Table 1** Drivers
Relational Database Type	Driver Name	How to Obtain	Recommended Version
RDS for MySQL MySQL	MySQL	http://downloads.mysql.com/archives/c-j/	mysql-connector-java-5.1.48.jar
Oracle	ORACLE_6 ORACLE_7 ORACLE_8	Driver packages: http://www.oracle.com/database/technologies/appdev/jdbc-downloads.html Driver packages of historical versions: http://repo1.maven.org/maven2/com/oracle/database/jdbc/	ojdbc8.jar for version 12.2.0.1 NOTE: New versions (for example, Oracle Database 21c (21.3) drivers) are not supported. If they are used, the schema name cannot be obtained during job creation.
RDS for PostgreSQL PostgreSQL	POSTGRESQL	http://mvnrepository.com/artifact/org.postgresql/postgresql	postgresql-42.3.4.jar for version 42.3.4
YASHAN	YashanDB 23.2.4	http://download.yashandb.com/download	23.2.4 Linux x86: yashandb-23.2.4.100-linux-x86_64.tar Linux ARM: yashandb-23.2.4.100-linux-aarch64.tar
KingBase	POSTGRESQL	http://mvnrepository.com/artifact/org.postgresql/postgresql	postgresql-42.2.9.jar for PostgreSQL 42.2.9
GaussDB	POSTGRESQL	GaussDB JDBC driver: Search for "JDBC Package, Driver Class, and Environment Class" in GaussDB Documentation, select the document corresponding to the instance version, and obtain gsjdbc4.jar by referring to the document.	Obtain gsjdbc4.jar from the release package of the corresponding version.
RDS for SQL Server Microsoft SQL Server	SQLServer	http://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#previous-releases	sqljdbc42.jar
Dameng database	DM	http://eco.dameng.com/download/ Obtain DmJdbcDriver18.jar from the DM installation directory /dmdbms/drivers/jdbc.	DmJdbcDriver18.jar
Doris	DORIS	http://downloads.mysql.com/archives/c-j/ Restrictions on using the Doris driver: If the Doris version is earlier than 2.0, the MySQL driver 5.x is supported. If the Doris version is 2.0 or later and HTTPS is enabled, the MySQL driver 8.0 or later must be used for links in CDM. In addition, the streamLoad port must be enabled. By default, CDM 400 or later supports data writing in streamLoad mode. Therefore, you must enable the streamLoad port. NOTE: You are advised to use a CDM cluster of version 24.4.8B040 or a later version. Otherwise, an error may occur during connection creation.	mysql-connector-java-5.1.48.jar
POSTGRESQL_KINGBASE	POSTGRESQL_KINGBASE	http://www.kingbase.com.cn/rjcxxz/index.htm	Driver version matching the KingBase database version
GBASE	GBASE8A GBASE8S	GBASE8A: http://www.gbase.cn/download/gbase-8a?category=DRIVER_PACKAGE GBASE8S: http://www.gbase.cn/download/gbase-8s-1?category=DRIVER_PACKAGE	GBASE8A: For GBase 8a MPP Cluster V9 version, obtain gbase-connector-java-9.5.0.7-build1-bin.jar. GBASE8S: For GBase 8s V8.8 version, obtain gbasedbtjdbc_3.5.1_3X1_3.jar.

Procedure

Access the CDM console, choose Cluster Management in the navigation pane, locate the target cluster, and choose Job Management > Link Management > Driver Management. On the Driver Management page, upload a driver.

Figure 1 Uploading a driver
Click Upload in the Operation column and select a local driver.

Alternatively, click Copy from SFTP in the Operation column and configure the SFTP Link name and Driver File Path.
(Optional) If you have uploaded an updated version of a driver, you must restart the CDM cluster for the new driver to take effect.