IFS10 data to Azure Data Lake

Question

Hi,

I would like to know how we export the historical data from IFS10 and Visma ERP's into Data Lakes to perform some combined ETL work in Azure Synapse and then build Power BI Reports.

Answer 1

Hi @Shruti Reddy ,

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

Azure data factory/Azure Synapse doesn't have connectors for IFS10 and Visma ERP at the moment. Click here to know about supported connectors.

But still you can consider making API Calls to IFS10 and Visma ERP from Azure Synapse or Azure data factory if that is feasible.

Web activity in Azure data factory/Azure Synapse pipelines helps to make API call.

Also, we can use HTTP connector or REST connector type datasets inside copy activity as source and sink data set type as Data lake storage.

I will also encourage you to log feedback for having connectors for IFS10 and Visma ERP's in below feedback portal. Product team closely monitor feedbacks there and consider for future releases.
https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

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

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

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