Celonis Product Documentation

For each of the transformations inside global jobs, you will need to update the schema to which the respective tables make reference. Refer to the screenshot below for a list of the jobs that are required to be updated:

Jobs to be Updated

For the “Create View - All AR Collection Base Tables” data transformation 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 parameter in bold below with your data connection parameter.

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

To make this change, click on the data connection parameter at the bottom left, as shown below.

Data Connection Parameter

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