Skip to main content

Celonis Product Documentation

Additional database sources

When connecting the following supported database types to the Celonis Platform, you can either connect directly to the database or use an uplinked / on-premise connection.

  • Direct connection: Use this when you want to allow the Celonis Platform to directly access your database. For more information about direct database connections, see: Connecting to a database

  • Uplinked connection via an on-premise extractor: Use this when you don't want to or can't allow the Celonis Platform to directly access your database. The connection is then established using an on-premise extractor, allowing you to continuously fetch data from your database and send it to the Celonis Platform. For more information about uplinked or on-premise database connections, see: Connecting to a database

In many cases, you can connect to these databases just using the extractor provided by Celonis, however there some that require you to download the JDBC connector or driver from the database provider. In these cases, consider the below connection types:

  • Connecting using a custom JDBC string: You can connect to your database using a custom JDBC string, allowing you to extend the settings offered by our extractor builder. This is useful for when you want to configure SSL, add certificates, or use .jks files for your database connection.

    To learn how to connect to your database using a custom JDBC string, see: Using custom JDBC string.

  • Connecting using a custom JDBC driver: You can connect to your database using a custom JDBC driver, allowing you to extend the settings offered by our extractor builder. This requires you to use an uplinked connection (using an on-premise extractor), with the custom driver being supplied by you.

    To learn how to connect to your database using a custom JDBC driver, see: Using custom JDBC driver.

Supported database types

When viewing the below table, there are two status indicators:

Status indicator

Status description

Available.png

You can connect to this database without supplying a custom JDBC driver, see: Connecting to a database.

not_planned.png

You can only connect to this database by supplying a custom JDBC driver or using a custom JDBC string.

For more information about creating a connection using a custom JDBC driver, see: Using custom JDBC driver

And for information about creating a connection using a custom JDBC string, see:

Using custom JDBC string.

The following database extractors are available in the Celonis Platform

Database type

Direct connection

Uplinked / On-premise connection

Amazon Athena

Available.png
Available.png

Amazon Redshift

Available.png
not_planned.png

Apache Hive / Apache Hadoop

Available.png
not_planned.png

Azure SQL

Available.png
Available.png

Azure Synapse

Available.png
Available.png

Cloudera Impala

Available.png
not_planned.png

Databricks

Available.png
Available.png

Google BigQuery

Available.png
not_planned.png

HANA (encrypted or unencrypted)

Available.pngnot_planned.png

IBM DB2

Available.pngAvailable.png

Intersystems Cache

Available.pngAvailable.png

Microsoft SQL

not_planned.pngAvailable.png

MSSQL

Note: A custom driver is needed to use Windows Authentication.

Available.pngAvailable.png

MySQL

Available.pngnot_planned.png

Netezza

Available.pngAvailable.png

OpenEdge

Available.pngAvailable.png

Oracle

Available.pngAvailable.png

Postgres (encrypted or unencrypted)

Available.pngAvailable.png

SAP MaxDB

Available.pngnot_planned.png

Snowflake

Available.pngAvailable.png

Sybase

Available.pngnot_planned.png

Teradata

Available.pngnot_planned.png

Trino

Available.pngAvailable.png