AVT100 SSIS Data Flow Components for Dynamics 365 ID 5023647
Devart SSIS Data Flow Components for Dynamics 365 allow you to integrate Dynamics 365 Online data with cloud applications and databases via SQL Server Integration Services (SSIS).Devart SSIS Data Flow Components for Dynamics 365 include Source, Destination, and Lookup components along with Devart Dynamics Connection Manager.Devart Dynamics SourceDevart Dynamics Source provides convenient editor which allow you to quickly create a query to the data source. It displays data source metadata and variables list, and allow previewing the queried data. Devart Dynamics Source allows using SQL select statements to query data from Dynamics 365 even though Dynamics 365 does not support SQL natively. No need to study Dynamics 365 API to integrate your data.Devart Dynamics LookupDevart Dynamics Lookup component offer advanced two-level performance optimizations. They check incoming rows for matches in batches and cache the data returned from a lookup object in order to provide the highest possible performance.Devart Dynamics DestinationDevart Dynamics Destination support not only the standard Insert operations, but also Update, and Delete.
