Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vb00494773
Not applicable

qlik sens to postgres connection issue

Hi team,

could you please help me on the below issue.

I have a problem for connecting(using HBU) to postgres sql . i am getting error like , "you don't have access to data source"

FYI, i have created a ODBC connection with correct credentials and using the same while connecting .

Please let me know solution ASAP. 

Capture.PNG

Thanks,

Venkatesh

1 Solution

Accepted Solutions
vb00494773
Not applicable

Re: qlik sens to postgres connection issue

Thanks for the reply,

i even explored an another way by add data option and select connect to my data option ,

There we can select postgresql option

then we can fill the required info.

it will work.

Thanks 

5 Replies
vlad_komarov
Not applicable

Re: qlik sens to postgres connection issue

Venkatesh,

Couple things to verify:

1. Check if you can actually access your data using ODBC connector you have created (using other ODBC-enabled applications, for example).

2. Check if you have the latest and greatest Postgres ODBC driver with proper 64-bit support installed on your Qlik Server.


I've had the same case some time ago and resolving #2 was a key.


Regards,

Vlad

loveisfail
Not applicable

Re: qlik sens to postgres connection issue

In fact, This is my first time connection to DB I am not getting any issue while connect to Postgres

Sample Script

LIB CONNECT TO 'PostgreSQL30';

LOAD "last_name",

    "contact_id",

    "first_name",

    "country",

    "Images";

SQL SELECT "last_name",

    "contact_id",

    "first_name",

    "country",

    "Images"

FROM "mydb"."public"."DDQ";

Process Done

1) Create New Connection

2) ODBC

3) Follow the image, Please

Capture.PNG

4) Then Use Username - postgres and Password - XXXXXX is up on you

Then simple Click Okay and then Try to pull data from DB.

You can follow below Link to download as per your need

PostgreSQL: File Browser

Life is so rich, and we need to respect to the life !!!
vb00494773
Not applicable

Re: qlik sens to postgres connection issue

Thanks for the reply,

i even explored an another way by add data option and select connect to my data option ,

There we can select postgresql option

then we can fill the required info.

it will work.

Thanks 

loveisfail
Not applicable

Re: qlik sens to postgres connection issue

Good, Some what you will get some information on my post

Life is so rich, and we need to respect to the life !!!
Daniel_Charless
Not applicable

Re: qlik sens to postgres connection issue

Is it possible to mention two database names from same server in a single odbc connection ?