Data Point connection to PostgreSQL database instance

Toad Data Point & Toad Intelligence Central
1

I’m in need of detailed instructions to make a clean connection with Toad Data Point to POSTGRESQL database instance.

2

Here’s a list to steps to connect to PostgreSQL in TDP

  1. Install PostgreSQL ODBC driver

  2. Select postgreSQL in TDP connection manager

  3. Click Data source button to invoke ODBC DSN and add new PostgreSQL connection

  4. Add the login information again in TDP to connect.

In general, it follows the same steps to add an ODBC connection, you can find it in help file under topic “Create ODBC Connections”. Here’s also an old video showing you how to add generic ODBC connection.

http://www.toadworld.com/products/toad-data-point/m/media-library/1108

Please let us know if you run into any issues.

Thanks!

3

I struggled trying to Data Point to connect to a PostgreSQL database too. Here is how I was able to connect:.

Follow the first three steps Kiki mentioned above:

  1. Install PostgreSQL ODBC driver

  2. Select postgreSQL in TDP connection manager

  3. Click Data source button to invoke ODBC DSN and add new PostgreSQL connection

In the Create New Connection screen, rather than add entries in the top portion of the scree for User: Password: and Database:, enter the following in the ConnectionString: field below:

Driver={postgreSQL UNICODE};Server=localhost;Port=5432;Database=;Uid=;Pwd=;

This assumes that you are trying to connect to a PostgreSQL database that is installed on the same machine that you are running Data Point.

Good Luck!

4

Hi Bob,

I’m also having this kind of problem when connecting PostgreSQL database.

When I edit the Connection String and try to connect, this error appear: “Unknown Authentication type”.

Fyi, previously I’m able to connect without editing the ConnectionString, but the problem is I cannot view the data inside the tables correctly. It will show this kind of error:

Error while executing the query;
ERROR: schema “” does not exist

Please help for anyone who know about this.

5

You are better off defining a System or User DSN. This way the driver handles the connect string. Can you try this?

6

I already solved the problem.

First, I install the latest ODBC driver for PostgreSQL 9.6 at this link https://www.postgresql.org/ftp/odbc/versions/msi/

Then, I add System DSN at Control Panel\Administrative Tools\Data Sources (ODBC)

But, it’s quite tedious. Because one System DSN can only connect to one database, unlike Oracle or SQL Server where we can browse through all available Schema after one System DSN connected

Regards,

Azlan