Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,595 questions
How to extract data from ERP to SQL using azure data factory
Anirudh Mounasamy
101
Reputation points
I need to extract data from Sage ERP (which will be updated automatically every month)and transfer it to the SQL database using azure data factory. But I don't know much about ERP. Also, I can't share any data. Anyone can please help me or give me an idea about it? It's urgent.
I can't try to do anything because now I don't have any credentials If I send my client documentation for this process. They will ask me to work on their system. If anyone is good at these works please help me.
Can anyone explain me the process?
{count} votes
-
AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee2022-11-10T12:23:25.143+00:00 Hi @Anirudh Mounasamy ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
As I understand your ask , you want to fetch data from ERP system to SQL database using ADF pipeline. Please let me know if my understanding is incorrect.
Unfortunately, there is no connector available for Sage ERP currently in ADF to load the data directly from Sage ERP.
However, SAP table connector is available to load data from SAP ERP system
Kindly check the list of available connectors here: Supported data stores
Please Note : To move data to/from a data store that Data Factory does not support, or to transform/process data in a way that isn't supported by Data Factory, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline.
-
AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee
2022-11-14T05:17:35.203+00:00 Hi @Anirudh Mounasamy ,
Just following up to see if the above response was helpful. -
AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee
2022-11-28T05:16:24.383+00:00 Hi @Anirudh Mounasamy ,
We haven't heard anything after the response. Could you please take out time to read through the above suggestion and let us know if it helped. Thanks -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 99%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Robert Miller 0 Reputation points2024-01-10T14:07:33.96+00:00 I realize this is a very old thread but I thought I would answer anyway. Depending on the version Sage ERP uses SQL as its database. There are many ways to copy the data from one SQL DB to another.finding the data in the various tables is the difficult part.
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more