Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

QlikView Connection to Oracle's DB using ODBC

Hi Friends,

I am trying to connect Oracle Client using ODBC connection and is working fine. But I am facing issue in loading complete data from database/table. I am getting timeout or system will stop resoponding after getting around 30K records. The particular table is having approx 9L records. My query to database is very straight forward, it doesnot have any conditions or aggregations.

What could be the issue ? Do we need make any changes in connection string or at oracle configuration ?

Is it better to use OLE DB connection than ODBC ?

3 Replies
Miguel_Angel_Baeyens

Check with Oracle DBAs that the user running the extraction (which may not be your user, but the one used by QlikView) has permissions to read all available lines.

Also, make sure the timeout is coming from the driver, not from QlikView itself, it could be that for some reason the server runs out of resources or there are issues with the network and then the query fails.

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

Thanks for quick response, Meanwhile I will check with DBA's on your suggestion.

For smaller dataset we don't face any issue, but when trying to fetch more than 100K records we encounter this problem. Another thing is we get all the records whatever has been fetched till error will be available in qvw.

Do we have any document on Qlikview & Oracle connectivity configurations

Miguel_Angel_Baeyens

Maybe Qlik Support has some documentation, log a case and ask them. There is no "official" one, as far as I know.