topic Re: oracle to qlikview connectivity in QlikView

oracle to qlikview connectivity

pk — Mon, 26 Jan 2026 21:26:37 GMT

hello everyone,

I want to extract data from Oracle to qlikview.
Please let me know what details i need and what steps i need to follow fro the same.

thanks in advance.

Re: oracle to qlikview connectivity

docpuddu — Wed, 13 Nov 2019 15:49:24 GMT

Hi,
you have to check some points. Let's see them quickly...

1. Make sure you have a DSN configured in your PC/host
2. you can see directly from Qlik Edit script. Open the menu Tools and you can find ODBC 64 bit configuration
3. Check you have a proper ORacle driver configured etc.
4. Test your connection
5. then in the bottom area of your window -> Database -> select ODBC -> click on button Connect -> choose your target DB
6. A connect string will be added to your script
7. Now click on Select to find the table/source to get your data
8. select fields and follow the wizard. At the end a LOAD piece of code will be added to your script

HTH.
Ciao,
/Andrea

Re: oracle to qlikview connectivity

pk — Fri, 15 Nov 2019 12:17:09 GMT

docpuddu
thanks for you responce, But am getting below error while configuring/creating DSN.

Please help.

Re: oracle to qlikview connectivity

docpuddu — Fri, 15 Nov 2019 12:24:03 GMT

Hi,

you have to install the Oracle driver on your machine.

Please visit the oracle download page and choose the right version:
https://www.oracle.com/database/technologies/112010-win64soft.html

then go back to Qlik and go on with the configuration as you were doing.

Ciao,
/Andrea

Re: oracle to qlikview connectivity

docpuddu — Fri, 15 Nov 2019 12:37:24 GMT

P.S.
There are several guides regarding Oracle Client installation.

Just as an example:
https://www.youtube.com/watch?v=cZDDI9HFBIU

Re: oracle to qlikview connectivity

Brett_Bleess — Mon, 18 Nov 2019 18:31:46 GMT

Priti, did Andrea's posts allow you to get things working with your Oracle data source? If so, please be sure to come back to the thread and use the Accept as Solution button on the post(s) of his that helped you get things working. If you still have further questions, the other place I would suggest looking in this case is the Oracle Community site, as I am sure there are a lot more examples there of how to install the client driver for Oracle and configure ODBC/OLE DB connections etc.

Regards,
Brett

Re: oracle to qlikview connectivity

Dianah — Mon, 19 Dec 2022 05:55:25 GMT

Connecting to Oracle from QlikView using ODBC Driver for Oracle
Open the QlikView client application and click File > New.
In the Data tab, choose ODBC from the Database drop-down and click Connect.
To retrieve the data from your data source, you can enter an SQL query and press F5.

Regards,

Will