SAP By Design OData connection

Question

Hi all:

We use SAP by Design here at my company.  We also have ALDS gen 2 storage.  To get SAP data into ADLS, a odata query is written which generates a URL similar to he one here:

https://my123456.sapbydesign.com/sap/byd/odata/MMA_PRODUCTDEVELOPMENT_analytics.svc/RPZD36C7CDE0AFDA1FDE45B24FQueryResults?$select=CFISCALYEARPERIO,CFISCPER,CCOMPANY_UUID,CCOST_CTR_UUID,TCOST_CTR_UUID,KCCREDIT_CURRCOMP,KCDEBIT_CURRCOMP,CPROFITCTR_UUID,TPROFITCTR_UUID,CGLACCT,TGLACCT,CGLACCT_TC,TGLACCT_TC&$top=100000000&$format=json

My datalake team (actually just one person) takes that query and using datafactory and synapse is able to clean up the data and store it in an ADLS container where I can access using Alteryx.  Using datafactory, my datalake person can also schedule these 'data pulls' to occur whenever needed.

I have 10 datasets, each URL looking similar to the one above.

Unfortunately, my datalake person is leaving soon (insert crying emoji here), and I'm trying to see how I can take the URL and extract the data.  Any and all help will be appreciated.

If anyone can explain step by step how to do this...and keep the IT Jargon out of it, I would be truly appreciative.

Thanks.

-prpatel

IAJ1966 · Answer

Hi @prpatel  - The easiest way to get to the data you need from a SAP ByDesign system is via the add-in software from DVW Analytics.

We provide read and write capability to pretty much any object in the system directly from within the Designer (or Server).  It is safe and very easy to use.

Try it for free using the link below.  Let me know when/if you register and I'll be sure to get you assistance from our support team on your specific use cases.

https://www.dvwanalytics.com/free-trial.html

Best Regards

Ian