The Dynamics GP OData in Kuwait Service opens up secure access to your GP data for external applications by leveraging the existing GP security module.
Once deployed, GP Administrators will be able to grant users access to SQL objects using the native ODATA security role IDs within the User Security Setup.
GP users granted data access will be afforded the opportunity to create powerful reports and integrations through tools such as Power BI and Excel. In this series of posts, we will go step-by-step through the process of enabling ODATA.
Dynamics GP ODATA in Kuwait Set Up
- 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 Microsoft 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
Implementation of OData in GP 2016 is to make it easier for the front office to manage, meaning that you don’t always need your IT team or consultants to step in for security. Because of that, there are new roles in GP specifically designed for OData.
OData is a great new feature in GP 2016 which enables you to expose GP data to any OData compliant application, such as Excel or Power BI, and make it available securely over the internet.