Uploading JDBC drivers from the IBM Cloud Pak for Data web client

An IBM Cloud Pak for Data administrator can upload JDBC driver files (JAR files) from the IBM Cloud Pak for Data web client.

Who needs to complete this task?
To complete this task, you must have the following permissions in Cloud Pak for Data:
  • Administer platform
  • Manage configurations
When do you need to complete this task?
Complete this task if you want to use a connector that requires a JDBC driver.

Common core services This feature is available only when the Cloud Pak for Data common core services are installed. The common core services are automatically installed by services that rely on them. If you don't see the Platform connections page, it's because none of the services that are installed on your environment rely on the common core services.

Before you begin

Important: Ensure that the JDBC driver files originate from a trustworthy source and does not contain malware or malicious code.

The upload will be included in audit records.

Procedure

To import a JDBC driver:

  1. Log in to Cloud Pak for Data.
  2. From the navigation menu, select Data > Platform connections.
  3. Click the JDBC Drivers files link.
  4. Browse for the JAR file or files that are required to connect to the data source.
  5. Click Upload.
    Important: Duplicate file names are not allowed. If you upload the same file again, for example, to upload a newer version of a file that has security fixes, (1) is appended to the file name.

    Users must edit connections that use the original JDBC driver file to use the new driver file.

What to do next

Best practice: Test the JDBC drivers that you import to ensure that they are compatible with the tools you use to connect to data sources. Example tools include Jupyter Notebooks, SPSS® Modeler, and DataStage®.

After you test the drivers, users can create a Generic JDBC connection to a data source from the Platform connections page, catalogs, or projects.