Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Partner
Partner

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 ?

Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM