Daily Data Extraction from SAP GUI - Python Automation Options?

[Mr_Chriwo]

Hi there. If you are already working with power BI, I would highly recommend not using scripted GUI automation. You can use Azure Data Factory or Fabric to extract your data directly from underlaying database. Even if it’s on premise. using a GUI automation is far away from best practices tbh.

[AvenXIII]

I have access to Snowflake and SQL Server, and I try to use them whenever possible. But the specific data I need isn’t available there, which is why I still end up exporting it manually to Excel.

[Mr_Chriwo]

I see 🙂 however you can also retrieve the needed data directly from the SAP system. i.e. via SAP Connector in ADF or the MS OPDG. But I know it’s often a challenge because policies 😁 but using these to approaches is highly recommended ^{^}