Skip to main content

Celonis Product Documentation

Supported database connections (JDBC)

With the Celonis Platform you can connect to a number of SQL databases via a JDBC connector.

The below matrices highlight the available features for our commonly supported databases connections. If the database you're using isn't covered here, you can find further details of other supported databases here: Additional database sources.

Database extractor feature matrix

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

Status Indicator

Status Description

A status indicator showing that a feature is available.

This feature is supported and can be used with this database.

A status indicator showing that a feature is not available and not planned for release.

This feature is not currently supported and can't be used with this database.

Authentication types

The following authentication types are used when connecting to databases:

Feature

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

Database credentials (username and password)

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Active directory

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.

OAuth

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.

Service account authentication

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.

Application default credentials

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.

Personal access token

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.

Key pair authentication

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
Connection settings

The following connection settings are available for databases:

Feature

Feature Description

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

Pseudonmyzation algorithms

The applied pseudonymization algorithms can be selected in the advanced settings of the extractor builder:

Supported Algorithms:

  • SHA-1SHA-256

  • SHA-256(No Salt)

  • SHA-512

  • SHA-512(No Salt)

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Parallelization of table extractions

The max. number of parallel requests the extractor makes can be customized in the advanced settings when configuring the extractor.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Timeout for database connection

Timeout for all database connections created in this connection (specific to this connection only).

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Live data connection (using the Replication Cockpit)

The ability to establish a live connection to the database using the replication cockpit.

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
Object types

The following object types are available for databases:

Feature

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

Tables

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Views

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Synonyms

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.

Analytical views

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is available.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.

External tables

A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is available.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.

Snapshots

A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is available.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.

Materialized views

A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is available.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.
Object configurations

The following object configurations are possible for databases:

Feature

Feature Description

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

Table joins

It is possible to join the extracted table on another table during the extraction.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Time filter

Creation date filter: Used to restrict the number of records to be extracted.

Change date filter: Used for delta extractions.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Filtering

Filters can be applied on table level based on the supported filtering operators (documented below).

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
Supported filters

The following filters are supported by databases:

Feature

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

=

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

<; >

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

>=; <=

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

IN

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

NOT IN

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
Extraction and column configuration

The following column configuration options are supported by databases:

Feature

Feature Description

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

Rename target table

The name of the table which is created in Celonis can be customized as part of the table configuration.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Column selection

The subset of columns that should be extracted can be selected.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Column pseudonymization

The columns that should be pseudonymized with the chosen algorithm can be selected.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Customize primary key

Addtitional columns can be added to the default primary key definition.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.

Casting of data types

The data type with which the extracted columns are inserted to Celonis can be customized.

A status indicator showing that a feature is available.
A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Column data types

The column data type with which the extracted columns are inserted to Celonis.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Limit total records

The total number of records to be extracted can be limited using this feature.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Binary data type handling

Table column with binary data type can be represented in two ways:

  • UTF- 8

  • HEX_NOTATION

Depending on the value specified here the binary value will be converted.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.
A status indicator showing that a feature is available.
A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Maximum string length configuration

Allows the modification of the default length (80 characters) of String-type columns.

This is configured using the parameter: MAX_STRING_LENGTH

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Batch size configuration

Allows specifiying the batch size (in records) for one extraction request.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.
Metadata resolution

The following metadata resolution options are supported by databases:

Feature

Feature Description

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

DRIVER_METADATA

This metadata source is supported by all source systems and mostly it is the default one. Here the driver internally runs the metadata Query against the source system and fetches the result set.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

SAMPLE_QUERY

This metadata source is supported by all source systems. This also works the same as driver metadata, only the query used is different.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

INFORMATION_SCHEMA

This metadata source is supported mainly by Oracle system. And it's a default metadata source for Oracle 11g.

A status indicator showing that a feature is not available and not planned for release.
A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.

PG_CATALOG

This metadata source is supported by Amazon Redshift. And it's a default metadata source.

A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is available.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is not available and not planned for release.
Data processing and resolution

The following data processing and resolution options are supported by databases:

Feature

Feature Description

Amazon Athena

Amazon Redshift

Azure SQL

Azure Synapse

Google BigQuery

HANA (encrypted or unencrypted)

Microsoft SQL

Oracle 11g

Oracle

Databricks

Snowflake

Duplicate removal

Duplicate records retrieved within the extraction are removed based on the defined primary key and ordering columns.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Debug

Allows the enablement of a time-limited debug mode in the extraction settings to expose additional log messages.

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.

Extraction preview

Filters can be applied for dependent tables

A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is not available and not planned for release.A status indicator showing that a feature is available.A status indicator showing that a feature is available.A status indicator showing that a feature is available.