Skip to main content

Prerequisites for on-premise JDBC Extractors

From April 2026: Java requirement for on-prem JDBC extractor

Starting April 2026, upgrading to the latest on-premise JDBC extractor will require Java 25. This is not a breaking change, as customers who do not update their extractor to the latest JDBC version will not be affected. We will update this page with the exact release version once it is finalized. No immediate action is required, but upgrades should be planned in advance.

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

JDBC Extractor system and software requirements

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

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.

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

Note

The operating system listed below are only suggestion. You may use any operating system which is capable of running Java 17 or later.

  • You must have administrative rights for setup.

  • 64-bit operating system:

    • 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, and we recommend using the newer version if possible.

    Important

    Starting with JDBC extractor version 3.6.0 (2025-03-03), at least Java 21 is required.

  • 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 use multiple IPs each, so you need to enable all that apply to your cluster in your firewall configuration to connect the on-premise extractor server and the cloud endpoint.

For a complete list of inbound and outbound Celonis Platform IP addresses to be allowlisted if needed, 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 JDBC string.

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

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