PostgreSQL connection configuration
Overview
When you connect to PostgreSQL directly, select Local DB as the location, select PostgreSQL as the data type, and configure the detailed settings.
Configuration
Basic
| No | Item | Description |
|---|---|---|
| 1 | User ID | Use ID for the PostgreSQL account. |
| 2 | Password | Password for the PostgreSQL account. |
| 3 | Connection Type | Select Basic |
| 4 | PostgreSQL Host | |
| 5 | PostgreSQL Port | |
| 6 | Database | |
| 7 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |
| 8 | Enable Transactions | Specify whether to enable transaction control. When ON, transactions are enabled for each connection, and operations are executed within the same transaction. When OFF, each operation is committed automatically (autocommit). |
PostgreSQL Connection String
SDI uses Npgsql to connect to PostgreSQL.
You can connect to PostgreSQL by using PostgreSQL Connection String directly.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select PostgreSQL Connection String |
| 2 | PostgreSQL Connection String | Enter the details of the PostgreSQL Connection String. * Do not enter user and password information in the Connection String. Reference:Npgsql Connection string parameters |