Call 855-644-2677 for Microsoft Dynamics GP / SL Support, Training, and Implementation

Setting Up Users and Security for the OData Service for Microsoft Dynamics GP 2016

August 31, 2016 12:18 pm Published by

Setting Up Users and Security for the OData Service for Microsoft Dynamics GP 2016Microsoft Dynamics GP 2016 was released in May, and for the last few months we have been going over the dozens of new features it delivers, first as introductions, and now in more detail. In our last blog entry for Microsoft Dynamics GP, we started taking a closer look at another new feature that we have previously introduced,  the new OData service that you can deploy to democratize your Microsoft Dynamics GP data. The OData service enables you to manage access to your Microsoft Dynamics GP data for GP users so that they can build rich interactive reports in Power BI and Excel.

In our last entry, we covered how you deploy the OData service. Once you’ve finished installing it, you’ll need to ensure that your security in Microsoft Dynamics GP is set up properly. When your users connect to OData, they will do so using their Windows credentials, so you need to ensure that their GP user accounts are associated with their Windows credentials. You can do this in the User Setup screen, under the Directory Account tab. Then you want to set each user up with the proper role-based security access in the User Security Setup screen.

In the Security Task Setup screen, Microsoft has added a new type called “SQL Objects.” It includes “Stored Procedures” and “Views.” This enables you to grant access to these items if you decide to build custom security tasks and roles for OData reporting purposes.

About MIG & Co.

MIG & Co. is a professional consulting firm that specializes in the implementation of business management software solutions, including Microsoft Dynamics GP, SL, and CRM. We automate business processes to ensure that our customers work efficiently. MIG is a Microsoft Dynamics Gold Certified Partner.

Ready to learn how Microsoft Dynamics can help your business?

Talk to an Expert

Your privacy is important to us. MIG & Co. will never sell, lease, or share your information.

MIG & Co.