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 |
---|---|
You can connect to this database without supplying a custom JDBC driver, see: Connecting to a database. | |
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: |
The following database extractors are available in the Celonis Platform
Database type | Direct connection | Uplinked / On-premise connection |
---|---|---|
Amazon Athena | ||
Amazon Redshift | ||
Azure SQL | ||
Azure Synapse | ||
HANA (encrypted or unencrypted) | ||
IBM DB2 | ||
Intersystems Cache | ||
Note: A custom driver is needed to use Windows Authentication. | ||
MySQL | ||
Netezza | ||
OpenEdge | ||
Postgres (encrypted or unencrypted) | ||
SAP MaxDB | ||
Sybase | ||
Teradata | ||
Trino |