Skip to main content

Celonis Product Documentation

How do I set up a database connection using a custom JDBC driver?


You need to have an uplink server set up to be able to use a custom JDBC Driver connection since you need to supply the driver.

Step 1: Modify your network settings to allow the Extractor to communicate to the database and the EMS (responsible role: infrastructure admin)

Network settings

Source System

Target System




On premise Extractor server

Source system


depends on the database, typical ports are 5432 for Postgres and 30015 for HANA for example


JDBC connection from on-premise Extractor server to the database. The port is the one that you use normally to connect to the database.

On premise Extractor server




HTTPS connection from on-premise Extractor server to Celonis cloud endpoint. The IPs of the EMS depending on the cloud cluster (which can be seen in the URL) and they can be found in the section below.

EMS IP addresses depending on the cluster

The respective clusters use multiple IPs each so you need to enable all three of them in your firewall configuration for the connection between the on-premise Extractor server and the cloud endpoint.


EMS IPs as target












Step 2: Set up the database Extractor on-premise in your network (responsible role: infrastructure admin)

Please refer to the documentation on how to set up an on-premise Extractor.

For downloads, contanct Celonis Support.

If you would like to use a proxy (optional), please refer to the proxy configuration page.

Step 3: Download the JDBC Driver (responsible role: database admin)

Download the JDBC driver from the database portal or request it from your database provider.

Step 4: Create .jar directory (responsible role: infrastructure admin)

In your Extractor package directory, create a new directory calledjarand move the .jar file from your custom database driver to this directory.

Then, from your Extractor package directory, run the following command to run the Extractor:

java -Dloader.path=jar -Dspring.config.location=application-local.yml -jar connector-jdbc.jar

After that, check in the EMS if the uplink connection is successful (green status).

Step 5: Configure a user with sufficient permissions in your database (responsible role: database admin)

In order to extract from a database, you need to create or use an existing user which has read access to all tables which should be extracted. The user should also have access to the schema information_schema to read metadata for the tables to be extracted.

Step 6: Create a new on-premise database connection in Celonis (responsible role: data engineer)

Fill in your connection details of the database that you would like to connect to:

  1. Name: The name that you would like the data connection to have.

  2. Connection Type: Choose the name of the connection that you’ve uplinked.

  3. Database Type: Choose your database type or a database type that provides a similar syntax to your database.

  4. Configuration Type: Select Custom JDBC String and insert the JDBC string depending on your connection configuration. This can be retrieved from your database provider's website.

  5. Driver Class: Insert the class of your database driver.

  6. Maximum Parallel Table Extractions: Insert the number of tables that should be extracted in parallel.

  7. Schema Name: The schema to use. This is optional.

  8. Additional Properties: Optionally, configure additional properties (not needed here).

  9. Username: The username to connect to the database server.

  10. Password: The password of the user.