Qlik Community

QlikView Connectors

Discussion board for collaboration related to QlikView Connectors.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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
Highlighted
Contributor III
Contributor III

Re: oracle to qlikview connectivity

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

5 Replies
Highlighted
Contributor III
Contributor III

Re: oracle to qlikview connectivity

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

Highlighted
Contributor II
Contributor II

Re: oracle to qlikview connectivity

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

Please help.

 
 
 

DSN error.GIF

Highlighted
Contributor III
Contributor III

Re: oracle to qlikview connectivity

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

 

Highlighted
Contributor III
Contributor III

Re: oracle to qlikview connectivity

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

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

Highlighted
Digital Support
Digital Support

Re: oracle to qlikview connectivity

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.