BI Life Cycle : -
- Create Local database in SQL (Qlikview Server)
- Create Scripts for pulling data from software where you want to fetch records.
- Schedule Jobs for duration of 30 mins or 1 hrs (This will update data from source & destination)
- After this create temp views and temp tables to load data into qvw.
- Create QVD
- Load QVD in Qlikview
- Schedule QVW file in QMC for refreshing data.
Hope this helps you.