Skip to main content

Celonis Product Documentation

Global Job Changes on Install: Data Connection Parameters

For each transformation inside global jobs, you will need to update the schema that the respective tables refer to. See below for the job that is required to be updated.

AR Credit

For the data transformation “Create View - All AR Collection Base Tables” within the global job “AR Collection Global Tables & Views”, you will need to change the data connection parameter from <%=DATASOURCE:SAP_CONNECTION%> to the data connection used in your AR Collection New data pool. You will need to replace the red parameter below with your data connection parameter.

DROP VIEW IF EXISTS "AR_EXTERNAL_RATING";
CREATE VIEW "AR_EXTERNAL_RATING" AS(
    SELECT * FROM <%=DATASOURCE:SAP_CONNECTION%>."EXTERNAL_RATING"
);

You can make that change by simply clicking on the data connection parameter at the bottom left, as shown in the below image.

Data_Connection_Parameters_.png

This update needs to be made in all transformations where there is a reference to another data connection within the all global jobs.