SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Reading data from ERP E2 and Push to Azure SQL.
![](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(153.6, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Uma
491
Reputation points
Hello,
May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server.
Looking for detailed steps of connecting to E2 System.
I am planning to use python scripting as it is open source.
Do I need to Install any driver.
what all configuration details we have to paas in the scripting.
Once Data got extracted , I will perform transformation and push to Azure SQL, on top of it Powerbi reports will run.
Which will be easier Python or SSIS and why ?
The major challenge I am facing how to integrate with External E2 ERP.
Appreciate your help very much.
Thanks a lot
SQL Server Integration Services
1 answer
Sort by: Oldest
-
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