topic Re: Architecture in QlikView

Architecture

prabhas277 — Tue, 17 Nov 2015 02:24:19 GMT

Hi expets,

What is the use 3 tire architecture compared to 2tire in qlikview.

Re: Architecture

tamilarasu — Tue, 17 Nov 2015 02:33:12 GMT

Hi Prabhas,

Check the below link,

what is qlikview architecture? what is 1-tier arc and 2-tier arch?

Re: Architecture

ashfaq_haseeb — Tue, 17 Nov 2015 05:58:58 GMT

Hi,

Hopefully this will help you.

3 Tier Architecture + QDF

Regards

ASHFAQ

Re: Architecture

Anonymous — Tue, 17 Nov 2015 06:08:45 GMT

Basically we use to follow 4 tier in most of the cases like:

In First Tier:

Data is loaded from the Database and stored in QVDs(Raw Level)

In Second Tier:

Data is loaded from QVDs and tranform the data based on business needs(Transform Level)

In Third Tier:

Load the Transform Qvds and Create the Data Model Level

In Fourth Tier:

Using the Binary load the Qlikview file created in Tier 3 is loaded in to the Qlikview file and all chart objects are created in this Tier(UI Level)

If summarize, we get:

1) Data Layer(Raw & Transform)

2) Business Layer(Metrics & Relationship)

3) Presentation Layer(DAR Concept)

For More Details, see:

Three Tier Architecture

Re: Architecture

ramasaisaksoft — Tue, 17 Nov 2015 06:26:26 GMT

Hi Prabhas,

three-tiered QlikView environment:

• Tier 1 application files are the data connection layer. The QVW connects to the database and runs the SQL queries of database tables to generate QVDs.

• Tier 2 is the transformation layer where transformations are performed by tier 2 QVWs with data from tier 1 QVDs. This information is stored in tier 2

data model QVDs.

• Tier 3 is the GUI/presentation layer, which uses tier 2 QVDs for the data model.

Re: Architecture

Tue, 17 Nov 2015 06:45:26 GMT

Re: Architecture

mohammadkhatimi — Tue, 17 Nov 2015 06:59:58 GMT

Hie...

PFA

Hope this will helps you...!!

Regards,

Mohammad

Re: Architecture

ChennaiahNallani — Tue, 17 Nov 2015 07:05:24 GMT

Hi Prabhas,

If you are dealing with large amount of data set. we need to implement incremental load to updated qvd's. so in this case

we can implement 3 Tier architecture.

1st tire : we extract data for DB and store in to QVD's and Implement incremental load.

2nd tire : we can build Association model based in Client requirement and store in QVD'S.

3rd tire : user 2nd tire QVD's we design GUI.

Re: Architecture

Tue, 17 Nov 2015 08:27:00 GMT

Hi,

In 2 Tier, all the Data Extraction is done and stored in QVD files in one Qlikview file and Transformation and Presentation using QVD files generated in previous file are done with in another Qlikview file.

In 3 Tier, Data Extraction is done and stored in QVD files in on Qlikview file, Transformation is done using Qlikview files in another file, Presentation is done in another file using Binary load of Transformed Qlikview file.