Help Center> Cloud Data Migration> User Guide> Link Management> Managing Drivers
View PDF

Managing Drivers

The Java Database Connectivity (JDBC) API provides programmatic access to relational databases. Using the JDBC API, applications can execute SQL statements and retrieve results. Before connecting CDM to a relational database, you need to upload a driver.

Prerequisites

How Do I Obtain a Driver?

Different types of relational databases need to adapt to different drivers. Download one of the drivers listed in Table 1 based on the preset driver name on the Driver Management page.

Table 1 Drivers

Relational Database Type

Driver Name

How to Obtain

Recommended Version
  • RDS for MySQL
  • MySQL

MYSQL

MYCAT

https://downloads.mysql.com/archives/c-j/

5.1.48. The driver of the 8.x version is not supported.

Oracle

ORACLE_6

ORACLE_7

ORACLE_8

https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

Obtain ojdbc8.jar in Oracle Database 12c Release 2 (12.2.0.1) drivers.
  • RDS for PostgreSQL
  • PostgreSQL

POSTGRESQL

https://jdbc.postgresql.org/download.html

42.1.4

IBM Db2

DB2

https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads

4.21.29
  • RDS for SQL Server
  • Microsoft SQL Server

SQLServer

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

4.2

Drivers for GaussDB and SAP HANA databases have been loaded to the system. You do not need to upload the drivers again.

Procedure

  1. Log in to the CDM management console.
  2. In the navigation pane, choose Cluster Management. Locate the target cluster and choose Job Management > Link Management > Driver Management. The Driver Management page is displayed.

    Figure 1 Uploading a driver

  3. 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.

Parent topic: Link Management