How to extract data from ERP to SQL using azure data factory

Anirudh Mounasamy 101

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?

AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2022-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 30,676 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 30,676 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
Robert Miller 0 Reputation points

2024-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.

1 answer

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