We are using Dynamic AX and we want to export all the existing attachments which stored in AX/Microsoft blob storage. First, let me explain the current situation:
AX has a backend SQL database that contains all the attachments metadata
there is a front entity data structure that you can use OData connection to it but it gives you the entities data (not the files)
there is a Export job in app that you can use to extract the entities data and some attachments but based on my experience, its not a efficient tool, its slow, has lots of error and wont give you all the attachments
(just FYI, there is around 4400 entities and 62000 attachments and I need to extract them, please dont ask why you need to extract and etc)
so my main question: How we can extract them all in a efficient way (means reliable, without error and make sure we will get everything)??
The possible solutions can be:
1- use the customized app export job
2- use Data Factory to generate the download URL (File GUID+Token)
3- use VS to generate the package and connect to AOT and download the files
Any experience, thoughts?