What is qlikview Expressor?

[#1]

How is it different from Qlikview Desktop

[alexandros17]

QlikView Expressor consists of three components.

1. Desktop: The graphical user interface used to develop and test data integration applications.

2. Date Integration Engine: The command line executable that runs QlikView Expressor data integration applications.

3. Repository: The version control system that integrates with Desktop and the Engine, supporting team development and controlled deployment.

While all three components may be installed onto computers running Windows XP, Windows 7/8, or Windows Server 2003/2008/2012, the standard approach is to install Desktop onto developer computers running Windows XP or Windows 7/8 and the Engine and Repository onto computers running Windows Server.1

A customer generally deploys Desktop onto many developer computers, configuring them to use a common Repository. This arrangement allows developers to work privately, in what is termed a Standalone Workspace, or within a team, in a Repository Workspace. Once an application’s development and testing is complete, a compiled version of the application may be checked out of Repository onto the computer hosting the Data Integration Engine. While many deployments install the Engine and Repository onto separate computers, it is perfectly acceptable to install these two components onto the same computer.

The Engine and Repository components of QlikView Expressor must be licensed and will not run until the license is installed. Desktop is functional without an externally applied license, but does not support the Write Teradata DT operator until an appropriate purchased license key has been installed.

you can find a lot of document in the community

[#3]

I have never worked with Qlikview Expressor and now wonder how is it different from the usual Qlikview Desktop and also its benefits over the Qlikview Desktop.

I just wanna know why we need another Expressor when we already have Qlikview Desktop?

[jagan]

Hi,

Qlikview Exprssor is an ETL(Extract, Transform, Load) tools like Informatica, DataStage, Talend, Abinitio etc.  ETL tools are used to extract data from various sources and transform the data into required format. 

ETL Definition:These are sophisticated GUI based applications that enable the operation of Extracting data from source systems, transforming and cleaning data and loading the data into databases. ETL tool resides on the ETL server.

Generally organizations prefers ETL tools if you are using multiple reporting environments  like BO, MSBI, Qlikview etc. to avoid the same transformation in all the reporting tools. 

Without ETL tools also you can create Qlikview Dashboards, but you have to transform and load the data into Qlikview, where as the ETL tools have many inbuilt transformations which are effective in transforming the data, also in ETL tools we can load the data from Source to Datasource by scheduling the ETL jobs.

Regards,

Jagan.

[ashfaq_haseeb]

Hi,

If you need more details and you want to work with expressor.

Then start from here Expressor Desktop & Server.

Regards

ASHFAQ