PostgreSQL Connector

Back Next

Introduction to PostgreSQL Connector

You can use PostgreSQL Connector to securely read data from

or write data to

the PostgreSQL databases.

You can also use PostgreSQL Connector to connect to the following databases:

Amazon Aurora PostgreSQL

Azure PostgreSQL private endpoint on a virtual network

PostgreSQL sources

and targets

represent tables in PostgreSQL. You can create a PostgreSQL connection and use the connection in mappings and

mapping

tasks to read from

or write data to

PostgreSQL. Create a

mapping

task to process data based on the data flow logic defined in a mapping or integration template.

When you run an PostgreSQL mapping or

mapping

task, the Secure Agent writes data to PostgreSQL based on the defined data logic and the configured PostgreSQL connection.

You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.

Example: You work for an organization that stores purchase order details, such as customer ID, item codes, and item quantity in a MySQL database. You need to analyze purchase order details and move data from the MySQL database to a cloud-based environment. Create a mapping to read all the purchase records from the MySQL database and write them to an PostgreSQL target for data analysis.