topic Re: ETL ( QlikView) in QlikView

ETL ( QlikView)

Thu, 24 Apr 2014 06:22:01 GMT

Hi QlikView Experts,

I am new in QlikView I am trying to be familiar with this product I heared that QlikView is having ETL thing i

is it ? can anyone explain me how ..

Regards

Bhuwan

Re: ETL ( QlikView)

its_anandrjs — Thu, 24 Apr 2014 06:26:04 GMT

You can do the ETL with the qlikview application and refer this manuals

ETL-Tools_QlikView_Connector_User_Manual.pdf

ETL-Tools QlikView Connector

And refer this also

ETL details and Overview

Re: ETL ( QlikView)

whiteline — Thu, 24 Apr 2014 06:28:26 GMT

Hi.

Read the QlikView reference manual.

Re: ETL ( QlikView)

sujeetsingh — Thu, 24 Apr 2014 06:33:26 GMT

ETL Concepts as:

---Option to load data as temp tables

---functions to implement your logic

---One can implement Data ware house concepts as Star schema

A lot more so just follow Reference manual.

Re: ETL ( QlikView)

its_anandrjs — Thu, 24 Apr 2014 06:39:15 GMT

You can do ETL from your own way like

Extract

1. Read the raw data in the qlikview application.

Transform

2. Read the raw data and transform the field in a meaning full way using various functions and apply to tables.

Load

3. Read the transform data and loading the data according to business logic or create a data ware housing concepts.

Re: ETL ( QlikView)

jagan — Thu, 24 Apr 2014 07:04:37 GMT

Hi Bhuwan,

You can transform the data like Other ETL tools do using Qlikview Scripting. If you want you can also Expressor tool for Qlikview ETL also.

You can use normal SQL queries to load the data into Qlikview, and if you are using any Flat files then you have to use LOAD statement of Qlikview.

In Qlikview there are many in built transformations available like CrossTable(for unpivoting), IntervalMatch, Mapping Load for Lookup, Generic load, Joins like LEFT, RIGHT and INNER, etc.

Refer Qlikview Reference manual or you buy Qlikview 11 for Developers, in this books you can find more details.

Hope this helps you.

Regards,

Jagan.

Re: ETL ( QlikView)

Thu, 24 Apr 2014 07:21:08 GMT

Thank You I will read it.

Re: ETL ( QlikView)

Thu, 24 Apr 2014 07:21:44 GMT

Thank You I will read it.

Re: ETL ( QlikView)

Thu, 24 Apr 2014 08:56:35 GMT

Thank You Jagan.

Re: ETL ( QlikView)

Thu, 24 Apr 2014 09:25:23 GMT

Thank You Guys ..for your valuable informations.

Re: ETL ( QlikView)

Thu, 24 Apr 2014 11:51:05 GMT

Yes Bhuwan,

we can transform data in qlikview scripting.

in qlikview we have different built in Transforms like CrossTable, keep and joins like inner,left and right, generic load, mapping load (works like lookup) .....

Please refer qlikview manual you can find more detail information.