Microsoft Dynamics 365
I have a need to access a ready-only copy of the AX business database that is sync'd in real time. We can then sync this database to our own azure sql database for reporting purposes.
on 7/30/2019 3:41:40 PM
We are looking into adding more data into Azure Data Lake including the option to add Entities and key tables.
This is an ABSOLUTE MUST HAVE feature. The larger, more active tables do not support incremental loads and, as table sizes grow, full loads become impractical. Creating custom entities adds unnecessary development overhead and inhibits our ability to respond to requests in a reasonable time frame.
Reporting and Analytics
Must have feature when customer have no access to its data and that these are must have data in the Customer's data warehouse
This is a low hanging fruit that will make a lot of people happy including me!
When I tell our accountants that Power BI can only give me aggregations of data and can't give me the numbers behind the totals they see, I get looks of total disbelief. So another vote to bring D365 reporting into the current century :-)
Utterly critical and very much required. As an SME we don't have the time or budget to customise all of the data entities we need, making our current reporting very limited. Having access to the entire database would be massively beneficial
Must have feature especially when our customers want to use ERP data alongwith other datasources..
Could not agree more, our company needs this functionality for a smooth business operations.
Could not agree more, our company definitely needs this functionality! A lot of the entities is so stripped, that they can not be used in external reports.
The current implementation of this concept adds additional pain and thus reduces reliabilty in all integration scenarios. Many customers are not willing to pay for accessing their own data.
Perhaps Dynamics might consider somehow deploying SQL Data Sync?
This does put system load on the Dynamics database, but it can't be more than what customers are putting on with lots of BYOD export jobs with change tracking, surely.