IFS10 data to Azure Data Lake

Shruti Reddy 21 Reputation points
2022-02-10T13:34:12.13+00:00

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.

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.
2,842 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 29,881 Reputation points Microsoft Employee
    2022-02-14T12:01:24.497+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful