Getting started with on-premise JDBC Extractors
Set up an on-premise JDBC Extractor to establish a secure Uplink connection between your local relational database management system (RDBMS) and the Celonis Platform. This centralized architecture extracts on-premise transactional data securely without altering your corporate firewall settings.
Establishing this connection enables continuous data pipelines from legacy infrastructure to Celonis. For example, extracting historic procurement or shipping logs from an on-premise database allows process miners to surface execution gaps, isolate throughput bottlenecks, and monitor vendor compliance in real time.
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.
Before selecting an installation track, verify your database support requirements:
Connection type | Requirement | Application scenario | Link |
|---|---|---|---|
Native uplink | Packaged Celonis configuration | Standard relational databases supported natively out-of-the-box. For a list of supported databases, see: Supported database types. | |
Custom JDBC | Manual JAR file injection | Legacy, proprietary, or heavily modified database instances. | Connecting using a custom JDBC driver with an Uplink connection |
If Uplink connections are natively supported:
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.
Start the JDBC Extractor in your environment.
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.
To use a custom JDBC driver:
Install your database's custom driver JAR in the JDBC Extractor directory.
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.
Start the JDBC Extractor in your environment.
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.