Installing QlikView Server

This documentation outlines the steps you need to follow to install and license QlikView Server. For a description of how to install QlikView Desktop, see: Installing QlikView Desktop.

Before Installing QlikView Server

Before installing QlikView Server, you need to consider:

• If Microsoft IIS is to be used as web server, it must be installed prior to QlikView Server.
• It is not possible to install QlikView Server to a server that acts as a domain controller.
• Internet protocol IPv4 or IPv6 is required for installation of QlikView Server.
• When installing QlikView Server/Publisher, several security groups are created. Several other security groups must be created following the installation. These must be properly configured to ensure that the appropriate services can run, and to ensure that users can access the appropriate functionality. Before you begin the installation, see Security Groups in QlikView Publisher Repository.
• It is recommended not to move folder locations after the QlikView Server installation is complete, since many settings depend on the initial file locations. If the location of QlikView Server has to be changed after the installation, uninstall QlikView Server and then reinstall.
• Any previously defined tasks are deleted when the QlikView Publisher license is activated.

Setup Procedure

Run the QlikView Server installation executable:

Microsoft Windows x64 version: QlikViewServer_x64Setup.exe

If the User Account Control dialog is displayed, click Yes to allow the program to make changes on this computer.

Click Next in the Welcome dialog.

Select the region for the location of the server. Click Next to continue.

Read the license agreement, select I accept the terms in the license agreement, and click Next to continue.

Enter the customer information for QlikView Server. Click Next to continue.

All files are installed in the specified folder. To change the root folder for the installed files, click Change to specify the preferred location. Finally, click Next to continue.

Select the type of installation you want to perform:

Full installation, Single machine with QlikView Webserver: Used to run all components on a single machine with QlikView Web Server as web server.

Full installation, Single machine with Microsoft IIS: Used to run all components on a single machine with Microsoft IIS as web server. This option is only available if IIS is installed on the target machine.

Custom installation, select profiles: If this option is selected you select the profiles you want to be included in the installation from the Profiles section in the dialog:

QlikView Server: Installs QlikView Server, Directory Service Connector, and the QlikView Server example documents.

Reload/ Distribute Engine: Installs the Reload Engine and the QlikView Distribution Service.

Management Console: Installs the QlikView Management Service together with the QlikView Management Console (QMC).

Webserver: Installs the QlikView Web Server.

To make further configuration of features to be installed, click Config. When done, click Next.

To use pre-defined configuration of features, click Next.

Set the account that the QlikView Server and Publisher services are to run under. Click Next to continue.

Note:The account that is used to run the QlikView services must have local administrator privileges.

You can also select I want to specify the account to be used for the services later.

Select the IIS Website from the drop-down list and click Next.

Note:This step is only applicable if Full installation, Single machine with Microsoft IIS was selected in Step 8. If not, proceed directly to the next step.

Select the Service Authentication method:

Use digital certificates: Authenticate communication between QlikView servers using digital certificates and SSL. This alternative is recommended in environments where not all servers have access to a common Windows Active Directory or when the security provided by certificate authentication is required. Note that digital certificates are only supported by Windows Server 2008 R2 and later.

Use QlikView Administrators Group: Authenticate communication between QlikView services based on membership in the local Windows group QlikViewAdministrators. This alternative can be used in environments where all servers that are part of the QlikView installation can authenticate using a common Windows Active Directory.

Click Next to continue.

Click Install to start the installation.

Note:This may take several minutes to complete.

Click Finish when the installation is complete.

Log off from Windows® and then log on again, so that group memberships added during the installation are updated.

Note:It may be sufficient to log off from Windows and then log on again. However, it is recommended to restart the machine to enable the QlikView Server functionality.

Logging the Installation

The setup procedure is logged when running the QlikView Server installation executable. The log files are as follows:

Microsoft Windows x64 version: QlikViewServerx64.wil

The log files are stored in the Temp folder of the user (for example, %UserProfile%\AppData\Local\Temp). Each time an installation is executed, a new file is generated, over-writing the previous log file.

Obtaining the MSI package

If the MSI package is needed for the installation, proceed as follows to extract it from the .exe file:

Start the installation from the .exe file and wait until the first dialog opens.

Locate the MSI file (often stored with a random name, for example, ed34g.msi) in the Temp folder in %UserProfile%\AppData\Local.

Copy the .msi file to another location.

Exit the .exe installation.

Install QlikView Server using the .msi file.

Silent Installation

Deploying MSI Packages with Group Policies.

Completing the Installation

After successfully installing QlikView Server, a license must be registered in QlikView Management Console (QMC) to activate the installed software.

Note:If access is denied when starting QMC, log off from Windows and then log on again, so that group memberships added during the installation are updated.

Note:Running real-time anti-virus protection on the server degrades the performance of QlikView Server. It is recommended that the user documents, source documents, log directories, and .pgo files are excluded from the anti-virus scanning.

Running Microsoft IIS

Handling Timeouts

Note:This is only needed when using very large QlikView documents that return timeouts.

Proceed as follows to handle timeouts:

Open the %ProgramFiles%\QlikView\Server\QlikViewClients\QlikViewAjax\web.config file in a text editor (for example, Notepad).

Search for the following text:

<httpRuntime requestValidationMode="2.0" />

Edit the text so that it becomes:

<httpRuntime requestValidationMode="2.0" executionTimeout="900"/>

Save the file.

Enabling ASP.NET

If Microsoft IIS is used as web server, enable ASP.NET to ensure proper operation of the QlikView Server sample pages and the extended functions (for example, QlikView Server tunnel).

Optimizing the Performance

To optimize the performance when running Microsoft IIS and AJAX, turn on compression in the web server.

For information on how to configure IIS http compression:

https://docs.microsoft.com/en-us/iis/configuration/system.webServer/httpCompression/

Licensing

The licensing is used to authenticate QlikView Server and allow it to run on a specific machine.

Proceed as follows to enter the license for QlikView Server:

Go to System>Licenses in the QMC.

Select a QlikView Server or Publisher.

Fill in the Serial number and Control fields on the QlikView Server License or QlikView Publisher License tab (depending on whether QlikView Server or Publisher was chosen).

Note:Any previously defined tasks are deleted when the QlikView Publisher license is activated.

QlikView Server/Publisher License tab in QMC

The license is checked every time a document is opened. If the time limit specified by the License Enabler File (LEF) is reached, the QVS automatically enters offline mode, which means that it is reachable from the QMC, but not operational.

The License Enabler File (LEF), lef.txt, for QlikView Server is automatically saved in %ProgramData%\QlikTech.

The PubLef.txt file for QlikView Publisher is saved in %ProgramData%\QlikTech\ManagementService\Publisher LEF.

Click Update License from Server to download a new lef.txt file from the QlikView LEF server. This is primarily used when updating the number of Client Access Licenses (CALs).

If the LEF information cannot be accessed through the Internet, it can be obtained from the local vendor. In that case, copy the entire lef.txt file to the location mentioned above, or paste the LEF data using the corresponding field on the QlikView Server/Publisher License tab in QMC. Contact the local vendor for specific instructions.

Silent Installation

When running a silent installation, QlikView is installed with a limited set of or no dialogs at all. This means all features, properties, and user selections have to be known when creating the silent installation package. There are also some standard properties in Windows Installer Service that may be required.

To prepare a silent installation, the MSI file has to be extracted from the QlikView Setup.exe file.

A silent installation can be run with different interface levels:

/qn Completely silent.

/qb Basic user interface.

Add a + sign at end of the interface levels command to get a modal dialog at the end of the installation saying “Finished” and if it was successful or not.

The following silent installation command lines are recommended for QlikView:

msiexec /i QlikViewServerx64.msi Addlocal="all" IS_NET_API_LOGON_USERNAME="Domain\username" IS_NET_API_LOGON_PASSWORD="password" /qn+

Alternatively:

QlikViewServer_x64Setup.exe /s /v"/qn+ Addlocal="all" IS_NET_API_LOGON_USERNAME="Domain\username" IS_NET_API_LOGON_PASSWORD="password""

The command line above installs all features completely silently with a modal dialog at the end of the installation.

If just a limited set of the features are to be installed, change all to the name of the feature instead. If several features are to be installed, separate them with commas.

The following features can be installed:

DirectoryServiceConnector

ManagementService

QVS

QvsDocs

WebServer

DistributionService

SupportTools

QvsClients with the sub-features Plugin and AjaxZfc

MsIIS with the sub-features QvTunnel and QlikView Settings Service

Note:For the sub-features to be included in the installation, they have to be included in the list of features to be installed.

msiexec /i QlikViewServerx64.msi ADDLOCAL="all" DEFAULTWEBSITE="2" /qn+

This command line installs all features, including the virtual directories to another website than the default one. This requires a machine with Microsoft Internet Information Services (IIS) installed and more than one website on it. The site number also has to be known. Set DEFAULTWEBSITE to the site number where the virtual directories are to be installed. To find the number of the website, check IIS.

The installation procedure can be logged, using the following command:

msiexec /i QlikViewServerx64.msi ADDLOCAL="all" DEFAULTWEBSITE="2"/L*v log.txt /qn+

Settings

The following settings are good to know when designing a silent installation package:

Prerequisites

.NET Framework 4.7.2 or higher

Note:For .NET Framework 4.7.2 to work, Windows 10 must be updated to the Anniversary update Build 1607 or later.

Default installation folder (INSTALLDIR) ProgramFilesFolder\QlikView

Windows Installer Version 3.1 Schema 301

Default language English (United States) 1033

Require Administrative Privileges Yes

INSTALLEVEL 100, all features is set to 101 by default

Features

Silent Installation

There is a hidden feature called “Install”. Do not remove it.

IIS Four virtual directories and an Application pool are installed

Services Five services are installed

Dialogs

The QlikView installation has a number of dialogs, one of which is a Custom Setup dialog and one of which is a Website dialog. All dialogs set important properties. To find the value of a property, do a test installation with verbose logging. Note that the property values may differ depending on the language and operating system used.

Region

This dialog is used for specifying the region.

Property: REGION_LIST

Region dialog

License Agreement

This dialog displays the license agreement for the selected region.

Radio button: AgreeToLicense = "Yes"

License dialog

Customer Information

This dialog is used for entering the customer information.

Properties:

USERNAME

COMPANYNAME

Customer information dialog

Destination Folder

This dialog is used to set the default folder for the installation.

Destination folder dialog

Profiles

This dialog has several properties connected to it, since there are multiple profiles to choose from.

Select Full Installation, Single machine with QlikView Webserver to install everything, including QlikView Web Server, needed to run QlikView on a single machine. To use IIS instead, select Full Installation, Single machine with IIS (this option is only available if IIS is installed on the target machine).

To perform a custom installation, select Custom installation, select profiles and then select the profiles to install. The Webserver profile allows the user to choose between QlikView Web Server and IIS (if IIS is installed on the target machine).

Properties:

PROPQVS: QlikView Server

PROPDS: Publisher

PROPQMC: Management Console

PROPWEB, PROPIIS = 1 or 2: Webserver

PROPIIS (if IIS is installed) or PROPSTATE: Single Machine Install

Profiles dialog

Logon Information

This dialog, which is optional to use, is used to specify the user that is to run the services that are installed. When clicking Next, a Custom Action checks that the entered user is valid. The Custom Action, which is implemented by InstallShield, requires the machine to be part of a Domain to work properly.

Properties:

LOCALSERVICE

IS_NET_API_LOGON_USERNAME

IS_NET_API_LOGON_PASSWORD

Logon information dialog

Service Authentication

This dialog is used to select the type of service authentication. QlikView Administrators Group is selected by default.

Property: PROPCERT (1 = Digital certificates, 2 = QlikView Administrators Group)

Service authentication dialog

Ready to Install

This is the last dialog. Click Install to start the installation.

Ready to install dialog

Additional Dialogs

Custom Setup

This dialog is displayed when clicking Config in the Profiles dialog.

Profiles

Custom setup dialog

Website

This dialog is displayed when selecting IIS as web server in the Profiles dialog.

Profiles

Property: DEFAULTWEBSITE

Website dialog

MST

When creating an MST file, the MSI file is customized without any changes being made directly in the MSI. The MST file works as a filter on top of the MSI and allows changes to be made to the installation. For example, the default installation folder for QlikView Server is %ProgramFiles%\QlikView, but if that is changed to C:\QlikView in the MST file, the default folder is changed. The same thing can be done with the dialogs, which means properties can be preset, so that the installation can be run with a limited set of dialogs.

To create an MST file, an MSI repackaging studio (for example, InstallShield AdminStudio) is needed.

Note:Qlik does not supply any MST files and does not take any responsibility for MST files created by customers or partners.

Source:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Server/Content/QV_Server/QlikView-Server/QVSRM_Installation.htm

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Server/Content/QV_Server/QlikView-Server/QVSRM_InstallationSilent.htm

Read More

Installing QlikView Desktop

When you purchase QlikView, you receive an email with the information about the license agreement. There will also be information about your serial numbers and control numbers.

QlikView Installation Packages

You can select between a number of different QlikView installation packages. The QlikView Desktop, QlikView Server, and QlikView WorkBench installations are only available in a 64-bit version.

The QlikView Desktop installation package includes the following components:

The QlikView application

The QlikView Internet Explorer plugin

QlikView themes

QlikView examples

You can select Custom during the installation progress to reduce the number of installed components.

Downloading the QlikView Desktop installation file

Do the following:

Go to the Qlik website.

In the top right, click Log In. Log in with a registered customer or partner account.

In the main menu, go to Support > Product Downloads & Upgrades.

Click the Get Started button. In the main menu, click QlikView.

Use the left-hand menu to filter your options.

Download the installation files.

Running the QlikView Desktop installation program

Do the following:

Double-click the Setup.exe file to start the installation.

When the installation program starts, select the desired installation language from the drop down list, and click OK.

For a full list of the supported languages, see Supported languages

Wait while the installation is prepared, according to the dialogs displayed.

When the Welcome dialog opens, read the information and click Next.

The software license agreement opens. Read it, and click I accept the license agreement (if this is the case), then click Next.

In the Customer Information dialog you can specify for whom the installation will be personalized. Click Next to continue.

If you prefer another destination folder than the default one for the program installation, specify this by clicking Change in the Destination Folder dialog. Then click Next.

The Setup Type dialog appears. If Complete is chosen, the following features will be installed to the path specified in the previous dialog: The QlikView program, the QlikView Internet Explorer Plug-In, and examples of QlikView functionality and features. If Custom is chosen, a dialog where you can specify which features to install will appear when you click Next. Make the selections and click Next.

The installation is now ready to start. Click Install to start it.

In the last dialog, click Finish to complete the installation process.

Note:Always enter the QlikView license on the account that installed it; otherwise it might not function properly.

Logging the Installation

When Setup.exe is run, a log file is written to the temp folder of the user. The log file is called QlikViewx64.wil. Each time the installation is run a new file is generated, over writing the old log file.

QlikView Settings File

All settings for QlikView are saved in a file (instead of being written to the registry). The file, Settings.ini, is located in C:\Users\username\AppData\Roaming\QlikTech\QlikView.

The settings for QlikView OCX are found in the same file.

Serialization

If you get your QlikView license from a QlikView Server or if you have a Personal Edition of QlikView no serialization is necessary. It is however possible to acquire a serial number for this product and enter it in User Preferences: License page. A registered QlikView will allow you to work offline without any contact with a QlikView Server for longer periods (periods longer than 30 days). Contact your QlikView vendor for details.

Note:The serialization process requires network access or optionally phone activation!

Once you have installed and, optionally, serialized your copy of QlikView, you can start using the program.

Network Distribution of QlikView

This type of installation is useful if you have many licenses and want to make sure that all users run the same version of QlikView. Each user still needs a separate license number.

To distribute a QlikView installation, you need the executable installation file. Serial numbers and control numbers are not necessary until you start your first QlikView session on the client computer.

QlikView uses the Microsoft Windows Installer technique (MSI packaging).

To find out more about how to install an MSI-package, please see Microsoft documentation about Windows installer.

msdn.microsoft.com

License Enabler File Editor

You can also update your license and review the License Enabler File by selecting License Update from the Help menu. This requires no network access.

In the License Enabler File Editor dialog the user can review or edit the License Enabler File.

Current License Key

The Current License Key of the QlikView license that is normally entered when the original program is installed. It may also be entered or edited at a later time via the User Preferences: License page. It is also possible to run QlikView without a bought license key. In this case, a license lease from a QlikView Server - a Named CAL - or a Personal Edition of QlikView is needed.

Current License Enabler File

A text file containing information relevant to the installed license that is required in order to activate (enable) the license key.

Contact License Enabler Server

Click this button if the text edit box Current License Enabler File above is empty in order to contact the License Enabler Server.

Troubleshooting the License Enabler File

A License Enabler File (LEF file) is required in order to verify the validity of a QlikView license key. During the initialization of the license key the Qlik LEF Server is contacted via the Internet. Provided that the license information given checks out, a LEF file is automatically transferred to your computer. Under normal circumstances the LEF procedure is barely noticeable as it is done in the background. There are however instances when the procedure fails, either because you are unable to contact the LEF server or because a firewall prevents the transfer of the LEF file. When this happens the License Failure dialog will be displayed to inform you about the problem.

Should you be unable to obtain a valid LEF file through the normal procedure and you feel that you are entitled to one, you might instead obtain it directly from Qlik Support. When you copy the text file directly into the LEF editor you must make sure that there are no trailing empty spaces in the text.

Source:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Installing%20QlikView.htm

Read More

Create RFC User in SAP

Creating an RFC user can be done in the SAP system with transactions SU01, SU02, SU03. As an example below, we show how to create the necessary user rights for web repository access.

1. Open transaction code SU01, fill in the username and click on create icon.

2. Under Logon Data, choose Communications Data for User Type.

3. Then, go under Profiles tab, look for S_A.SCON profile and save.

Read More

Mengenal Sistem SAP dan Manfaatnya

Saat ini monitoring hingga manajemen aktivitas perusahaan sehari-hari sudah bisa dilakukan secara otomatis dengan menggunakan sistem SAP. SAP atau juga dikenal dengan System Application and Product in Data Processing adalah sistem yang digunakan untuk mendukung kegiatan atau aktivitas yang berjalan dalam suatu organisasi secara otomatis sehingga efisiensi dan produktivitas bisa meningkat secara efisien. Sistem ini terdiri dari bermacam-macam modul yang mempunyai tugas masing-masing sesuai dengan perintah yang diberikan. Semua modul tersebut saling reintegrasi untuk menyajikan data yang akurat dan langsung kepada pengawasnya.

Pengertian Sistem SAP

Sistem SAP atau SAP adalah sebuah perangkat lunak yang berbasis ERP atau Enterprise Resources Planning yang digunakan untuk menjalankan manajemen aktivitas harian dari sebuah organisasi atau perusahaan. Tujuannya jelas, SAP membuat semua aktivitas manajemen, pemantauan, dan pengolahan informasi menjadi jauh lebih efektif dan efisien dari sebelumnya.

Pada awalnya, sistem SAP hanya mampu menangani urusan keuangan perusahaan saja. Namun seiring dengan perkembangan yang didapatkan, SAP saat ini sudah mampu menangani banyak tugas seperti mengontrol penjualan, produksi, manajemen persediaan, hingga manajemen SDM. Tentu semuanya berkat modul yang terus ditingkatkan dan saling reintegrasi sehingga SAP dapat menyajikan informasi yang dibutuhkan oleh perusahaan dalam setiap aktifitasnya.

Sedangkan untuk modul-modul yang reintegrasi dalam sistem SAP sendiri adalah sebagai berikut:

Sales and Distribution (SD)

Modul yang pertama ini berfungsi untuk meningkatkan efisiensi dalam aktivitas yang menyangkut urusan penjualan dan distribusi. Fungsi yang dicangkup antara lain adalah Prospect & Costumer Management, Sales Order Management, Configuration Management, Distribution, Export Control, Shipping and Transportation Management, dan Billing, Invoicing, and Rebate Processing.

Material Management (MM)

Modul ini bertugas untuk memaksimalkan proses pembelian dan juga pengelolaan inventaris perusahaan.

Production Planning (PP)

Modul ini bertugas untuk mengawasi kegiatan rencana produksi perusahaan.

Quality Management (QM)

Dalam rantai logistik, modul ini membantu melakukan pengecekan terhadap kualitas barang hasil produksi.

Plant Maintenance (PM)

Human Resources (HR)

Berfungsi mengintegrasikan semua aktivitas yang berhubungan dengan kebutuhan pegawai seperti aplikasi pendaftaran, administrasi pegawai, manajemen waktu, hingga proses pembayaran gaji setiap bulannya.

Financial Accounting (FICO)

Modul ini meng-cober semua urusan Treasury dan keuangan perusahaan. Semua data keluar masuk keuangan akan dilaporkan secara langsung dan otomatis sehingga kegiatan monitoring menjadi lebih mudah.

Masih ada beberapa modul lain seperti Controlling, Asset Management, hingga Project System yang semuanya sudah reintegrasi.

Lalu apa manfaat yang didapatkan dengan menerapkan sistem SAP?

Manfaat SAP

Ada tiga manfaat dasar yang bisa diperoleh dengan menerapkan SAP sebagai sistem manajemen perusahaan, yaitu:

Meningkatkan kecepatan bisnis perusahaan karena dengan SAP, respons terhadap perubahan pasar bisa dengan cepat diketahui. Hal tersebut sangat penting mengingat setiap keputusan penting membutuhkan data yang akurat sebagai pedomannya.

Meningkatkan konsistensi dari setiap aktivitas bisnis yang berjalan. Sistem SAP dapat memantau apakah SOP sudah dijalankan dengan baik atau belum. Selain itu, SAP dapat mengurangi kesalahan produksi dikarenakan Human Error.

Meningkatkan kualitas bisnis dengan meningkatkan kualitas informasi yang di dapatkan dari pasar. SAP mampu menyajikan informasi secara real-time sehingga keakuratannya tidak diragukan lagi. Di samping itu, SAP juga menyediakan alat analisis yang bisa digunakan untuk membaca data yang didapatkan tersebut.

Read More