If you are installing or upgrading Qlik DataTransfer on a Windows server with Qlik Sense Enterprise on Windows installed, Qlik DataTransfer must be installed with the Qlik Sense services user used in the Qlik Sense installation.
For February 2021 SR1, it is recommended to install Qlik DataTransfer on a separate server from Qlik Sense Enterprise on Windows or QlikView Server. If Qlik DataTransfer is installed on the Qlik Sense Enterprise on Windows server or QlikView Server, the Qlik DataTransfer runs using the Local System user account. If you change the service user account, it will stop either Qlik DataTransfer or the Qlik Sense Service Dispatcher.
If you are upgrading Qlik DataTransfer on a Windows server with Qlik Sense Enterprise on Windows installed, Qlik DataTransfer must be upgraded with the Qlik Sense services user used in the Qlik Sense installation.
QlikView is the most flexible enterprise Business Intelligence platform for transforming information into knowledge. Users can effectively consolidate relevant data from multiple sources into a single application, create reports, and visualize content for unprecedented business insight using QlikView. QlikView Server allows the nesting of multiple servers for data load balancing and enables users to access data using their PC and mobile devices. QlikView Publisher ensures that the right information reaches the right user at the right time, and gives further centralized administration and management.
With extensive practical examples and quality screenshots, the book starts by giving you a detailed understanding of QlikView Server and will proceed to help you get to grips with managing the server. From deploying a simple QlikView Server on a single-box, to an enterprise deployment on multiple servers, to alternative authentication options, you will learn all the areas that you need to know about.
Of course, under the hood, it is a lot more complex than that. There are multiple services in action. The main one is the QlikView Server service that actually loads the documents into memory on the server and delivers the information to clients. The QlikView Web Server service hosts AccessPoint and renders the QlikView documents to web and mobile clients. The Directory Service connector allows QlikView to connect to different user repositories and the QlikView Management service links everything together.
Because QlikView is built on a Service Oriented Architecture (SOA), we will also look at the architecture of the different services so that you might understand how many servers you might need to deploy.
The installation will automatically create the QVPR (this is a legacy from the QlikView Publisher Repository, but it is not just about publisher any longer), an XML file-based storage of server settings managed by the QlikView Management service. Because these XML files are potentially corruptible on the filesystem, some administrators would prefer to have them stored in a more robust database. There is an option in the QlikView Management Console, to migrate the QVPR to SQL Server. This SQL Server could be running on the same server as the QlikView services but it is not recommended, as it will consume resources that might be needed by QlikView. It is worth noting that if you keep using the XML repository, the XML files will be backed up to ZIP files on either a daily basis or on a schedule that you can configure.
I have used all of these browsers and although I have a personal preference for Google Chrome, all of them should work fine. You will have to watch out if using IE on your server because the enhanced security option is often enabled. In these circumstances, I have sometimes found myself having to download Firefox (because IE blocks the Chrome download!)
Because QlikView Server is so hardware intensive, it is rarely appropriate to host the QlikView Server on a server that will also host other services such as Microsoft SQL Server, Microsoft Exchange Server, and so on. By default, QlikView Server will consume up to 90 percent of the available physical RAM on the server and that doesn't leave much for other services.
It is worth remembering that a 32-bit Windows process can only access a maximum of 2 GB of memory. So, if you are running a 32-bit QlikView Server, there would be little point in having more than 4 GB of memory. On the other hand, if you are running 64-bit Windows, 4 GB would be an absolute minimum! I wouldn't normally recommend a 32-bit server for QlikView. Since Windows 2008 R2, there is no longer a 32-bit version of Windows Server.
The following table can be used as a very rough estimate for the size of server that you might need. When considering the number of Fact rows (lowest level transactions) and number of users, you should consider all of the expected applications and allow an increase over time.
QlikView Server works well on a VM. For many years now, VMWare has been "officially" supported, but I have also implemented it on Citrix XEN. The QlikView Demo servers are hosted on Amazon EC2 servers (a variation of XEN). Essentially, QlikView Server is a Windows application, and so will run on Windows, including virtualized servers.
Having said that, we need to be aware that QlikView is an intensive user of the hardware on the server. There will be a performance hit on a virtual server because of the overhead of the hypervisor. The nature of QlikView Server's use of hardware is that it tends to require memory and CPU in intensive bursts. This does not work well with virtual servers with any type of shared resource or ballooning. If there is any significant latency when QlikView Server tries to access resources, the service can crash. For this reason, resources assigned to a QlikView Server should be reserved for that server.
The Named User license is, as its name suggests, a client access license that is associated with a particular user. This is the most flexible of the license types from the perspective of document access. A named user can open as many server documents as they have access to.
The Small Business Edition (SBE) Server is a fully-functional QlikView Server that is designed to sit on one server only and has a limit on the number of users that can be licensed.
This is the license that most large organizations will deploy. QlikView Enterprise has no limitations on the number of Named User or Document licenses and allow Concurrent and Usage licenses. We can also introduce server clustering.
Once the Publisher license has been added, the Distribution Server can be deployed on its own server and can perform a much wider range of tasks including reloads, reduction of data in documents based on selections in the document, distribution of documents to multiple locations, and execution of external tasks. Each of these tasks can have multiple triggers and multiple dependencies (a dependency means that the execution of another task must have completed successfully prior to this task being started). It also introduces the additional server management option of having document administrators and the publisher authorization portal. The document administrators can be given the rights to administer a particular server folder. This includes changing document settings and reloads. The publisher authorization portal allows you to create mapping tables that are stored on the publisher server. The design purpose of these is to implement Section Access tables, but they can actually be used for any lookup tables that you might need.
QlikView Server (QVS): The QlikView Server service is the core engine of QlikView when deployed on a server. It loads the QVW documents into memory, performs the necessary calculations to present the correct results, and handles user and document memory allocation.
Problems only start to arise where there is a scarcity of memory. The QVS will grab as much system memory as it can, up to about 90 percent of physical RAM (this is configurable), and will tend to hang on to allocated memory, especially user cache, once it has taken it. Any reload task will use memory as needed, and that could be a lot of memory if there are complex script processes. If there are reloads happening during the day, the server will come under resource pressure, which can cause errors, failures, and unhappy users.
An Enterprise deployment will require multiple servers with different services running on each. It will also normally have multiple QVS servers using QlikView Cluster technology. An example configuration might be similar to the one shown in following diagram:
The web servers can also be deployed in a, so-called, DMZ (a security zone, protected by network firewalls that allows people on the Internet to connect to the web server but not to get any direct access to the QlikView Server) to provide the ability to publish QlikView data externally.
By default, all Desktop clients will have a Personal Edition license. This means that they can create new content but cannot share it with other Personal Edition licensed users. If a user opening a server document has a Named User license, and the server is configured to allow leasing, the license will be leased to the Desktop client. The status will change from Personal Edition to QlikView User License (using license lease from server). The user will now be able to create new content that can be shared with other licensed users. This license is leased for 30 days at a time. Every time you run the QlikView Desktop executable, it will try and refresh the lease for a further 30 days. If you have been disconnected from the server for more than 30 days, it will revert to Personal Edition. 2b1af7f3a8