Skip to main content

3 Major Architecture Components in QlikView

The QlikView Desktop is a Windows-based desktop tool that is used by usiness analysts and developers to create a data model and to lay out the graphical user interface (GUI or presentation layer) for QlikView apps.

It is within this environment where a developer will use a SQL-like scripting environment augmented by ‘wizards’) to create the linkages (connection strings) to the source data and to transform the data e.g. rename fields, apply expressions) so that it can be analyzed and used within the UI, as well as re-used by other QlikView files.

Related: QlikView+Tableau+Jobs (Search and know skills needed)

The QlikView Desktop is also the environment where all user interface design and user experience is developed in a drag-and-drop paradigm: everything from graphs and tables containing slices of data to multi-tab architectures to application of color scheme templates and company logos is done here.

QLIKVIEW SERVER (QVS) - The QVS is a server-side product that contains the in-memory analytics engine and which handles all client/server communication between a QlikView client (i.e. desktop, IE plugin, AJAX or Mobile) and the server. It includes a management environment likView Management Console) for providing administrator access to control all aspects of the server eployments (including security, clustering, distribution etc.) and also includes a web server to provide front-end access to the documents within.

The web server’s user portal is known as Access Point. (It’s important to note that while the QVS contains its own web server,one can also utilize Microsoft IIS (Internet Information Server) for this purpose, too). The QVS handles client authorization against existing directory providers (e.g. Microsoft Active Directory, eDirectory) and also performs read and write to ACLs (access control lists) for QVW documents.

QLIKVIEW PUBLISHER -The QlikView Publisher is a server-side product that performs two main functions:
1) It is used to load data directly from data sources defined via connection strings in the source QVW files.
2) It is also used as a distribution service to reduce data and applications from source QVW
files based on various rules (such as user authorization or data access privileges) and to distribute these newly-created documents to the appropriate QlikView Servers or as static PDF reports via email.
Data sources that can be readily accessed by QlikView include standard ODBC or OLEDBcompliant
databases, standard flat files such as Microsoft Excel, XML, etc. as well as from systems such as SAP NetWeaver,, and Informatica.

Related: QlikView Video Tutorials

QLIKVIEW ITPro- QlikView’s approach to BI allows for a self-service model for business users on the front end while maintaining strict data security and governance on the back end. Because of this approach, IT professionals—from enterprise architects to data analysts — can remain focused on their core competencies: data security, data and application provisioning, data governance and system maintenance. They no longer have to spend time writing and re-writing reports for business users.
In a typical QlikView deployment, IT professionals focus on:
  1. Managing data extracts and data and system security
  2. Creating and maintaining source QlikView files (QVWs and QVDs)
  3. Controlling data refresh and application distribution through QlikView Publisher
  4. Administering QlikView deployments via the QlikView Management Console (part of QVS)


Popular posts

Blue Prism complete tutorials download now

RPA blue prsim tutorial popular resources I have given in this post. You can download quickly.Learning Blue Prism is really good option if you are learner of Robotic process automation. The RPA is also called "Robotic Process Automation"- Real advantages are you can automate any business process and you can complete the customer requests in less time.

The Books Available on Blue Prism 
Blue Prism resourcesDavid chappal PDF bookBlue Prism BlogsVideo Training
RPA training The other Skills you need
Basic business skills and Domain skills are more than enough to be successful in this automation careerScripting languages like Perl/JSON/JavaScript/VBScript.  The interesting point is learning any RPA tool is not a problem. You can learn tool quickly. The real point is how quickly you apply your knowledge to implement automated tasks is important.

Also read
Robotic RPA Software developer skills you needBlue Prism tutorials download to learn quicklyPopular RPA tools functionality differen…

Three popular RPA tools functional differences

Robotic process automation is growing area and many IT developers across the board started up-skill in this popular area. I have written this post for the benefit of Software developers who are interested in RPA also called Robotic Process Automation.

In my previous post, I have described that total 12 tools are available in the market. Out of those 3 tools are most popular. Those are Automation anywhere, BluePrism and Uipath. Many programmers asked what are the differences between these tools. I have given differences of all these three RPA tools.

BluePrismBlue Prism has taken a simple concept, replicating user activity on the desktop, and made it enterprise strength. The technology is scalable, secure, resilient, and flexible and is supported by a comprehensive methodology, operational framework and provided as packaged software.The technology is developed and deployed within a “corridor of IT governance” and has sophisticated error handling and process modelling capabilities to ensu…

Super Easy Ways To Learn Everything About analytics top books

This post why I am writing is most of the analytics jobs now a days are in financial projects. The domains are finance,  Banking, Payments and credit cards. Skills you need are like SAS, UNIX, Python and Java Script. These are top books for beginners in data analysis in financial analytics.

Top books you need SAS best book to read
I found one best book that is little SAS. This covers almost all best examples and critical macros you need for your job.

The best-selling Little SAS Book just got even better. Readers worldwide study this easy-to-follow book to help them learn the basics of SAS programming. Now Rebecca Ottesen has teamed up with the original authors, Lora Delwiche and Susan Slaughter, to provide a new way to challenge and improve your SAS skills through thought-provoking questions, exercises, and projects.

UNIX best book
Unix you will get all basic commands every where.  Macros or shell scripts how to execute is really you need. Good book so that you can automate tasks.