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

Available.png

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

not_planned.png

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)

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Active directory

not_planned.png
not_planned.png
Available.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png

OAuth

not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png

Service account authentication

not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png

Application default credentials

not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png

Personal access token

not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png

Key pair authentication

not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
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)

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Parallelization of table extractions

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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Timeout for database connection

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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Live data connection (using the Replication Cockpit)

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

not_planned.png
not_planned.png
Available.png
Available.png
not_planned.png
Available.png
Available.png
Available.png
Available.png
not_planned.png
not_planned.png
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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Views

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Synonyms

not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png
not_planned.png

Analytical views

not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png

External tables

not_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngAvailable.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.png

Snapshots

not_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngAvailable.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.png

Materialized views

not_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngAvailable.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.png
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.

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Time filter

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

Change date filter: Used for delta extractions.

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Filtering

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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
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

=

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

<; >

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

>=; <=

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

IN

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

NOT IN

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
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.

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Column selection

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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Column pseudonymization

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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Customize primary key

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

Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png
Available.png

Casting of data types

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

Available.png
Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

Column data types

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

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

Limit total records

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

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

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.

Available.pngAvailable.pngAvailable.pngAvailable.png
Available.png
Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

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

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

Batch size configuration

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

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png
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.

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

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.

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

INFORMATION_SCHEMA

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

not_planned.png
not_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngAvailable.pngAvailable.pngnot_planned.pngnot_planned.png

PG_CATALOG

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

not_planned.pngAvailable.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.pngnot_planned.png
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.

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

Debug

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

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.png

Extraction preview

Filters can be applied for dependent tables

Available.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngAvailable.pngnot_planned.pngAvailable.pngAvailable.pngAvailable.png