Skip to main content

Prerequisites for on-premise JDBC Extractors

The following sections explain the prerequisites connecting the Celonis Platform to your database using the JDBC on-premise extractor for Uplink connections.

Note

Once you have met these prerequisites, proceed to Downloading on-premise JDBC Extractors.

JDBC Extractor system and software requirements

The following system and software requirements must be met by the extractor server:

Hardware requirements

  • Virtual machine or physical server.

  • CPU: Minimum of an Intel Xeon processor with four cores.

  • RAM: minimum of 16 GB.

  • Disk space: minimum of 110 GB. This can be on a separate partition or network drive.

  • The server needs to be located in the same network as the source systems that you're going to connect.

Operating system and software requirements

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

  • You must have administrative rights for setup.

  • 64-bit operating system:

    Note

    The following operating systems are only suggestions. Any operating system capable of running the required Java version for your JDBC Extractor package can be used.

    • Windows Server: 2019 and 2022. The earliest supported version is 2012 R2.

    • Ubuntu: 18.04 LTS (tested version). Newer versions are supported.

    • Red Hat: Red Hat Enterprise Linux 7 (tested version). Newer versions are supported.

    • SUSE: SUSE Enterprise Linux (SLES) 12 and 15 (tested version). Newer versions are supported.

    • Oracle: Oracle Linux 6 and 7 (tested version). Newer versions are supported.

  • Java: Versions 17 to 21 are supported. We recommend using the newer version if possible.

    Important

    Starting with JDBC Extractor version 3.6.0 (2025-03-03), Java 21 or higher is required.

    Upcoming Java 25 Requirement for OPCs and OPEs

    Starting April 2026, upgrading to the latest On-Premise Client (OPC) or On-Premise Extractor (OPE) will require Java 25. Current installations will remain unaffected (non-breaking change) unless you choose to update to the newest OPC or OPE versions. We will provide finalized Java requirements once the release versions are confirmed.

    While no immediate action is required, we recommend planning your Java environment updates now to ensure a smooth transition.

  • For the JDBC Extractor, on Windows download and install the Microsoft Visual C++ 2015-2019 Redistributable Package (x64).

Network settings for uplink connections

The following network settings apply for Uplink connections (via the on-premise extractor):

Source system

Target system

Port

Protocol

Description

On-premise Extractor server

Source system

Depending on the database, typical ports are 5432 for PostgreSQL and 30015 for HANA for example.

TCP

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

On-premise Extractor server

Celonis Platform

443

TCP

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

Celonis Platform IP addresses depending on the cluster

Celonis Platform clusters each use multiple IPs. To connect the on-premises extractor server to the cloud endpoint, you must enable all applicable cluster IPs in your cluster's firewall configuration.

For a complete list of inbound and outbound Celonis Platform IP addresses to be allowlisted, see: Allowlisting Celonis domain names, IP addresses, and third-party domains

User requirements

To successfully extract data, ensure your database user account meets the following requirements:

  • Read access: The user must have SELECT privileges for all tables and views targeted for extraction.

  • Metadata access: The user must have permission to query the information_schema. This allows the connector to retrieve essential table structures and schema metadata.

  • Authentication: Ensure the user is configured for the specific authentication method required by your database.

    Tip

    If your database requires a specific authentication method, depending on the database and authentication method, it may be possible to use a custom JDBC string.

Refer to your database's documentation for specific details on how to implement these requirements.