Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
pk
Contributor III
Contributor III

oracle to qlikview connectivity

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.

1 Solution

Accepted Solutions
docpuddu
Creator
Creator

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

View solution in original post

6 Replies
docpuddu
Creator
Creator

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

pk
Contributor III
Contributor III
Author

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

Please help.

 
 
 

DSN error.GIF

docpuddu
Creator
Creator

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

 

docpuddu
Creator
Creator

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

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

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Dianah
Contributor
Contributor

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