D365 FinOps Azure and On-premise SQL server

(0) Share

Report

Posted on by AX Ankit

Hi All,

Is it possible to export/import data from D365 Finance & Operations on Azure and an on-premise SQL server?.

Any help is highly appreciated.

Thanks!

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello AX Ankit,

The cloud and on-prem versions have a data management workspace that you can use for exporting and importing data.

That's a standard functionality.

For additional information, please check out the respective MS docs websites.

Best regards,

Ludwig

Was this reply helpful? Yes No
AX Ankit 60 on at

Like (0)

Report

Hi Ludwig,

Thanks for your response. But what I meant was a bit different.

I have an D365 fin ops instance which is on Azure. I want to export and import data into this instance from a SQL server which is hosted on premise.

Was this reply helpful? Yes No
MarinaAX 730 on at

Like (0)

Report

Hi Ankit,

Have you looked into that article: "...Copy database from a OneBox environment to an Azure Sql Environment" (https://blog.johanpersson.nu/?p=2754)?

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Ankit,

If you are looking for entire DB move, see link below:

https://blogs.msdn.microsoft.com/axsa/2018/05/23/how-to-copy-a-database-from-cloud-tier-1-to-on-premises-in-dynamics-365-for-finance-and-operations/

Thanks,

Satish Panwar

Please take time to click yes against the answer that help guide you in right direction.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

If you are looking to move partial data, use Data management to export from azure DB and then import via DM in on-premise environment. You can't do any data movements directly through SQL.

Thanks,

Satish Panwar

Please take time to click yes against the answer that help guide you in right direction.

Was this reply helpful? Yes No
AX Ankit 60 on at

Like (0)

Report

Hi Satish,

Let me explain the scenario with an example.

I have CustGroup table in D365 instance on Azure and I have got another table 'CustomerGroup' in a SQL server which is on premise. I want a real time integration between these two tables. So, if a new record is created in 'CustGroup' table in D365 , the data should flow to 'CustomerGroup' table in SQL server and vice versa.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

There is no solution for bidirectional integration between D365FO and external SQL database

You can export data entities to BYODB. But only Azure SQL is mentioned in the docs. OnPrem connection will work, some people have tried it, but since it's not officially supported it could break any time.

docs.microsoft.com/.../export-entities-to-your-own-database

The other direction you would have to implement yourself, and you need to use data entities, not D365 tables. Any conflict management and other problems of bidirectional integration you would need to handle yourself.

Was this reply helpful? Yes No
AX Ankit 60 on at

Like (0)

Report

Hi Nikolaos,

Yes, BYOD is supported with Azure DB. But it's only an export option and cannot be used to import data back to D365. Further, the challenge would be then to transfer data from Azure DB to on premise SQl server.

So does it mean this feature is not supported as of now?

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Yep, there is no feature that would support the requirement that you described.

The next question is - what is the actual business requirement? So far you described a technical wish where you could have a two-way sync between D365FO and your own database. But I'm sure there's some business requirement behind that, and perhaps it could be resolved with another technical solution.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi AX Ankit,

You can create an integration with help of e.g. Azure service bus and web services. To be able to do the on-premise part, you can read some documentation or get some help on the Azure community forum.

Was this reply helpful? Yes No