PostgreSQL Connection

PostgreSQL Connection Manager is an SSIS Connection Manager for establishing connections to on-premises and hosted PostgreSQL databases.

It supports standard PostgreSQL authentication and cloud-native identity authentication providers.

It can be used with Database Source, Database Destination, CDC Source Plus, CDC Task Plus, Lookup Plus and Query.

Supported cloud platforms and services:

✔️ Microsoft Azure Database for PostgreSQL

✔️ Google Cloud SQL for PostgreSQL

✔️ Amazon RDS for PostgreSQL

✔️ Amazon Aurora PostgreSQL - Compatible Edition

✔️ Supabase PostgreSQL

✔️ Azure HorizonDB

Unlike the standard ADO.NET connectivity to PostgreSQL in SSIS, which requires an installation of Npqsql.msi, PostgreSQL Connection Manager doesn't have any extra prerequisites.

COZYROC SSIS+ Components Suite is free for download and development within Visual Studio

✔️ Free developer license

✔️ Support for SQL Server 2012 - 2025

✔️ COZYROC SSIS+ suite includes more than 280 SSIS components for ETL and Data Integration

✔️ Developing and testing with the COZYROC SSIS+ components suite is Completely free. You don't need a license key until you want to schedule and execute your packages under the SQL Job Agent.

✔️ A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud

The COZYROC SSIS+ components suite also includes:

The powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market. Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's REST adapters.

Check the SSIS Data Flow Task demo video in our Youtube channel.

See also:

• COZYROC SSIS REST framework video. With the COZYROC SSIS REST framework you can connect to any Web service and consume any Web API. Free for download and development https://www.cozyroc.com/ssis/rest

• COZYROC SORT Plus SSIS component video. With COZYROC’s Sort Plus SSIS component, you can sort ANY amount of data and any number of records. Free for download and development https://www.cozyroc.com/ssis/sort

• For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website

Try COZYROC Cloud for FREE

​COZYROC Cloud delivers seamless hybrid integrations, effortlessly connecting cloud and on-premises applications and databases, supporting cloud repatriation. A straightforward, cost-effective way to transition and run your SSIS packages in the cloud.

✔️ Support of Managed or On-premises execution environments

✔️ Webhook Triggers from external systems can trigger package executions for event driven workflows

✔️ Full integration of the COZYROC SSIS+ components suite is included

Get in touch with us:

• For support or any questions connect with us