PowerShell - Data without a Database

Since databases became common with ERP systems over 20 years ago, developers could always say trust that whatever else happened, they would always have SQL. But now, that’s not the case. With the advent of SaaS in general and Cloud-Based Business Central in particular, life isn’t so simple. You now need to know about things like “ODATA and “APIs”. In this presentation, we’ll explain how these new approaches work. We’ll review the basics of JSON and RestAPIs and show you how you can do (almost) everything you need with PowerShell. We’ll even show you how to load this data into SQL Server (if you really want to.)

Bio

Adam Jacobson is founder and president of Red Three Consulting. He has over 20 years of experience in ERP and BI consulting. Adam has particular expertise in complex accounting and other multi-company and international reporting challenges. Technically, he focuses on Microsoft Technologies like SQL Server (including SSRS and SSAS Tabular) and PowerShell. Prior to founding Red Three, Adam was a partner in United Systems Consultants where he ran its 30-person Lawson software practice.