MySQL remote database to QlikView

Mon, 20 May 2013 15:18:40 GMT

Hello,

I'm very new to QV and this is my first post at this forum. I hope I'm in the right place!

I'm trying to get some data from a MySQL server into QV. The connection is successful, but when I open the Select window (Edic script -> Select) I don't see my tables (image below [image1.PNG]). All the databases are there however.

When I double-click an empty row in the "Database Tables" field the pop-up shows all the collums through out the six different tables in a single table (image below [image2.PNG]).

About the DB structure. Five of the tables (each with id and one other collumn eg. country) has all a relation to the sixth table. They contain different types of data that are linked together in the sixth table, like an OLAP-model. I use the InnoDB engine for all the tables.

Why is not the tables showing up in the Select-window? Is the database structure somehow causing this problem? Or am I missing something..? I searched for tutorials about this, but I didn't find any.

Thanks,

/Peter

P.S.

I tried other databases aswell, same result...

D.S.

Re: MySQL remote database to QlikView

Miguel_Angel_Baeyens — Mon, 20 May 2013 15:22:06 GMT

Hi,

When I've come across this issue has been solved using the latest 32 or 64 bit driver (whatever matches the RDBM).

Hope that helps.

Miguel

Re: MySQL remote database to QlikView

Mon, 20 May 2013 18:30:22 GMT

I had version 5.1 installed, 5.2 made it work!

Thank you very much!

topic Re: MySQL remote database to QlikView in QlikView

MySQL remote database to QlikView

Re: MySQL remote database to QlikView

Re: MySQL remote database to QlikView