Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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
SreeniJD
Specialist
Specialist

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
Author

Hi Sreeni,

I want to have online db as source for qlikview applicaiton

arulsettu
Master III
Master III

Magento using mysql DB right?

SreeniJD
Specialist
Specialist

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

avinashelite

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