So, here'' s a brief trial of the SAP connectivity.
we'' re offering public sneak peek on July 1st. What you see is an ADF pipe produced.
from templates which we deliver to our clients to reduce their development initiatives..
The pipeline initially does a duplicate activity in SAP, adhered to by a mapping information flow that processes.
the adjustments and updates a SQL table in Synapse. As you can see, some sorting, deduping,.
as well as other actions are required for that. The pipeline tons data from.
SAP'' s buying table EKKO. Now, in the tracking device, you can see that I''
ve. already run the pipe for one, for very first time to do a preliminary load.Let '
s verify on the Synapse.
side that we see some information in our Synapse table. In a couple of seconds, you will certainly see that.
16,221 records have been copied over. On the SAP side, we can verify that this.
very first pipe run has actually started the Delta procedure. On this feed, we will now be able.
to read modification as we carry out in SAP purchasing. So, allow'' s relocate on to the SAP investing in.
application to develop a new purchasing order. For the purpose of simpleness, I will utilize.
an existing acquiring order which you can see on the left as a layout. I'' m. changing the order quantity.And save the acquiring version. Let me additionally copy the order number so. that we can later on recover it in Synapse. Now, back on the ADF side. Allow ' s. cause the pipeline once again. And also after a couple of seconds, we will certainly see that the copy task has actually read precisely.
one row from the SAP system. And also a few seconds later on, the mapping.
information circulation has actually prospered as well.So, now we can move on to the Synapse side to.
validate that we have recovered the appropriate information. Let'' s first do a “” SELECT MATTER( *) “” once more.
to see that one even more row is included in the table currently and you see that'' s exactly what we.
expected. And also to show that this is truly the freshly produced order, allow'' s modify the.
pick statement to “” SELECT * FROM”” the table here with a where condition filtering system out the purchase.
order number, we simply replicated on the SAP side. And as anticipated, we will locate our.
order just produced in SAP.
