Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

connecting QlikView to Oracle 10g

good day qlikview developers. i'm new to qlikview and i want to know how to connect qlikview to oracle 10g. i also want to know how to connect qlikview to an oracle database on a different different machine.

can someone teach me how to do this step by step??

thank you!

5 Replies
Not applicable
Author

Hi,

You can connect to oracle database through ODBC or OLEDB connectivity.

For ODBC Connectivity

Create the DSN.

In the File---Edit Script ----choose the ODBC option and select the DSN u have created.

For OLE DB Connectivity you can

In the File---Edit Script ----choose the OLEDB option and choose the Oracle driver (Oracle provider for OLE DB) and provide the Source details and credentials.

Before proceeding this ensure that necessary drivers are installed.

Regards,

XXX

Not applicable
Author

do i need to install an oracle instant client to connect to an oracle database on another computer??

Not applicable
Author

Yes if you want to use the OLE DB Connectivity.

I dont think you use the ODBC connectivity

Regards,XXX

Not applicable
Author

Not applicable
Author

thank you for giving me this site even though i didn't understand the language used on this site but the screenshots are big help..

Star