vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dataartsstudio/umn/dataartsstudio_01_0132.html
Xiong, Chen Xiao f3ee29a3dd DataArts UMN 20230329 version 
Reviewed-by: Rechenburg, Matthias <matthias.rechenburg@t-systems.com>
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Xiong, Chen Xiao <chenxiaoxiong@huawei.com>
Co-committed-by: Xiong, Chen Xiao <chenxiaoxiong@huawei.com>
2023-05-11 17:09:25 +00:00

13 KiB
Raw Permalink Blame History

Managing Drivers

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 Link to an FTP or SFTP Server and the corresponding driver has been uploaded to the offline file server.

How Do I Obtain a Driver?

Different types of relational databases need to adapt to different drivers. You can obtain the JDK 8 .jar driver from the links provided in Table 1.

Table 1 Drivers

Relational Database Type

Driver Name

How to Obtain

Recommended Version
  • RDS for MySQL
  • MySQL

MySQL

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

mysql-connector-java-5.1.48.jar

Oracle

ORACLE_6

ORACLE_7

ORACLE_8

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

Driver packages of historical versions: https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc8/12.2.0.1/

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

https://jdbc.postgresql.org/download

postgresql-42.1.4.jar for JDBC 4.2

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

Driver packages:

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

Driver packages of historical versions:

https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#previous-releases

sqljdbc42.jar

Procedure

  1. Access the CDM console, choose Cluster Management in the navigation pane, locate the target cluster, and choose Job Management > Link Management > Driver Management. The Driver Management page is displayed.

    Figure 1 Uploading a driver

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

  3. (Optional) If you have uploaded an updated version of a driver, you must restart the CDM cluster for the new driver to take effect.
Parent topic: Managing Links