Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
The Adam Shilton Podcast
Challenges of Connecting to ERP Systems for Data Extraction
Connecting directly to ERP systems for data extraction presents challenges due to the complexity of finance systems. Finance systems are primarily designed for efficient data storage rather than easy reporting. For instance, accessing specific data like 'good received, not invoiced' from ERP systems requires expertise to navigate through years of transactional data. Even if data can be extracted using tools like Power Query, the intricate database structure of ERP systems makes it complex to convert for practical use in Excel. Hence, sometimes it is more beneficial to work with system-generated outputs rather than attempting to restructure the database for direct data extraction.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
