4 Replies Latest reply on Sep 26, 2021 9:16 AM by Jharana Patra

    Mapping from D365 F&O to Azure sql instance

    Mario Masetto New Member

      Hi,

       

      I am trying to perform a simple import of a Dynamics 365 table into a sql server instance on azure.

      I am using the Microsoft Dynamics 365 for Operations connector but the execution of the import is extremely slow (it takes hours to load ~ 100k records).

      I tried to increase the page size up to 1.000.000 rows, but the performances are not affected.

       

      Is anyone aware of an effective and efficient way of reading from Microsoft Dynamics 365 for Operations with IICS?

       

      Thanks

       

      Mario