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.
Comments
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.
Category: Reporting and Analytics
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.
Category: Reporting and Analytics
Perhaps Dynamics might consider somehow deploying SQL Data Sync?
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data
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.
Category: Reporting and Analytics
We're about to go live with a large Dynamics 365 instance and for us, careful use of BYOD exports (that we have to trigger with a custom build mechanism outside of Dynamics) and with lots of custom entities to speed up change tracking, this was possible. But its not realtime and it's fragile. It feels like we've gone back to the log-shipping days circa SQL Server 2000.
Category: Reporting and Analytics
My company definitely needs this functionality
Category: Reporting and Analytics
I think, it very necessary, it will save time for Microsoft and customers.
every day, refresh database and waiting for SLA ...etc
Category: Reporting and Analytics
Being able to automatically create a copy for support/testing/debugging purposes is crucial and requires a copy of live production data - extremely strange that MS do not offer this ability. Or should we place manual database refresh requests every day in order to accomplish this?
Category: Reporting and Analytics
I do believe, Microsoft provides the access using Azure SQL DB. However, this is an additional service which customers should buy. I do agree, that Microsoft should come up with a plan for the same. A very common question where customers use a 3rd party BI tool and would like to have access to D365 data.
Think about it MS team :)
Category: Reporting and Analytics
Cannot vote up. If I could vote for this a thousand times I would. Especially, now that Microsoft is planning on "hardening" the test environment as well.
Category: Reporting and Analytics
Yes, i am agree with the other people.
This are the data of our customer and he wants to have access to them.
Directly and in the way he wants.
Not in the way MSFT want it.
So a copy in realtime and the possibility to make direct query to this copy is a must have.
Create Query adhoc for customers need is the fastest way to get information out of the system. All customer want to have this possibility.
So, please make this requirement real for D365!
Category: Reporting and Analytics
Administrator 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.