Devart SSIS Data Flow Components for Oracle allow you to integrate Oracle data with cloud applications and databases via SQL Server Integration Services (SSIS).Devart SSIS Data Flow Components for Oracle include Source, Destination, and Lookup components along with Devart Oracle Connection Manager.
Devart Oracle Source
Devart Oracle 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 Oracle Lookup
Devart Oracle 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 Oracle Destination
Devart Oracle Destination support not only the standard Insert operations, but also Update, and Delete. It uses Oracle-specific optimizations to speed up data loading.
