atinkerersnotebook: Publish Queries As OData Document Sources For Users To Query In Excel

[Blog bot]

Источник: http://atinkerersnotebook.com/2014/0...uery-in-excel/
==============

Originally posted on Dynamics AX Tip Of The Day:

If you want to publish out data to the users so that they can create their own reports, or run their own analysis, there is in a simple and secure way built into Dynamics AX. You can register your queries as Document Data Sources and then they automatically become available through the OData service within Dynamics AX. Additionally, all of the default security that you put in place around the data will be respected by the service because you are using Dynamics AX to create the query.

No more ODBC connections, or even worse? unsecured Access databases.

How To Do It…


View original







Источник: http://atinkerersnotebook.com/2014/0...uery-in-excel/