Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

magento (e-com db) connection

Hello experts there,

Can anyone tell me how do we establish connection to any online db from Qlikview?

Lets say, i have host name, user name and password for the online db, how could i establish connection to this db from Qlikview?

Please assist.

Thanks a lot in advance !!!

Gowri Shankar

5 Replies
jaaldurgam
Valued Contributor

Re: magento (e-com db) connection

Hi Gowri Shankar,

Do you want to deploy Qlikview application online or you want to have Online DB as a source to Qlikview application. Can you please bit clarify.

Sreeni

Not applicable

Re: magento (e-com db) connection

Hi Sreeni,

I want to have online db as source for qlikview applicaiton

arulsettu
Honored Contributor III

Re: magento (e-com db) connection

Magento using mysql DB right?

jaaldurgam
Valued Contributor

Re: magento (e-com db) connection

It should be through ODBC connectivity only. I guess there is a dedicated driver which can establish a connection from Magento to Qlikview.

Regards,

Sreeni

Re: magento (e-com db) connection

Hi Gowri,

First find the specific driver for the magento db and install the driver in your system , then added a user DSN in the system if your able to do it the your work is almost done. Once DSN is successful then go to Qlikview >edit script> ODBC connection >select show system DSN > choose the DSN you have added , that it!!

Community Browser