Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to export entities...
Finance | Project Operations, Human Resources, ...
Suggested answer

How to export entities from Dynamics 365 Fo to on-premise SQL server

(1) ShareShare
ReportReport
Posted on by Ali AbdAlNasser 229
Hello everyone.
I am trying to export entities from Dynamics 365 Fo to a local SQL server. I have a computer that I rented in Azure, and this computer has a SQL server. What I am trying to do is export the entities as tables into my own database on the local server. I tried searching the internet but did not find a clear answer.
 
Thank you.
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,399 Super User 2024 Season 2 on at
    How to export entities from Dynamics 365 Fo to on-premise SQL server
    Hi,
     
    A few suggestions:
    1. You will face some hassles while pushing data onto a box that hosts SQL Server DB. The suggestion is to setup an On-Premise Dynamics 365 FO VM (hosted on an Azure subscription) or download a Virtual machine from Shared Asset Library in Dynamics Lifecycle Services , setup a local server DB and push the data through the Bring Your Own Database approach (BYOD). 
    2. You can either use Azure Synapse for D365 FO and have your virtual data entities pushed into a MS Fabric layer through the Dataverse platform.
     
    If all the above options are not feasible then all you can do is have the data entities pushed into a Blob storage in Azure as .csv files and have the data pulled into an On-Premise SQL Server database through an On-Premise gateway or through a SSIS package, which will be more of an effort.
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,703 Super User 2024 Season 2 on at
    How to export entities from Dynamics 365 Fo to on-premise SQL server
    Yes, you can create a flow that reads data from Dynamics 365 F&O or via virtual entities and write it to on-premises gateways. There are blogs available talking about these connectors using Logic Apps.
  • Ali AbdAlNasser Profile Picture
    Ali AbdAlNasser 229 on at
    How to export entities from Dynamics 365 Fo to on-premise SQL server
    Will the data extraction method through Azure Logic Apps, which relies on the Azure gateway, allow me to Export entities from D365 to a local SQL Server?
     
  • andreasraithel Profile Picture
    andreasraithel 4,822 Super User 2024 Season 2 on at
    How to export entities from Dynamics 365 Fo to on-premise SQL server
    Hy,
    as Andre said you need any kind of secured Data Gateway on the local resource to get access to the local SQL Server.
    Instead of local SQL Server you could also use a Azure SQL Server. D365F&O can directly write to Azure SQL Server using the BYOD feature within the Data management. So you can expose all entities.
     
    Hope this helps.
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,703 Super User 2024 Season 2 on at
    How to export entities from Dynamics 365 Fo to on-premise SQL server
    Hi,
     
    To be able to access a database server on a local VM, you would need to use some middleware. This could be using e.g. Logic Apps with an on-premises data source. Connect to on-premises data sources - Azure Logic Apps | Microsoft Learn
    You can also check for an ISV solution, like Connectivity Studio from To-Increase. This solution also has the option to connect to local SQL servers.
    You can also try to write your own middleware by using some Azure technology being able to connect with on-premises applications, like Azure Service Bus.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans