Share
ReportWe have to migrate huge volume of data from Azure SQL database to Dynamics 365 Finance and Operations Entities. We are considering the below options.
1. Using a combination of Logic Apps and D365 Data Mananagement- Data import jobs to migrate the entities. However here the process is asynchronous and we wouldn't have much control on the same for error handling and restartability. Also for every migration , we will need to put the data for a single entity in a zip (package) with a fixed naming convention and manifest and package header files.
medium.com/.../logic-app-integration-with-d365-f-o-524ac4909f0
2. In second approach, SSIS packages will be used to load data using custom D365 connector (Kingwaysoft connector). .https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/help-manual/ax/destination. This connector converts the data format to OData which is recognizable by D365. This approach has a limitation of loading 100K records at a time.
Which of these 2 approaches is recommended.
All responses (
Answers (
1,027
