Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
docpuddu
thanks for you responce, But am getting below error while configuring/creating DSN.
Please help.
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
P.S.
There are several guides regarding Oracle Client installation.
Just as an example:
https://www.youtube.com/watch?v=cZDDI9HFBIU
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
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