Extrcting data from SAP FMS into Azure Synapse

Sanjay Dinda 1 Reputation point
2022-11-24T09:24:36.153+00:00

Hello All, Hope you are doing great! I am working now to extract information from SAP FMS into Azure Synapse. I would like to extract master data as well as transactional data but only the data modified in past few days. Please can anyone advise me with the best practices. Also something the volumes will be relatively high when it comes to core transactional informaiton. Currently I am concentrating on the Purchase order specific informaiton. Any help would be high appreciated.

May thanks in advance!!

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
118 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,253 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 37,566 Reputation points Microsoft Employee
    2022-11-28T11:34:59.013+00:00

    Hi @Sanjay Dinda ,

    Thank you for posting query in Microsoft Q&A Platform.

    You can consider using Azure data factory or Azure Synapse Pipelines to implement your solution.

    ADF or Synapse Pipelines has some out of box connectors which helps you to connect with different sources to fetch data and load to destinations. Click here for full list of connectors.

    From SAP family, at this below are the connectors available. Click here to more details.
    264747-image.png

    Since you we don't have in built connector for SAP FMS, we should consider writing our own code in Azure Functions and run that azure function using Azure Function Activity. We can also consider using custom activity, which helps to move data to/from a data store that the service does not support. Click here to know more.

    Between, you can also consider raising idea using below link to have SAP FMS connector in product. PG team closely monitor ideas and consider them for future releases.
    https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c?query=hubspot

    Hope this helps. Please let me know if any further queries.

    -------------

    Please consider hitting Accept Answer button. Accepted answers helps community as well.