SSIS PostgreSql Integration Pack

SSIS PostgreSql Integration Pack

SSIS PostgreSql Integration Pack is your complete toolset to automate PostgreSql integration scenarios in SSIS. Using simple drag and drop interface you can read data from PostgreSql or Bulk insert data into PostgreSql. You can also execute any valid PostgreSql DDL / DML commands inside SSIS (e.g. Create Table/ Drop Table/Get Count). It includes PostgreSql Source Connector, PostgreSql Destination Connector and PostgreSql ExecuteSQL Task.

Features

  • Bulk extract/output PostgreSql data
  • Support for SQL queries to extract data in bulk without installing any driver
  • Bulk insert data into PostgreSql Table
  • Intuitive user interface with examples makes PostgreSql learning super easy and fast
  • Support for executing DDL statements such as Create/Drop table
  • Execute DML statements such as Select/Insert/Update/Delete and save result to variable
  • Support for saving SingleValue from response such as count from query
  • Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: PostgreSql related articles
Download Buy View All Tasks

SSIS PostgreSql Source (Query/Read/Extract)

PostgreSql Source SSIS PostgreSql Source can be used to extract large amount of data from PostgreSql. This component supports SQL like query language to query PostgreSql data without installing any drivers.

Read more

SSIS PostgreSql Destination (Bulk Insert)

PostgreSql Destination SSIS PostgreSql Destination can be used to bulk insert large amount of records to PostgreSql storage from any data source using SSIS.

Read more

SSIS PostgreSql ExecuteSQL Task

PostgreSql ExecuteSQL Task SSIS PostgreSql ExecuteSQL Task can be used to execute ad-hoc commands for PostgreSql (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete commands.)

Read more

 

Download View All Tasks