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:

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

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

Hi Stefano,

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

Regards
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

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

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.

Helpful resources

Quick Links

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans