Dear Community member,
Now I am planning how to integrate on-premise custom systems with Celonis, based on new client’s expectation.
In case I cannot use standard app connection (like SAP ECC) via Extractor, next choice is Data push API or file upload.
In these scenarios, I need to decide transformation task is performed, either in Ceonis or outside of Celonis like below flow.
(Source systems = on-premise custom systems) -> (transformation system = ?) -> (Load system = Celonis IBC)
Could you share your experience of,
1.whether transformation task is performed in/outside of Celonis, and why ?
2.do you reuse Activity name of SAP ECC to smoothly unite transformations of multiple source systems ?
3.if your answer of #1 is outside of Celonis, did you use some ETL tool (Talend, KNIME etc.) for managing transformation ?
For the moment, I will choose to perform transformation outside of Celonis, due to optimizing human resource (transformation script can be developed by client’s developers not familiar with Celonis).
In case of O2C/P2P processes, I will provide list of SAP O2C/P2P Activities for client’s developer to map to client systems.
OSS ETL tools are available to filter/join tables in source systems, and may be possible to call API or just download files.