You’re offline. This is a read only version of the page.
515
Hi All,
Kindly let me know how we can import /export data from D365 FO to Azure blob storage(internal/External..What is the difference between this,how to identify it is internal /external storage)
Somewhere I read we should use logic APP but how it exactly exports the data to blob storage is not mentioned.I am expecting some screen shot where it will show data transfer from D365 to and from Azure Blob storage.
Pls help.
Thanks,
Shri
In addition to what everyone suggested , data package API can help you as well . You can export /import data using this API . Your third party can get url of blob storage where package is uploaded and process it according to their need.
Separator setting is on source data format . So when you create data project , you can define pipe as a separator for your data. Look at the below links to get more information about this API
If your goal is getting the data to a SQL database, using BYOD to export data directly to an Azure SQL database sounds like the best option (it depends on detailed requirements, of course).
It seems that text files, blob storage, AZcopy etc. and so on is about a particular implementation design, but it may be all completely unnecessary if we choose a different approach. Distinguishing between business requirements and implementation details is crucial.
When you export entity data in excel, it exports file in Azure blob. And using LogicApp you can connect the azure blog to get the files and use them. You can check a piece of code to get the Azure Blob URL of your export here - ajit-newdynamicsax.blogspot.com/.../how-to-get-azure-blob-url-in-d365fo.html
I believe you can also use Azure Data Factory to get the data from BYOD and create a file for you.
If you are looking for documentation then refer - docs.microsoft.com/.../integration-overview for various integration strategies available with D365FO
Hi Shri, You can use business events in D365 to export data to blob storage in JSON and some other formats. Third party can connect to Azure BLOB to read this data.
You can also use entity store, BYOD and export data to SQL and third party can read data from there as well.
Hi Ajit,
Requirement is data import / export from D365 to third system in pipe separated text file format.
Here we want to know how we can transfer data to Azure blob from D365.Can we achieve it through Data management framework?
As from Azure blob storage using SQL jobs data packages we can transfer it to SQL server from where third party can pick up the files.
Thanks,
Shri
Hi Martin,
Actually there is one integration implemented by third party.We understood that there is data transfer from D365 - Azure Blob storage-SQL server. From SQL server other system picks the data.To fetch data they have used Azure utility(used AZcopy whcih generally picks the data from azure blob storage as per my understanding.)But till we are not clear how it is getting transfer to azure blob.We are still exploring it as we don't get any documents for same.So if somebody can shed some light on different ways to achieve this then we can search in that direction.
Thanks,
Shri
What are you trying to achieve from business perspective? Why do you ask specifically about blobs and not other kind of storage?
It's true that F&O internally uses a blob storage (for temporary files during export/import and optionally for attachments), but it's just an implementation detail.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (