Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

Loading data from a Postgres DB

Hi all,

I have an Qlik Sense app where I load data from a Vertica DB. Now, I need a couple of tables from another database, a Postgres DB. So I've done the following:

- I've created an ODBC source in my Qlik Sense server, with the Qlik-postgres driver. I've tested it, and it says it connects.

- I've added the connection to that source to my script.

- I've clicked on "Select data to load".

At that point Qlik Sense shows the loading circle indefinitely, without letting me choose Database and Tables.

Any idea on what may be happening?

Thanks,

Juan

1 Solution

Accepted Solutions
morenoju
Partner - Specialist
Partner - Specialist
Author

All this was being very confusing because in the "ODBC Data Sources Administrator" in Windows I could test the connection and it would work.

The reason why it didn't work in Qlik Sense is that I was inserting the user/password once again when creating the ODBC data connection in Qlik. It has to be left blank. The user/password is already there in the ODBC Data Source configuration.

Note: I checked the version of my PostgreSQL database doing "SELECT version();" in pgAdmin and I made sure I installed the same version of the driver. I had to choose between PostgreSQL30 (ANSI) and PostgreSQL35W (Unicode). I read Unicode is more common, so that's the one I'm using.

View solution in original post

9 Replies
kaushiknsolanki

Hi,

Not sure what would have caused that, but if you know the table name you can simply write that in script like below.

Sql Select * from xyz;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
morenoju
Partner - Specialist
Partner - Specialist
Author

I already tried that, but it hangs right after the connection.

morenoju
Partner - Specialist
Partner - Specialist
Author

I still can't find the reason for this not to work.

Do you think that maybe the version of PostgreSQL can be a problem?

My DB version is: PostgreSQL 9.1.10 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-54), 64-bit

balabhaskarqlik

Did you able to resolve this issue, post the solution.

morenoju
Partner - Specialist
Partner - Specialist
Author

Unfortunately not, Bala. I gave up, although including data from PostrgeSQL would have been very good for the dashboards I was working on at that time.

Anil_Babu_Samineni

Can you check if that helps How to pull data from PostgreSQL to Qlik

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
morenoju
Partner - Specialist
Partner - Specialist
Author

Hi Anil,

Thanks for the link. I see it refers to Qlikview though, does it apply to Qlik Sense too?

I've been trying to connect to Postgres again today and it does not show any error, but the drop down lists for Database and Owner are disabled.

Thanks,

Juan

Screenshot_1.png

Anil_Babu_Samineni

You are pulling data directly, Have you given correct Connection?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
morenoju
Partner - Specialist
Partner - Specialist
Author

All this was being very confusing because in the "ODBC Data Sources Administrator" in Windows I could test the connection and it would work.

The reason why it didn't work in Qlik Sense is that I was inserting the user/password once again when creating the ODBC data connection in Qlik. It has to be left blank. The user/password is already there in the ODBC Data Source configuration.

Note: I checked the version of my PostgreSQL database doing "SELECT version();" in pgAdmin and I made sure I installed the same version of the driver. I had to choose between PostgreSQL30 (ANSI) and PostgreSQL35W (Unicode). I read Unicode is more common, so that's the one I'm using.