topic Re: 3 tier Architecture application suggestions in QlikView

3 tier Architecture application suggestions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can anyone please tell me that How to create Three Tier Architecture application.

I have qvd generator and i fetch all data from that generator file for creating main application

I don't understand that how to create Transform( QlikMart Layer) and after Presentation (Presentation Layer)

I have already read thread: community.qlik.com/docs/DOC-8519

But I need some sample application which is already build on Three Tier Architecture

Please advice.

Thanks

Re: 3 tier Architecture application suggestions

MK_QSL — Wed, 27 Apr 2016 07:38:30 GMT

Tie 1: Extract Layer

Extract Data from Database and store in QVDs... Can use Incremental Load here ...

Tier 2: Transform Layer
Load QVDs generated from Tier 1 and Perform all Joins and scripting functions here.. Now Again store the tables in QVDs.

Tier 3: Presentation Layer

Load all QVDs generated from Tier 2 in this layer.

Re: 3 tier Architecture application suggestions

Anonymous — Wed, 27 Apr 2016 07:45:53 GMT

Hi Manish,

Thanks for your quick response ..

In First Tier:

Data is loaded from the Database and stored in QVDs.

In Second Tier:

Data is loaded from QVDs and tranform the data based on business needs.

In Third Tier:

Using the Binary load the Qlikview file created in Tier II is loaded in to the Qlikview file and all chart objects are created in this Tier.

In this what about Binary load

you have not mention about Binary load

Thanks

Re: 3 tier Architecture application suggestions

MK_QSL — Wed, 27 Apr 2016 08:01:27 GMT

After Tier 2... instead of storing tables in QVDs you can keep as it is and load the QVWs to presentation layer as a binary load.. But I would not prefer this...

Consider that some of the tables from Tier 2, you need to use in other application... In this case, if you have stored them in QVDs, you can easily use them.

Re: 3 tier Architecture application suggestions

salto — Wed, 27 Apr 2016 08:02:08 GMT

Hi,

I paste this from: when binary load is use ?

From the HELP:

"The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables."

Hope this helps.

Re: 3 tier Architecture application suggestions

jagan — Wed, 27 Apr 2016 08:05:03 GMT

Hi,

Tie 1: Extract Layer

Extract Data from Database or flat files and store it in QVDs.

Tier 2: Transform Layer
Load QVDs generated from Tier 1 and apply the business logic and transformations required in this layer and create the Datamodel.

Note: in this layer no charts are created.

Tier 3: Presentation Layer

Binary load Transform Layer QVW file into this and create charts in this file.

Binary load is nothing but loading the QVW created in the Second Tier (Transformed) into the third tier by using the Binary Load.

Binary Load will load all the tables and data from one Qlikview file to another qlikview file. The Binary should be first statement in the Qlikview script.