topic Re: connection to Oracle in QlikView

connection to Oracle

ali_hijazi — Mon, 04 May 2015 11:58:17 GMT

Hello got a QVW that is connecting to Oracle database to get data of some tables

the oracle server is 11g (version)

we are using ODBC to connect to database however the following is happening:

QlikView script starts; it needs 1 minute to display Connected

then it starts reading the first table and it takes 1 minute to read 10,900 records then another 1 minute to read the second 10,900 record and so on

the table is huge but what shall I check to make it read the whole table in less time; knowing that after 13 hours the script fails and gives ODBC connection failed

is it a problem in Qlik? I don't think so but what shall I look into?

please advise

Re: connection to Oracle

buzzy996 — Mon, 04 May 2015 12:23:01 GMT

we can set comparison as High in document properties,that helps to save some space..but as per my knowledge there is no property to quickly load data from oracle as a source.

u have to try to load ur data one by one table and see which table is taking more and creating the problem.

make sure all ur tables are getting from same source by using same ODBC connection, else u have to create different ODBC connections in same qvw accordingly ur source tables.

Re: connection to Oracle

ali_hijazi — Mon, 04 May 2015 12:27:50 GMT

yes I tried to load only one table and the response is very slow as described above