1 Reply Latest reply: Aug 20, 2013 12:28 AM by vikas mahajan RSS

    BI lifecycle flow within tool

      Hello Friends

       

      This Tool is new for me and started learning the same.Installed the free version and able to do the conection from oracle/sqlserver database.

      Can anybody help me to understand how the BI lifecycle flow within Qlickview tool.

      As i have read their are server/Desktop/report designer etc

       

      For Example:

       

      In sqlserver we have database we use MSBI for BI lifecycle

      like SSIS for making transformations

      SSA for cubes

      and SSRS to make reports

       

      In this case ....How this Qlikview work like MSBI?

        • Re: BI lifecycle flow within tool
          vikas mahajan

          Hii ,

          pournima

           

          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.

           

          Vikas