Introduction to Dynamics GP OData

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.

Keep learning. Keep building.

Explore AI, agents & Microsoft technology.

I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.

Subscribe on YouTube →

Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert