question

JeanWang-0590 avatar image
0 Votes"
JeanWang-0590 asked OuryBa-MSFT edited

connect SAP ByDesign with Azure SQL

Hi,

I am new to Azure. Our data is stored in SAP ByDesign. How can I export data from SAP ByDesign to Azure so that I can load them into Power BI direct.

I know it's possible to import data from SAP directly into Power BI, but this solution will not work for large database, therefore I want to use Azure to handle the data transformation and load clean data only to Power BI.

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JeanWang-0590 Thank you for posting your question. Are you looking to export SAP ByDesign to an Azure SQL Database?

Regards,
Oury

0 Votes 0 ·

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT edited

@JeanWang-0590
Please check this link. It might be helpful:
SAP Business ByDesign – API Overview | SAP Blogs

And for OData extraction from SAP with Azure Data Factory there is a excellent blog series by Bartosz:
Azure Synapse Pipelines and OData – Part 1 – The First Extraction | SAP Blogs

Please let me know if you have additional queries

Regards,
Oury

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JeanWang-0590 Checking if the above answer helped resolve the issue. If yes, please mark as accepted answer otherwise let us know how we can better assist you.

Regards,
Oury

0 Votes 0 ·

@JeanWang-0590 Checking if the above answer helped resolve the issue. If yes, please mark as accepted answer otherwise let us know how we can better assist you.

Regards,
Oury

0 Votes 0 ·

Hi Oury,

Thanks a lot for the help. The link to the Blog doesn't open.


Jean

0 Votes 0 ·

Hi @JeanWang-0590 Please find the offline copy attached 129206-odata-extraction-2.pdf 129214-odata-extraction-1.pdf][2]
Regards,
Oury

[2]: /answers/storage/attachments/129214-odata-extraction-1.pdf

0 Votes 0 ·