Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
new2qlik
Contributor III
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?

2 Replies
tush
Creator II
Creator II

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

omg, that article you posted were so helpful.

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