Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using CDL/ Preparing for Creating a CDL Job/ Uploading a Driver File
Updated on 2024-11-29 GMT+08:00
View PDF
Share

Uploading a Driver File

Scenario

CDL is a simple and efficient real-time data integration service. It captures events from various OLTP databases and pushes them to Kafka. When creating a database connection on the CDLService Web UI, you can upload the database's driver file to the Web UI for unified management.

Prerequisites

  • You have obtained the driver JAR file of the database to be connected.
  • You have downloaded the driver package of the MySQL or Oracle data source from their respective official website. Table 1 lists the supported driver packages and their versions.
    Table 1 Drivers supported by MySQL and Oracle data sources

    Data Source

    Driver Packages

    MySQL

    mysql-connector-java-8.0.24.jar

    Oracle

    ojdbc8-12.2.0.1.jar

    The Oracle database is used only as the ThirdKafka data source.

  • A user with CDL management operation permissions has been created by referring to Creating a CDL User for the cluster with Kerberos authentication enabled.

Procedure

  1. Log in to the CDLService web UI as a user with CDL management operation permissions or as user admin (for clusters with Kerberos authentication disabled) by referring to Logging In to the CDLService Web UI.
  2. Choose Driver Management and click Upload Driver. In the displayed dialog box, select the prepared database driver file and click Open.
  3. On the Driver Management page, check whether the list of driver file names is displayed properly.

    • If a driver is no longer used or is mistakenly uploaded, click Delete to delete its driver file.
    • If there are a large number of driver files, you can enter a driver file name in the search box to quickly search for the desired driver file.