topic Re: Loading mysql data in QlikView

Loading mysql data

Thu, 11 Jul 2013 09:02:22 GMT

hi everybody,

can anybody pls explain me how to connect to mysql database.

i installed mysql nmysql odbc driver.

when i am trying to create user DSN,its asking for datasource.i dont hav any mysql file.is there any database available in mysql wch i connect to qlikview.

am attaching screen shot..

Re: Loading mysql data

kaushiknsolanki — Thu, 11 Jul 2013 09:07:53 GMT

Hello Monica,

You need to define the database to which you want to connect.

Give any Datasource name and description.

TCP/IP server name will be the PC on which you have mysql server installed or if its on same machine you can use localhost.

Keep the port number same.

Give user name and password.

Also select the database.

Regards,

Kaushik Solanki

Re: Loading mysql data

Thu, 11 Jul 2013 09:10:45 GMT

i want to connect to northwind database wch mysql provide by default..

so in that case what i write in datasource name.

Re: Loading mysql data

kaushiknsolanki — Thu, 11 Jul 2013 09:15:16 GMT

Hi,

Datasource name can be anything by which you can identify which database you are connecting.

Its user specific.

Regards,

Kaushik Solanki

Re: Loading mysql data

Thu, 11 Jul 2013 09:45:25 GMT

thans kaushik..i got it n finally able to connect musql database with qlikview.

Re: Loading mysql data

kaushiknsolanki — Thu, 11 Jul 2013 09:47:34 GMT

Great Cheers.

Re: Loading mysql data

Tue, 13 Aug 2013 06:53:42 GMT

I am new to Qlikview, and I am being able to connect with MySQL database. But I don't know how to use those databses. Please help me out. Thanks in advance.........