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:

In the setup utility under Additional Products, click on GP OData Service and select Install on the popup menu:

Microsoft Dynamics GP 2018 RTM setup utility

Accept the terms of the License Agreement and click Next:

OData Service for Microsoft Dynamics GP: License Agreement

Enter teh full SQL Server instance name in the Server Name field; if using a named system database, change the Dynamics GP System Database name.

Select an authentication emthod and click Next:

OData Service for Microsoft Dynamics GP: SQL Connection Information

The OData Service needs a Port, security certificate and service account details.

The Port will default to 443, but as I am installing this onto my web server, which is using port 443 for the web client, I have opted to change the Port.

I have used the same self-signed certificate I used for the web client, and then entered the service account details (ensure the service account has the necessary permissions to create and start a service).

Click Next to continue:

OData Service for Microsoft Dynamics GP: OData Service

Click Install to begin the installation:

OData Service for Microsoft Dynamics GP: Ready to Install

Once the installation is complete, click Exit:

OData Service for Microsoft Dynamics GP: Installation Complete

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

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) –
Your Email (required) –

1 thought on “Hands On With MDGP 2018 RTM: Install GP OData Service

  1. Pingback: Comment

Leave a Reply

Your email address will not be published. Required fields are marked *