Skip to main content

Celonis Product Documentation

Global Job Changes on Install: Data Connection Parameters

For each of the transformations inside of global jobs 2.0, 3.0, and 4.0, you will need to update the schema that the respective tables make reference to.

See below for the 3 jobs that are required to be updated:

IM_Connector_Global_Jobs.png

For example, the data transformation “Create View: O2C_VBAP” within the global job 2.0, you will need to change the data connection parameter from <%=DATASOURCE:SAP_ECC_-_ORDER_TO_CASH_SAP_ECC%> to the data connection used in your O2C data pool. You will need to replace the bold parameter below to your data connection parameter.

DROP VIEW IF EXISTS "O2C_VBAP";
CREATE VIEW "O2C_VBAP" AS (
    SELECT 
    VBAP.*
    , KWMENG * ZAEHL / NENNR AS KWMENG_CONVERTED
    , MSSIE AS MEINS_CONVERTED_TO
    , T006.DIMID AS CONVERSION_DIMENSION
    ,"VBUP"."GBSTA" AS 'SALES_ORDER_ITEM_STATUS'
FROM <%=DATASOURCE:SAP_ECC_-_ORDER_TO_CASH_SAP_ECC%>."O2C_VBAP" AS VBAP -- imported from O2C data pool

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

IM_Connector_Global_Jobs_2.png

Warning

This update is required inside of all transformations where there is a reference to another data connection within the 3 global jobs.