Deploying QlikView - Qlik | Help

1 Deploying QlikViewQlikView November 2017 Copyright 1993-2018 QlikTech International AB. All rights ,QlikTech ,QlikSense , QlikView ,Sense ,November201731 Introduction92 Planning QlikView Architecture10 Front End10 Back End11 QlikView Server11 QlikView Server Client Communication11 QlikView Server access to user Document13 Web Server13 QlikView Server Tunnel14 Directory Service Connector14 Management Service14 Distribution Service14 QlikView architecture without Distribution Service15 Reload Engine15 Documents, Data, and Tasks15 user Documents15 Shared Files16 Source Data16 Source Documents17 Tasks17 Transforming Source Document into user Document17 Ports18 Service by Service20 QlikView Server Load Sharing (Clustering)20 Overview20 Files21 Load Sharing (Clustering)22 QlikView Distribution Service24 Overview24 Files24 Changing the storage time of log files26 QlikView Batch27 Settings and Configuration27 Logs27 QlikView Publisher Repository27 Overview27 Files27 Security Groups28 Configuration Files28 QlikView Web Server30 Overview30 Files31 Directory Service Connector41 ContentsDeployingQlikView-QlikView12.

2 November20174 Overview41 Files42 DSP Interface42 QlikView Management Service43 Overview43 Files44 SNMP44 MIB Deployment47 Building a Farm47 Planning47 Trust Mechanism47 Web Server48 Redundancy Level48 Account to Run the Services Under48 QVPR Format48 user Directory48 user Authentication48 Firewalls48 Root/First Install48 Adding Services on Other Machines49 Clustering49 QlikView Server49 QlikView Distribution Service49 Directory Service Connector49 QlikView Web Server49 Clustering QlikView Servers50 Why Cluster QlikView Servers?51 Horizontal user Scalability51 Resilience52 Load balancing52 Requirements for Clustered QlikView Deployment52 Clustered QlikView Server License Key52 Shared Network Storage53 QVS Load Balancing Options53 Load Balancing the Web Server54 Building and Installing a QlikView Cluster55 Unbalanced QVS Clustering59 Setting up a QVS unbalanced cluster59 Customizing the load balancing algorithm60 Clustering QlikView Publisher62 Introduction62 Source Documents63 user Documents63 ContentsDeployingQlikView-QlikView12,Nov ember20175 Tasks63 Why Cluster QlikView Publisher?

3 64 Horizontal Scalability64 Resilience64 Requirements for a Clustered QlikView Publisher Deployment65 Clustered QlikView Publisher License Key65 Shared Network Storage65 Load Balancing Strategies65 Security67 Directory Services68 QlikView Server Authorization Modes68 Static Data Reduction69 Configuring QlikView Publisher Clustering69 Requirements69 Step-by-step Instructions69 Clustering QlikView Distribution Service73 What is a QDS Publisher Group?73 QDS publisher group configuration74 Task Configuration75 QlikView Server Extensions75 Adding Extensions to QlikView Server75 Configuring IIS for Custom Users76 QlikView Triggering EDX Enabled Tasks78 Cleaning and converting the shared files80 Verify mode80 Purge mode81 Converting the shared files81 Setting and changing ownership of shared file content81 Cleaning tool command format81 Using the shared file cleaning Security Overview86 Certificates86 Certificate Trust87 Architecture87 Requirements89 Certificate ports90 Protection of the Platform91 Functionality91 Special Accounts91 Supervision Account91 Anonymous user Account91 QlikView Administrators92 Communication92 ContentsDeployingQlikView-QlikView12.

4 November20176 Protection of AJAX Client92 Protection of Plugin92 Server Communication92 Services Communication92 SSL and TLS support92 Authentication93 Authentication when Using QlikView Server in a Windows user Environment93 Authentication with a QlikView Server Using an Existing Single Sign-on Software Package95 Authentication Using neither IWA nor Single Sign-on Software96 QlikView Server Authentication Using Custom Users97 Authorization98 Document Level Authorization99 NTFS vs. DMS99 Data Level Authorization99 Dynamic Data Reduction100 Static Data Logs and error codes101 Logging from QlikView Server101 Session Log101 Performance Log103 Server-side Extension Log106 Event Log107 End- user Audit Log108 Manager Audit Log112 Task Performance Licensing113 OEM114 General114 Detailed Function Description1143 QlikView Installing QlikView Server116 Before Installing QlikView Server116 Setup Procedure116 Logging the Installation118 Obtaining the MSI package118 Completing the Installation118 Running Microsoft IIS118 Handling Timeouts118 Enabling the Configuring servers with digital certificates121 Configuring security121 ContentsDeployingQlikView-QlikView12,Nov ember20177 Enabling SSL on QlikView servers121 Enabling SSL for QlikView Server (QVS)

5 122 Adding QlikView services122 Updating certificates124 Setting InstallingNewCertificatesAndCryptoKey flag124 Service failure due to undecryptable data125 How to erase corrupted Silent Installation125 Settings127 Dialogs127 Region127 License Agreement128 Customer Information129 Destination Folder130 Profiles131 Logon Information132 Service Authentication133 Ready to Install134 Additional Dialogs135 Custom Deploying MSI Packages with Group Policies136 General137 Deploying the MSI Package137 Advertising138 Step-by-step Guide1384 QlikView Upgrades and Maintenance contract on upgrade146 Restoring an older QlikView Desktop installation146 Restoring an older QlikView Server Upgrading and migrating QlikView Server147 Best practices147 Upgrading on the same machine147 Upgrading on a multi-server deployment148 Maximize Uptime148 Upgrading to a different machine149 Upgrade the current machine149 Install QlikView Server on the target machine149 Migrate and restore your QlikView Server backup149 Migrating an installation that uses QlikView Administrators Group150 Migrating an installation that uses digital certificates150 Upgrading and migrating a multi-server deployment151 Upgrading and migrating QlikView Server from to November 2017 or later152 ContentsDeployingQlikView-QlikView12,Nov ember20178 Upgrading on the same machine152 Upgrading on a multi-server deployment153 Upgrading and migrating to a different machine153 Upgrade QlikView Server to a different machine:153 Migrate and restore your backup.

6 154 Upgrading and migrating a multi-server deployment1545 Backup and Restore Backup and upgrade preparation156 Backing up files156 QlikView Server data directories156 ProgramData157 Program Files158 QVPR database files158 QlikView Webserver or Microsoft IIS159 Log files159 Licenses159 Certificates159 Updating certificates160 Backing up certificates160 Backing up custom content160 Changing default file locations160 Configuration files161 Multi-server Backing up and restoring certificates161 Backing up certificates161 Restoring certificates162 Services failure due to missing certificates163 Restoring certificates when migrating a QlikView Server installation164 Removing certificates164 Configuration files164 Using Microsoft Management Console165 Contents1 Introduction1 IntroductionIn this guide you will find information on how to plan and deploy QlikView , including installation advice.

7 QlikView Server is a platform for hosting and sharing QlikView information over an intranet or the Internet. QlikView Server connects users, client types, documents, and objects within a secure environment. QlikView Publisher manages content, access, and distribution. By reducing data, each user can be presented with tailored information. The QlikView Publisher service and user interface are fully integrated into QlikView Server and QlikView Management Console (QMC).DeployingQlikView-QlikView12,Novem ber201792 PlanningQlikViewDeployments2 Planning QlikView DeploymentsThis section provides details on the QlikView architecture, deployment, security, logging and Microsoft IIS is to be used as web server, it must be installed prior to QlikView is required for installation of QlikView Server. IPv6 is currently unsupported.

8 ArchitectureThe overall architecture of a QlikView installation reflects the separation of of a QlikView deployment Front EndThe front end is where end users interact with the documents and data that they are authorized to see via QlikView Server. The front end contains the QlikView user documents that typically have been created via DeployingQlikView-QlikView12,November201 7102 PlanningQlikViewDeploymentsQlikView Publisher ( QlikView Distribution Service with Publisher license) at the back end. All communications between the client and server take place here and QlikView Server is fully responsible for the client authorization. The front end relies on infrastructure resources (for example, Windows-based file share for clustering). QlikView Server currently only conforms with Windows file sharing. This means that storage must be owned, governed, and shared by a Windows operating system instance (typically accessed using a path like \\<servername>\<share>).

9 QlikView does not support Windows Distributed File System (DFS).Authentication of end users is (with exception of the built-in Custom Users) handled outside EndThe back end is where the QlikView source documents, created using QlikView Developer, reside. These source files contain scripts to extract data from various data sources (for example, data warehouses, Microsoft Excel files, SAP , and ). This extraction sometimes involves intermediate files (QVD files). The main QlikView component that performs the loading and distribution at the back end is the Distribution Service. The back end uses the infrastructure resources for clustering (for example, Windows-based file share) and may also use resources like SMTP servers and directory Server currently only conforms with Windows file sharing. This means that storage must be owned, governed, and shared by a Windows operating system instance (typically accessed using a path like \\<servername>\<share>).

10 QlikView does not support Windows Distributed File System (DFS). QlikView ServerThe number of servers (clustered or not) within an installation is only limited by the license. It is, however, not feasible to run more than one QlikView Server (QVS) process per server (physical or virtual). QlikView Server is designed to make the most of the resources available to it. Notably the QlikView Server keeps as many calculation results as possible cached in memory to keep the response times to a Server Client CommunicationThe QlikView Server client communication architecture requires three primary processes, which must be able to communicate with each other in a consistent and secure manner. This interaction can potentially involve multiple machines and multiple network connections, as well as other subordinate ,November2017112 PlanningQlikViewDeploymentsQlikView Server client communicationThe three primary processes are described Server(QVS) Provides QlikView functionality to the client.