Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
new2qlik
New Contributor III

What is the correct process to load data?

I inherited this environment with qlik sense 3.0. We used web based portal to access qlik.

Over the last couple of days, I been researching how it's set up.

We have jobs/tasks to update the data from mysql/sql.

The data are store in qvd in extract and transform folder. So I'm still figuring this out.

I'm trying to create test scripts/tables and trying to figure out the correct process. I'm able to complete the steps, but not sure if I have the correct order. I can't find anything on this.

1. pull data from mysql or sql.

2. store it in qvd

3. when I'm ready, use data load editor web base to load from qvd file ?

4. When I do this, I'm not seeing the new table in data model viewer and doing preview, am I missing a step?

does it make a difference if I use qlikview desktop or web base data manager?

Tags (1)
2 Replies
tushar_030
Contributor

Re: What is the correct process to load data?

Hi,

      The best practice is to follow the load data and qlik performance is to use "Three tier Architecture"

Please find below URL:-

https://community.qlik.com/t5/New-to-QlikView/Creating-3-tier-architecture/td-p/620386

https://community.qlik.com/t5/QlikView-Documents/Three-Tier-Architecture/ta-p/1483564

 

Thanks

Tushar

new2qlik
New Contributor III

Re: What is the correct process to load data?

omg, that article you posted were so helpful.

I couldn't find that. Thank you so much!