Introduction to Dynamics GP OData

Leave a comment

OData was introduced to Dynamics GP in the GP 2016 release. To set up OData, open the GP installation and select OData:

Click Accept:

Enter the GP server name and GP system database name:

Select the port for the OData service to run on and a certificate for SSL access, which is required:

Click Install:

Once installed, log into Dynamics GP. You will see OData in the GP menu under Tools->Setup->System->OData. Select Configure OData Service:

Select OData and enter the name of the OData Service URL:

Next, go to Data Sources.

You will see views for each database:

As well as the option to see Tables and Stored Procedures:

And you can change the product from Dynamics GP to other products:

Click Add Objects to add any additional objects:

Now go to Publish Data:

Here you will see the selected objects. Select the publish checkbox. Note the URL to access the OData feed:

Next, ensure the GP OData Service is running in Windows Services:

Now, browse to the URL. You will see the OData feed.

You can now use OData with Dynamics GP.


Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube


Leave a Reply

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