Global Job Changes AR Cash App
Data Connection Parameters
For each transformation inside global jobs, you must update the schema of the respective tables reference. See below for the job that is required to be updated.
 |
For the data transformation “Create View - All CashApp Base Tables” within the global job “D1 - AR Cash Application 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 must replace the bold parameter below with your data connection parameter.
DROP VIEW IF EXISTS "AR_PAYMENT";
CREATE VIEW "AR_PAYMENT" AS(
SELECT * FROM <%=DATASOURCE:SAP_CONNECTION%>."PAYMENT"
);You can make that change by clicking on the data connection parameter at the bottom left, as shown in the image below.
