We were recently building a data model with on-prem Dynamics data mostly using the OData feed (v8.2). This article only scratches the surface of what is possible with OData (including update/write functions and much more complex queries than those shown…
Guest Post By: Tim Rodman
There is finally an ERP product that gets it, that embraces Power Pivot, Power BI, and the more than 800 million users of Microsoft Excel.
“What Power Pivot did to Excel, Acumatica is doing to the world of ERP”.
Acumatica recently announced the ability to securely connect to Acumatica ERP data through OData
This is huge. It’s as if two worlds are colliding, creating a good kind of explosion.
You: “So, wait a second, what is ERP?”
Me: “Great question, I should probably back up for a minute.”
ERP stands for Enterprise Resource Planning and it is the computer system that ties all of the departments in your organization together.
If you work with Power Pivot, there is a very good chance that you also work with ERP data.
SAP, Oracle, Microsoft Dynamics, Infor, Epicor, Sage, and NetSuite are all examples of ERP systems.
Many of the ERP systems in companies today are very old and very ugly. The problem is that they are expensive to replace so they continue to exist through a patchwork of duct tape fixes that have been cobbled together over the years.
However, ERP systems contain a virtual Fort Knox of data that can lead to incredible insights if analyzed correctly (with Power Pivot of course).