Hands On With MDGP 2018 RTM: Configure & Use OData Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

In the last post, I covered the installation of the GP OData Service. However, I am not going to cover the configuration and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • 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

I am planning to do some work with Odata in the near future, and am likely to blog about it when I do.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index

Hands On With MDGP 2018 RTM: Install GP OData Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

The next of the additional products I am going to install, is the GP OData Service; this allows external tools, such as PowerBI, to connect to Dynamics GP.

To install the GP OData Service, launch the Microsoft Dynamics GP 2018 setup utility from the downloaded media. Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

Continue reading “Hands On With MDGP 2018 RTM: Install GP OData Service”

“Service ‘GP OData Service (GPODataService) failed to start. Verify that you have sufficient privilages to start the system services.”

Microsoft Dynamics GPWhen working on the Hands On With Microsoft Dynamics GP 2016 R2 series of posts, I installed the OData Service. While doing so, I received an error:

Service 'GP OData Service' (GPODataService) failed to start. Verify that you have sufficient privileges to start the system services.

Microsoft Dynamics GP OData Service

Service 'GP OData Service' (GPODataService) failed to start. Verify that you have sufficient privileges to start the system services.

This type of error is not atypical when working with new service accounts, which I was on the series of posts as it was a brand new virtual machine I was working on. Fortunately, with experience of working with Microsoft Dynamics GP for nearly 14 years, I have a little experience of resolving this type of error.

In fact, I have blogged about it a couple of times. The first was back in March 2013; the instructions are towards the bottom of the post.

Hands On With Microsoft Dynamics GP 2016 R2: Configure & Use OData Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I am not going to cover the configuraion and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • 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

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2: Install GP OData Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

The OData Service for Microsoft Dyamics GP allows connections to be made to the Dynamics GP databases in order to run reports. To install the service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install GP OData Service”

Hands On With Microsoft Dynamics GP 2016 R1: Install The OData Service

Microsoft Dynamics GPOne 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 :

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Install The OData Service”

MDGP 2016 R1 Feature of the Day: OData Service

The previous feature of the day introduced the OData Service installation. This one gives a brief overview of how the service works:

OData Service

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

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: OData Service Deployment

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:

OData Service Deployment

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

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index