Introduction to Dynamics GP OData

1 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.

THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
 

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

 

ABOUT CARL DE SOUZA

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

carldesouza.comLinkedIn Twitter | YouTube

 

One Response to Introduction to Dynamics GP OData

Leave a Reply

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