Hello,
As I read here we have to do ETL if we want to use Business Central Online Data in Azure SQL and in Microsoft Fabric. I don't understand why, because it's all in the cloud. It should be possible to bring all in a VNET e.g. by a Private Endpoint. Can you please change this so that we can use our data without Incremental loads and ETL development?
"For Business Central on-premises, you can just read directly from the environment database. This option isn't available for Business Central online, so establishing this type of integration could block you from migrating from on-premises to the online version.
For Business Central online, the only supported option for reading data is using APIs." (https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/service-overview)
"Business Central uses Azure SQL Database as the database technology for its environments.
Azure SQL Database, Microsoft's cloud-based relational database service, is used as the best-of-breed service for transactional workloads of Business Central." (https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/service-overview)
Regards
Christoph
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