# PostgreSQL properties

Properties to configure to connect to a PostgreSQL database table.

## PostgreSQL connection

Select PostgreSQL in the list and configure the connection.

## Configuration

Select your engine from the list and set the main and advanced settings.

Main settingsMain settings

| Property | Configuration |
| --- | --- |
| If Define JDBC URL is disabled | If this option is disabled, enter each parameter that identifies the<br>database to be used in the corresponding fields.<br><br>Click Load<br>default values in order to help you pre-fill the fields<br>with the default values associated with this type of database.<br><br>Information noteNote: Use the host name of the target system<br>instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate<br>with the target system. |
| If Define JDBC URL is enabled | If this option is enabled, enter the JDBC URL that identifies the<br>database to be used.<br><br>The expected format is the following:<br>jdbc:postgresql://&lt;host&gt;[:&lt;port&gt;]/&lt;database\_name&gt;<br><br>Information noteNote: Use the host name of the target system<br>instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate<br>with the target system. |
| User<br>name | Enter the username used to connect to the database. |
| Password | Enter the password used to connect to the database. |

Advanced settingsAdvanced settings

| Property | Configuration |
| --- | --- |
| Force protocol | If Define JDBC URL is disabled, you can enable<br>this option to define the JDBC driver protocol. |
| Connection timeout | Sets the<br>maximum number of seconds that a user will wait for a connection to be<br>available. If this time is exceeded and the connection is still unavailable, an<br>exception is thrown. |
| Connection validation timeout | Sets the<br>maximum waiting time in seconds for a connection to be considered as<br>alive. |

After configuring the connection, give it a display name (mandatory) and a description (optional).

## PostgreSQL dataset

Dataset configurationDataset configuration

| Property | Configuration |
| --- | --- |
| Dataset name | Enter a<br>display name for the dataset. This name will be used as a unique identifier of<br>the dataset in all Talend Cloud apps. |
| Connection | Select<br>your connection in the list. If you are creating a dataset based on an existing<br>connection, this field is read-only. |
| Type | Select the type of dataset you want to create:<br><br><ul> <li> <span>Query</span>: to query the data in your existing                              tables.</li> <li> <span>Table name</span>: to access the table located in your                              Amazon Aurora database using its unique name.</li> <li> <span>Table streams</span>: to access the specific table                              where changes are tracked using its unique name.</li> </ul> |

Main settingsMain settings

| Property | Configuration |
| --- | --- |
| Query | Enter the SQL query to access the data of your choice located in your<br>Amazon Aurora table. |
| Table name | Select or enter the unique name of your Amazon Aurora table. |
| Table streams | Select or enter the unique name of your Amazon Aurora table, as well as<br>the name of the table stream to indicate the type of changes tracked in the<br>table.<br><br>For more information on table streams and CDC, read [the Snowflake documentation](https://docs.snowflake.com/en/user-guide/streams.html). |

Advanced settingsAdvanced settings

| Property | Configuration |
| --- | --- |
| Fetch size | Specifies the amount of data sent during one single communication step<br>with the database. In the **Fetch size** field displayed, you need to<br>enter the size in KB. |

Additional JDBC parameters might be displayed depending on whether the connector is used as a source or destination dataset, read [the JDBC parameters section](https://help.qlik.com/talend/r/en-US/Cloud/connectors-guide/jdbc) to know more about these parameters.