Multiple SAP Source Systems
It is often the case that more than one SAP system is required to get a complete end-to-end view of the supply chain. This can be split by regions, business units, company codes, etc. The Accounts Receivable data is flexible enough to support this, with just a few minor steps required.
Create a duplicate of the local data jobs by clicking on the three dots of the local job and then clicking duplicate. The duplication is importantbecause it allows the same template transformations to be shared across the different data jobs. Do not simply copy and paste the data transformations.
Change the Data Connection of the newly duplicated data job to your other source system
Select your data connection (or connections) from the drop-down
(Optional): Change the name of the data job, simply removing the (1), which is created during the duplicating process (skip this step if you do not mind the (1))
Run both (or as many as required) data jobs as usual, and remember to incorporate the new job into the Schedule
In all global AR jobs, update the different transformations to reference local jobs and combine them.
DROP VIEW IF EXISTS "AR_ACCOUNT"; CREATE VIEW "AR_ACCOUNT" AS( SELECT * FROM <%=DATASOURCE:SAP_CONNECTION_EU%>."ACCOUNT" UNION ALL SELECT * FROM <%=DATASOURCE:SAP_CONNECTION_APAC%>."ACCOUNT" );