web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Question: Whether are ...

Business Central forum

Question: Whether are or not any restriction in Business central to connect Azure SQL data warehouse?

(0) Share

Report

Report

Posted on by Community Member

I have an opportunity that prospect needs Business Central cloud version and Azure SQL data warehouse. In this regard, I have a question.

Can user access Business Central database and create data integration path to Azure SQL data warehouse?
If user cannot access Business Central database directly, I'd like to know how and who create integration.

Best regards,

Yasuhiro Ito

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

You cannot access D365BC database in the SaaS version. Simply, you cannot see it.

To create integration with Azure SQL DW, you need to create a custom integration layer that, for example, reads data from D365BC via web services and loads data into Azure SQL DW tables. This is the same techniques that you can use for on-premise versions for example.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Stefano,

I appreciate for your quick suggestion. I'll recommend on-premise versions.

Regards

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans