Connecting Azure to SAP Business ByDesign

Question

Hi,

Could someone very roughly explain the core structure of a basic process on getting data from SAP Business ByDesign (Cloud system) to Azure.
Basically what i want to do, is to query data from SAP Business ByDesign and write it to a table in Azure every day on a specified time. I then want to access this table in Azure with Power BI.

• Can Azure make queries to SAP Business ByDesign or does SAP Business ByDesign need to send write commands to Azure? SAP Business ByDesign supports Odata queries and has an integration platform.
• What technical skills are needed to perform the goal above? (SQL for example or knowledge of Odata)?

Basically i'm trying to figure out what do we need to perform this. For example, i would like to know that "Azure can make queries to SAP via Odata on a scheduled basis. You need to know Odata structure and in addition, you need to know SQL in order to write data queried with Odata to Azure SQL database."

Answer 1

You can use Azure Data Factory to query data from SAP Business (source) and put it on a sink (in this case Azure SQL) as explained on this tutorial. This PDF document will give you more information on how to integrate SAP with Azure Data Factory,

Alternatively, you can also use SAP Business ByDesign APIs to extract information and then you can use REST services to write that data on Azure SQL Database.

Answer 2

Hi @Carlsberg789 Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding of the above ask is that you are trying to find a process on getting data from SAP Business ByDesign (Cloud system) to Azure.

In addition to @Alberto Morillo 's answer the first part can be achieved once you find the OData source that serves you the data you need, you can either create a pipeline in ADF to write data to a table, or you could even process the whole dataset using PBI dataflows. It’s usually a “pull” type of communication which means Azure sends requests for data.

Regards,
Oury