topic Re: Loading the datas from Database in App Development

Loading the datas from Database

Anonymous — Wed, 12 Sep 2018 15:43:48 GMT

Dear Qlik Experts,

I am new to Qlik Sense. I am populating the data from Oracle table through ODBC. This table contains more than 1million records. The populated reports will be weekly, monthly, Yearly.. Please suggest me weather I should load all the records the table or shall I load the records from based on input dates by using input fields.

Which one will be the good performance. Please suggest.

Thanks in Advance.

Prabha

Re: Loading the datas from Database

undergrinder — Wed, 12 Sep 2018 16:49:48 GMT

Hi Twat,

There is a dedicated connector for Oracle in Qlik Sense, I think it provides better performance than the pure ODBC driver.

For the reports data it depends on business needs. If you need only data for several weeks/months, then fewer rows have better performance, if you need see through all the data then load the entire data into Sense. Keep in mind huge amount of data may have poor performance on the front end.

You can't set date by input fields at reload, just relative date like today(), now(), or you can set that in variable in the load script. Or you can populate a parameter table in your database, that can work as the input parameters of your load.

Re: Loading the datas from Database

Anonymous — Thu, 13 Sep 2018 10:04:08 GMT

Hi Gabor,

Thanks for your information..

Can u pls tell me how to refresh the data, once I loaded the data.

Ex : I loaded the data from First day - 10th day. On 15th day 11-14th day records should fetch in the same Qlik file..

Please help me how to achieve this.

Thanks in advance.

Re: Loading the datas from Database

undergrinder — Fri, 14 Sep 2018 07:47:43 GMT

Refreshing the data is just a simple reload.

With Enterpsire version you can create a reload task, that is triggered by time, for example every month 1. day, or other tasks.

https://help.qlik.com/en-US/sense/June2018/Subsystems/ManagementConsole/Content/create-reload-tasks.htm‌

"I loaded the data from First day - 10th day. On 15th day 11-14th day records should fetch in the same Qlik file.."

It depends what you want, but every reload will refresh the whole data in your application.