Skip to main content

Celonis Product Documentation

Connecting to cloud based data sources

With the Celonis Platform you can connect to a number of cloud based source systems.

The below matrices highlight the available features for our commonly supported cloud based source systems. For other cloud based source systems, such as Amazon S3 and Google hosted products, see: Additional cloud based sources.

Cloud 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 the extractor builder.

not_planned.png

This feature is not currently supported and can't be used with the extractor builder.

Connection settings

The following connection setting features are supported based on the source system you're connecting to:

Feature

Feature Description

Salesforce

ServiceNow

SAP Ariba - Asynchronous API

SAP Ariba - Synchronous API

Coupa

Oracle Fusion Cloud BICC

Oracle Fusion Cloud REST

Extractor Builder REST

Extractor Builder OData

Pseudonmyzation algorithms

The applied pseudonymization algorithms can be selected in the advanced settings when configuring the connection.

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

Parallelization of requests

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
Table configuration

The following table configuration features are supported based on the source system you're connecting to:

Feature

Feature Description

Salesforce

ServiceNow

SAP Ariba - Asynchronous API

SAP Ariba - Synchronous API

Coupa

Oracle Fusion Cloud BICC

Oracle Fusion Cloud REST

Extractor Builder REST

Extractor Builder OData

Rename target table

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

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

Table joins

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

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

Filtering

Filters can be applied on table level based on the supported filtering operators. For a full overview, see: Supported filtering operators.

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

Filtering on dependent tables

Filters can be applied for dependent tables.

not_planned.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Available.png
Available.png
Supported filtering operators

The following filtering operators are supported based on the source system you're connecting to:

Column configuration

The following column configuration features are supported based on the source system you're connecting to:

Feature

Feature Description

Salesforce

ServiceNow

SAP Ariba - Asynchronous API

SAP Ariba - Synchronous API

Coupa

Oracle Fusion Cloud BICC

Oracle Fusion Cloud REST

Extractor Builder REST

Extractor Builder OData

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

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

Customize primary key

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

Available.png
not_planned.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 the Celonis Platform can be customized.

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

String length configuration

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

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
Extractor execution configuration

The following extractor execution configuration options are supported based on the source system you're connecting to:

Feature

Feature Description

Salesforce

ServiceNow

SAP Ariba - Asynchronous API

SAP Ariba - Synchronous API

Coupa

Oracle Fusion Cloud BICC

Oracle Fusion Cloud REST

Extractor Builder REST

Extractor Builder OData

Batch size configuration

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

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

Split job by days

Allows specifying a time range in days by which the extraction jobs are split.

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

Rolling page size

Allows specifying the buffer how many records should be rolled over from the previous request when doing pagination.

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

Partitioning

Allows the partitioning of an extraction into multiple batches based on applied filters.

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

Extract display value columns

Allows the retrieval of so-called display values for specific columns in ServiceNow. The display values are added as additional columns in the extraction.

not_planned.png
Available.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
not_planned.png
Metadata resolution

The following metadata resolution features are supported based on the source system you're connecting to:

Feature

Feature Description

Salesforce

ServiceNow

SAP Ariba - Asynchronous API

SAP Ariba - Synchronous API

Coupa

Oracle Fusion Cloud BICC

Oracle Fusion Cloud REST

Extractor Builder REST

Extractor Builder OData

Dynamic resolution of tables and columns.

The available tables and fields are resolved dynamically based on the information the extractor can retrieve.

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

Applies to master data API only.

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

Static definition of tables.

The extractor stores a static list of tables which are always available for extraction.

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

Applies to all API besides master data.

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

Static definition of columns.

The extractor stores a static list of columns which are always avialable for extraction.

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

Applies to all API besides master data.

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

Customize metadata.

Allows the customization of the metadata via a custom JSON configuration to add tables and columns to the existing static definition.

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

Clear cache function.

Provides the option to manually clear the cache of metadata (tables and columns) to refreh it with the next request.

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
Data processing and modification

The following data processing and modification features are supported based on the source system you're connecting to:

Feature

Feature Description

Salesforce

ServiceNow

SAP Ariba - Asynchronous API

SAP Ariba - Synchronous API

Coupa

Oracle Fusion Cloud BICC

Oracle Fusion Cloud REST

Extractor Builder REST

Extractor Builder OData

Delta load as replace merge.

Provides an option to delete records of nested tables that are not relevant to the parent table anymore during the delta load.

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

Data return format.

Allows to specify the format of the returned data and therefore the amount specifically for Coupa.-

  • All: All data is returned in full depth.

  • Shallow: Returns all data of the queried object including one-deep associations.

  • Limited: Limits the returned data of the associations to IDs only fo the one-deep associations.

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

Duplicate removal.

Duplicate records retrieved within the extraction are removed based on the defined primary key

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

Primary key propagation to nested tables of next level.

The primary key columns of a parent table are automatically propagated to its child tables of the next level.

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

Primary key propagation to nested tables of all levels.

The primary key columns of a parent table are automatically propagated to its child tables of all levels to ensure the tables can be joined correctly.

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

Ignore records with warnings.

Skips the records for which warnings are returned in the SAP Ariba extractions.

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

Debug.

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

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