With the implementation of BC in the Cloud this level of access to Data is being lost, while the are options to use the Web Services (OData and SOAP) calls etc this doesnt provide the same level of access to the data that the customers are wanting.
We have a customer for example that has over 50 reports plugged into SharePoint using SSRS moving to BC Cloud these are going to be lost.
Replication services are not good enough as provide historic detail only not realtime, we need something that provides SQL like access to realtime data.
Power BI, Jet, CDATA, QLIK etc all have connectors but dont offer the same real time access replicating the old SQL level of access to tables.
Comments
Same as https://experience.dynamics.com/ideas/idea/?ideaid=4e3819a2-c59e-eb11-89ee-0003ff45c351
Category: General
Actually replication works for us. But the consultants are telling us we cannot get the business central connection for cloud database. Replicating so many tables through the Web Services is not possible for every table we need to replicate.
What are our other options for replication?
Category: General
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team