Skip to main content

Celonis Product Documentation

1.4 Global Job Changes: Data Connection Parameters

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:

image86.png

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.

image94.png

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.