Forum Discussion

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago
Solved

Import data from PostgreSQL

Hello, I have my Data on a remote PostreSQL and I'm trying to get them but with no success. I've tried two ways: 1. GET DATA -> PostgreSQL Database  Server: 34.xx.xxx.xxx Database: myDb Then I ...
Need Help
  • fabiomanniti's avatar
    fabiomanniti
    4 years ago

     I solved this using ODBC

    I had to create a ODBC Connector but I also had to enable SSL.

    The best way is throug ODBC Administrator (search on windows) so you can make a test to the connection. Otherwise the script is

     

    database=xxxx;driver={PostgreSQL Unicode(x64)};port=5432;server=34.xxxxxx;sslmode=require;

     

    This worked for me

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi fabiomanniti 

I'm not sure about connecting to this database from Tableau or Datagrip ,because I don't have the test environment to restore your scenario. Most customers will choose the ODBC connector if they fail to connect to the PostgreSQL database using the PostgreSQL DB connector . Maybe you can talk to the person who manages the database to see if it's a configuration file problem.

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago

 I solved this using ODBC

I had to create a ODBC Connector but I also had to enable SSL.

The best way is throug ODBC Administrator (search on windows) so you can make a test to the connection. Otherwise the script is

 

database=xxxx;driver={PostgreSQL Unicode(x64)};port=5432;server=34.xxxxxx;sslmode=require;

 

This worked for me