Illustrated in the below image is a flow where the PostgresSQL Destination step is used. A record generator is used as the Source step.
Adding a PostgresSQL Destination Step
To add a PostgresSQL Destination step in a flow, follow the below instructions:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Click on the Destination tab and select or search for PostgresSQL as shown in the image below.
The image below illustrates the SQL database before data is inserted into Postgres database.
The Record Generator is used as the source step to add data to the SQL database. The Record Generator is shown in the page below.
Configuring a PostgresSQL Destination Step
Illustrated in the below image is the configuration that is available in the PostgresSQL Destination step. The syntax to reference a record or parameter is {@fieldName}.
A connection is required for this step. Select an existing connection by clicking on the dropdown arrow as outlined in red in the image above or by creating a new connection by clicking on the plus icon highlighted in yellow.
Type – Select the type of command to execute. This field is compulsory for the step to work. In this example, the Command type has been used. The command is shown in the above referencing the records in the Record Generator.
Input Parameters – Define the Input Parameters to pass to the command. This field is not compulsory.
Using a PostgresSQL Destination Step
To use a PostgresSQL Destination step, follow the instructions below:
1. Click the Execute Flow button shown in the image below:
2. Click the Create Run button.
The image below shows the SQL database where the new record has been added.
