Skip to main content

Getting started with on-premise JDBC Extractors

The on-premise JDBC Extractor offers several options for Uplink connections to the Celonis Platform. This page provides a describes the general steps based on the supported connection type.

Note

Direct connections do not require an on-premise JDBC Extractor. For information on Direct connections, see Direct connections.

For information on which connection types are supported for specific databases, see Supported database types.

Connecting using a native Uplink connection

Navigate to Supported database types, find your database in the table, and confirm if Uplink connections are natively supported.

Note

If the database is not supported with a native Uplink connection, see Connecting using a custom JDBC driver with an Uplink connection.

If Uplink connections are natively supported:

  1. Confirm the server you want to install the JDBC Extractor on meets the prerequisites.

  2. Download the JDBC Extractor.

  3. Configure the JDBC Extractor.

    Note

    When configuring the JDBC Extractor, at a minimum, you must configure the uplink values, and if you are using a proxy, the proxy values.

    After configuring the minimum required configurations for your environment, it recommended (for troubleshooting purposes) to run the JDBC Extractor and test the connection between it and the Celonis Platform. After you confirm the connection is successful, incrementally continue to configure other required values, restarting the JDBC Extractor and testing the changes in Celonis Platform with each change.

  4. Start the JDBC Extractor in your environment.

  5. Navigate to Supported database types, and find your database in the table. Select the link to navigate to your database's documentation, and follow the instructions there for connecting to the Celonis Platform.

Connecting using a custom JDBC driver with an Uplink connection

If the table on Supported database types shows Uplink connections are not natively supported, you must use a custom JDBC driver with the on-premise Celonis JDBC Extractor to establish an Uplink connection.

To use a custom JDBC driver:

  1. Confirm the server you want to install the JDBC Extractor on meets the prerequisites.

  2. Download the JDBC Extractor.

  3. Install your database's custom driver JAR in the JDBC Extractor directory.

  4. Configure the JDBC Extractor.

    Note

    When configuring the JDBC Extractor, at a minimum, you must configure the uplink values, and if you are using a proxy, the proxy values.

    After configuring the minimum required configurations for your environment, it recommended (for troubleshooting purposes) to run the JDBC Extractor and test the connection between it and the Celonis Platform. After you confirm the connection is successful, incrementally continue to configure other required values, restarting the JDBC Extractor and testing the changes in Celonis Platform with each change.

  5. Start the JDBC Extractor in your environment.

  6. Navigate to Supported database types, and find your database in the table. Select the link to navigate to your database's documentation, and follow the instructions there for connecting to the Celonis Platform.