Azure Data Factory includes a feature called "Copy Activity" which enables users to copy data from one database to another at scale. Copy Activity doesn’t just work for Microsoft products like Azure SQL server or Azure Storage; use to it to copy data from an on-premises Oracle database or flat files into Dynamics 365.
We also appreciate the Copy Activity status page, which shows the number of source rows that ADF retrieved so far, the number of rows upserted in Dynamics 365 / Dataverse and the total time the process has taken. This status page makes it easy to keep track of the migration process.
Another way that ADF keeps the user informed about the migration status is through its ability to write errors or warnings to Azure Storage. This allows the user to review row-level problems with the migration and take corrective action.
Long-Running Migration Capabilities
For major data migration projects, such as those involving millions of rows of data, it’s often important for the migration to run 24/7 and uninterrupted. This can be necessary, for example, when a business is transitioning from an old system on a Friday and wants employees to start using Dynamics 365 the following Monday. ADF can not only automatically retry failed upsert operations to help keep it running consistently, but also utilize advanced capabilities, such as looping controls, advanced error handling and alerts to help a data migration team to meet an important deadline.