Data Extraction vs DataTransformation


#1

Hi Community

could someone explain me the difference between Data Extraction and Data Transformation?

Thanks
Gabby


#2

Hi Gabby!

Data Extraction is the procedure to obtain data from a source system into Celonis Cloud. In order to create a successful data extraction, tables and columns should be specified for the given process. Furthermore, filters can be used to only extract relevant data. Celonis Cloud provides a handful of Data Extractors ready to extract the data from the most popular source systems such as SAP ECC, ServiceNow and Salesforce.

Data Transformation is the procedure to clean and convert the extracted data into the right format needed to apply Process Mining. Data Transformation is done by applying SQL scripts into the extracted data.

The combination of both procedures is required to set up any Celonis Analysis.

Best,
Hugo