This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release
series where I am going hands on with the new version of Microsoft Dynamics GP.
The OData service allows for reporting services such as PowerBI to connect to Microsoft Dynamics GP. This post is going to focus on installing the OData service, but at the bottom of this post I’ve included details of a book, co-written by Mark Polino and I, in which Mark covered configuring OData for use with PowerBI.
To install the OData Service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under the Additional Products heading:
Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service”
Microsoft Dynamics GP 2018 R2 was released on the 2nd
October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.
The series index will automatically update as posts go-live in this series.
The last post covered the installation of the OData Service which means it is ready to be configured. OData isn’t realy my specialty area, so I am going to link to the Dynamics GP 2016 R2 Cookbook which Mark Polino and I wrote:
Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of this book covers the the configuration and use of OData Services:
- Activating OData for better external analysis
- Secure OData to control access
- Connecting OData to Excel for Business Intelligence
- Connecting GP to Power BI with OData
- Adding Power BI to the home page in Dynamics GP
One of the new features
introduced in Microsoft Dynamics GP 2016 R1 was an OData service
which provides a new way to report off Microsoft Dynamics GP. Before OData can be used, the service ust be installed from the Dynamics GP installation media.
Load the setup utility from the installation media and, under Additional Products, click on :
Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Install The OData Service”
The previous feature of the day introduced the OData Service installation. This one gives a brief overview of how the service works:
The main features of the OData service are:
- Ability to define end points for the service
- View GP data with any tool that supports OData feeds
Microsoft Dynamics GP 2016 R1 is seeing the introduction of a new complimentary product: an OData service which will allow reports on Dynamics GP data using any reporting tool (such as PoweBI) to be created:
The main features of are:
- Separate install under Additional Products
- Use GP Security to control access to data
- Supports tables, views and stored procs as data sources