Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manojkulkarni
Valued Contributor 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
MVP
MVP

Re: QlikView Connection to Oracle's DB using ODBC

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
Valued Contributor II

Re: QlikView Connection to Oracle's DB using ODBC

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

MVP
MVP

Re: QlikView Connection to Oracle's DB using ODBC

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

Community Browser