Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Data load from Oracle to Qlik Sense

Is it giving any error?

sushil353
Honored Contributor II

Re: Data load from Oracle to Qlik Sense

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

HTH

Not applicable

Re: Data load from Oracle to Qlik Sense

Nope, no error. Just unresponsive.

Not applicable

Re: Data load from Oracle to Qlik Sense

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 ?

dcj
Valued Contributor II

Re: Data load from Oracle to Qlik Sense

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.