Uploading the Database 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 package 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	Supported Driver Package
  MySQL	mysql-connector-java-8.0.24.jar
  Oracle	ojdbc8-12.2.0.1.jar

• A user with the CDL management permission has been created for the cluster with Kerberos authentication enabled. For details, see CDL User Permission Management.

Procedure

1. Access the CDLService web UI as a user with the CDL management permissions or the admin user (for the cluster where Kerberos authentication is not enabled). For details, see Logging In to the CDLService WebUI.
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.