Skip to content

PostgreSQL connection configuration


When you connect to PostgreSQL directly, select Local DB as the location, select PostgreSQL as the data type, and configure the detailed settings.



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.

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
Back to top