PostgreSQL Connector

Setting Up PostgreSQL Data Connection

Setting up a PostgreSQL data connection in DPL Studio requires identifying the PostgreSQL server and providing the necessary authentication details.

Steps to Set Up a PostgreSQL Export Connector

1.In the Set Destination Connection dialog of the Data Export Wizard, select PostgreSQL Data Connector.

2.In the Server dropdown list:

a.Select the PostgreSQL server hosting the database.

b.Click Refresh to rescan and display available servers if the required server is not listed.

c.If the server still does not appear, manually enter the fully qualified network path of the server.

Under Logon Credentials, choose one of the following authentication methods:

Use Windows Authentication

Select this option to use Microsoft Windows authentication.

a.DPL Studio uses the current Windows user credentials for authentication.

b.The server administrator must configure the server to allow Windows authentication.

Use the Following Username and Password

Select this option to manually enter authentication details.

a.Enter the required Username and Password.

b.Blank passwords are allowed if the data source does not require a password.

4.Use the Database dropdown list to select the database you want to access.

5.Optionally, enable Edit Connection String to manually enter a connection string.

6.Configure the Query Timeout value to define how long DPL Studio should wait before returning a timeout error.

7.Click Test Connection to verify the connection to the PostgreSQL data source. (If the connection fails, verify that the connection details are correct. Incorrect credentials, spelling errors, or case sensitivity may cause connection failures.)

8.Click Next to proceed to the next step in the wizard and configure the table mappings between the source and destination files.