To use a PostgreSQL database with the SQL Query tool you will first need to download the correct driver. You can do this at the following link: https://github.com/npgsql/npgsql/releases/tag/v4.0.12
Make sure that you include the
Npgsql GAC Installation in the driver install, otherwise it will not be shown in the connection list as an available provider.
Once the driver has downloaded, close (if you haven't already) and reopen Data Sync.
Now go to
SQL Query Tool >
Connection and choose the
Npgsql Data Provider from the drop down list.
At a minimum you will need to enter the following into the connection properties window:
The host name or IP address of the PostgreSQL Server to connect to.
The PostgreSQL database you are connecting to.
The TCP port of the PostgreSQL server.
THe username to connect to the PostgreSQL server. This is not required if you are using integrated security.
The password to connect to the PostgreSQL server. This is not required if you are using integrated security.