PostgreSQL

PostgreSQL is a powerful, open source object-relational database system. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. But disseminating the vast amount of information to perform ETL or ELT therein is time consuming and tedious. We can use the Data Integration Platform to read or write the relevant data into PostgreSQL and perform ETL operations easily with the available components.

Set up connection

Create a PostgreSQL controller service globally or specific to a data flow to simplify connectivity with the data base and to perform ETL operations. PostgreSQL and DBCPConnectionPool controller services are available out-of-the-box to connect to PostgreSQL.

Scheduling

The connected workflow will execute automatically in the background using a scheduling strategy (timer driven, CRON driven, event driven, or run once), or on-demand via an API or the Start and Stop buttons in the Operate panel.

Bi-directional connection

You can read or write the changes made in the Data Integration Platform to the PostgreSQL database automatically with full CRUD queries.

Security

The Data Integration Platform stores the credentials in encrypted format in one place so they stay confidential and secure.