topic Re: Is Qlikview Expressor a ETL tool ? in QlikView

Is Qlikview Expressor a ETL tool ?

chiru_thota — Tue, 06 May 2014 14:35:26 GMT

Hi All,

By using Qlikview expressor can we combine more than one QVW data models and create a new report ?

Thanks,

Chiru

Re: Is Qlikview Expressor a ETL tool ?

advait_thakur — Tue, 06 May 2014 14:53:52 GMT

Hi Chiranjeevi,

Expressor is a data integration tool with a semantic framework and primary purpose is to manage deployment, data and metadata. It maintains data consistency with all applications and offers a reusable version which is controlled in repository to reduce development time. I am attaching a link for your reference, please have a look on it, I hope this is informative and helpful.

http://community.qlik.com/blogs/qlikviewdesignblog/authors/mto

Regards

Advait

Re: Is Qlikview Expressor a ETL tool ?

Tue, 24 Jun 2014 23:17:18 GMT

Hi Chiru,

QlikView Expressor (QVE) provides data governance and data management within a QlikView environment; providing visibility and data confidence in QlikView deployments. It strengths enable the creation of a single conformed data management layer that can be used to drive QlikView applications.

QlikView Expressor has also been used as an ETL (Extract Transform Load) / data integration tool to supplement other data preparation needs such as the creation of various data stores. This is common in a setting where other ETL tools are not available.

QVE can help consolidate multiple data sources, augment data and create a data store/mart/warehouse to be accessed by QlikView and other applications. Other benefits of QlikView Expressor include its ability to graphically prepare and control the flow of data while storing, sharing and reusing various components of the development process.

Thanks,

Varun Bhat

Re: Is Qlikview Expressor a ETL tool ?

rwunderlich — Wed, 25 Jun 2014 01:32:29 GMT

Yes, Expressor is an ETL tool.

No, Expressor cannot directly combine multiple qvw data models into a single data model.

The general flow (with or without Expressor) to combine qvw models is:

1. Binary load the qvw.

2. Store each Qlikview table in the model to a QVD.

3. Load those QVDs into a new,merged QVD.

NOte that because of the restriction that a script may contain only one binary statement you can't process the above in a loop over multiple QVWS. You have to build a separate script for each qvw, or alternatively, store the QVDs in the script that builds the model.

Rob