topic Re: magento (e-com db) connection in QlikView

magento (e-com db) connection

Mon, 15 Jun 2015 03:35:01 GMT

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

Re: magento (e-com db) connection

SreeniJD — Mon, 15 Jun 2015 09:18:58 GMT

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

Re: magento (e-com db) connection

Mon, 15 Jun 2015 09:50:05 GMT

Hi Sreeni,

I want to have online db as source for qlikview applicaiton

Re: magento (e-com db) connection

arulsettu — Mon, 15 Jun 2015 09:55:21 GMT

Magento using mysql DB right?

Re: magento (e-com db) connection

SreeniJD — Mon, 15 Jun 2015 10:27:32 GMT

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

avinashelite — Mon, 15 Jun 2015 10:33:12 GMT

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!!