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