Importing JDBC driver files for data sources

An administrator can upload JDBC drivers (JAR files) for a data source to the web client. One or more JDBC drivers are required for the Generic JDBC connection as well as some of the predefined connection types.

Before you begin

Check the prerequisites for the connection type to learn if a JDBC driver is required.
Required permissions
To import or delete JDBC drivers, you must have the following permissions:
  • Administer platform
  • Manage configurations
Important: Make sure that the JAR file originates from a trustworthy source and that it does not contain malware or malicious code. The upload will be audited.

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.

Procedure

To import a JDBC driver:

  1. Log in to Cloud Pak for Data.
  2. From the navigation menu, select Data > Platform connections.
  3. Open the JDBC drivers tab.
  4. Browse for the JAR file or files that are required to connect to the data source.
  5. Click Upload.

What to do next

Users can create a Generic JDBC connection to a data source from the Platform connections page, catalogs, or projects.
Note: Test the custom JDBC drivers that you import to ensure they are compatible with the tools you use to connect to data sources. Example tools include: Jupyter Notebooks, SPSS® Modeler, DataStage®, and Data Refinery.