Using the PostgreSQL Connection Manager

The PostgreSQL Connection Manager is an SSIS connection manager component that can be used to establish connections with PostgreSQL instances.

To add a PostgreSQL connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted with the "Add SSIS Connection Manager" window. Select the "PostgreSQL" item to add the new PostgreSQL Connection Manager.

New Connection

Add PostgreSQL Connection

The PostgreSQL Connection Manager contains the following two pages which configure how you want to connect to PostgreSQL.

  • General
  • Advanced

General

The General page of PostgreSQL Connection Manager allows you to specify the server host details and credentials for authentication. 

PostgreSQL Connection Manager

Server
Host

The host's domain name or the address for the instance.

Port

The port number of the instance.

Timeout

The Timeout (secs) option allows you to specify a timeout value in seconds for the connection. The maximum value for timeout is 600 seconds.

Authentication
Username

The username of the account which will be used to connect to the database instance.

Password

The password of the provided user account.

Database
Database

The databases that are accessible by the credentials provided above would be available in this field.

Advanced

The Advanced page contains the possible settings for PostgreSQL connection. Clicking on a specific setting will display a description for the selected property at the bottom of the Advanced page.

PostgreSQL Connection Manager

It has the below sections which you can work with:

  • Advanced
  • General
  • Miscellaneous
  • Performance
  • Pooling
  • Security and Encryption
  • Timeouts and Keepalive

You can refer to the following link for more details regarding each connection property: Connection String Parameters