Connecting to PostgreSQL Database

PostgreSQL is an open source relational database management system that stores data workloads. It helps in managing all kinds of datasets with its extensive range of features. Astera Centerprise offers native connectivity for PostgreSQL databases at both source and destination points. The connectivity also extends to other objects such as Database Lookup, SQL Query Lookup, SQL script task in a workflow, and database write strategies.

In this article, we will see how PostgreSQL can be connected as a database source in Centerprise. To establish the connection, we’ll be using the Database Table Source object.

1. Drag and drop the Database Table Source object from the toolbox onto the dataflow designer. Right-click on its header and select Properties from the context menu.

01

A Database Connection window will open.

02

This is where you configure the properties to establish connection with the database.

2. On the Database Connection screen, you will find a drop-down list next to the Data Provider option.

Select PostgreSQL as your data provider from this list.

03

  • Put in the required credentials for PostgreSQL data provider account.

04

  • Test Connection to make sure that the database connection is successful and click OK.

05

The connection to PostgreSQL as your database provider has been successfully established. You can now pick a source table from PostgreSQL database and use that data in your dataflow.

To learn more about how to pick a table from a database source and specify other reading options, click here.

This concludes connecting to PostgreSQL databases in Astera Centerprise.