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.
Surprising that two years later, there is still no solution for this must-have capability. Putting Entity Store into a Data Lake has only a very limited number of use cases.
Reporting comes at the end of an implementation project. Only then, you discover that D365FO lacks the capabilities to supply adequate solutions for your business. By then you have invested so much in the implementation that there is no way back.
Also makes you wonder why there is still no solution…
Reporting and Analytics
I and Customers really want to access Read only D365 FO database to make own report as own way, because:
When I want to use Power BI to get data from D365 FO, and I very surprise that we have two way:
- Use Data entity and Odata
- Use Entity Store
Customers always to drill down to see behind the Total amount, If we use Data entity can adapt requirement, but it could not be best practice for large transaction, very slow.
And then, dedicated BI Team with traditional way to query to secondary readonly AX database, and they will not have SQL query task to do like before, and put query developed effort to AX developer team to make data entity or measurement as data source for BI Team, and BI Team have only work to do Data Visual.
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.
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.