SSIS PostgreSQL Source

SSIS PostgreSQL Source

PostgreSQL Source can be used to extract large amount of data from a PostgreSQL Database. This component supports SQL  language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance.

Features

  • Multiple modes (i.e. Table or Query) to read data from PostgreSql Database
  • Support for data preview and max rows
  • Support for variable placeholders in sql query
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see articles related to PostgreSql

Download Help File Buy
View All Tasks
ScreenshotsSystem Requirements

PostgreSQL Connection Manager

Enter connection attributes to connect to PostgreSQL instance and Click Test connection to verify credentials

Enter connection attributes to connect to PostgreSQL instance and Click Test connection to verify credentials

PostgreSQL Source Connector – Query data using SQL

PostgreSQL Source Connector - Query data using SQL

PostgreSQL Source Connector – Query data using SQL

Articles / Tutorials

Click here to see all articles for [SSIS PostgreSQL Source] category


Export PostgreSQL Table Data to SQL Server in SSIS

Export PostgreSQL Table Data to SQL Server in SSIS

ZappySys provides high performance drag and drop connectors for PostgreSQL Integration. In this post you will see how to Export PostgreSQL Table Data to SQL Server Table using SSIS PostgreSQL Source. PostgreSQL Source supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance. […]


Load PostgreSQL Table Data to CSV File in SSIS

Load PostgreSQL Table Data to CSV File in SSIS

Introduction ZappySys provides high performance drag and drop connectors for PostgreSQL Integration. In this post you will see how to Load PostgreSQL Table Data to CSV File using SSIS PostgreSQL Source. PostgreSQL Source supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance. In […]

Click here to learn more about System Requirements
Download View All Tasks Like This