Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data load from Oracle to Qlik Sense

I am trying to load data from a table in Oracle into Qlik Sense Desktop. This table has around 5 million records.

Qlik Sense Desktop machine has 16GB RAM. While doing the data load in Qlik Sense the load is stopping midway and not progressing. Any idea what is the reason ?

5 Replies
shraddha_g
Partner - Master III
Partner - Master III

Is it giving any error?

sushil353
Master II
Master II

if you have date in your data set then you can store monthly qvd's one by one.

HTH

Not applicable
Author

Nope, no error. Just unresponsive.

Not applicable
Author

5 million records is just one month data. Meanwhile, we are trying to split it into smaller sections and create QVD.

Did anybody face any issue like this ?

Ricardo_Gerhard
Employee
Employee

Try to load a small data set, analysing memory and cpu each process, and increasing this limit until reach the problem.

Sometime the best way is reduce data set or update the database driver on Qlik Sense.

Ricardo Gerhard
OEM Solution Architect
LATAM