topic Re: connection with mysql database in QlikView

connection with mysql database

Thu, 24 Apr 2014 17:16:43 GMT

Hi,

I have a mysql database and i would import this database in qlikview i need to know how to make this, can someone help me with a link or someting like this

Re: connection with mysql database

antoniotiman — Thu, 24 Apr 2014 17:21:42 GMT

Hi Najy,

You use ODBC Connector of MySql.

Regards

Re: connection with mysql database

its_anandrjs — Thu, 24 Apr 2014 17:28:12 GMT

You can make ODBC connection for this like or you can use OLE db connection

Re: connection with mysql database

Joseph_Musekura — Thu, 24 Apr 2014 18:25:59 GMT

Hello,

In order to establish a connection from QlikView to a data sources e.g. SQL, MySQL or Oracle etc.., you need first to install related ODBC or OLE DB drivers on the QlikView machine (i.e. on which QlikView Desktop version was installed). The drivers can be found from the Database Vendor.

After installing drivers:

1. Open QV start page
2. Click on Edit Script icon
3. Go to Data tab
4. Under Database, for example select OLE DB
5. Connect
6. Now Select the Database Server (for e.g. SQL server)
7. Now enter <Server>Name and Login Credentials and press Ok to connect to Database Server.

Below link provide additional information.

http://oneqlikatatime.blogspot.co.uk/2012/04/how-to-connect-to-sql-server.html

/joseph