Why Migrate to Qlik Sense?

By Raihan Rubin, Thu 27 July 2017, in category Business intelligence

QlikSense, QlikView

  
@

Overview

Many people and organisations are considering moving their existing QlikView applications into Qlik's more modern product offering, Qlik Sense. This post aims to provide some information about the benefits of converting, as well as outline a strategy for migration.

Why Migrate?

How to Migrate

I would suggest first doing some test migrations of existing dashboards to a test environment. There are a few ways to do this conversion, as detailed in the points further below. Ideally, existing QlikView dashboards would run alongside newly built Qlik Sense dashboards and quality checks would be performed between the two to make sure the data model, measures, and objects are returning the same results as before. These quality checks can either be performed manually, or with some form of data governance software. When doing a test migration, it may be beneficial to take a subset of your applications (maybe with reduced data).

You should look to migrate all existing applications including those that perform your ETL processes. There are some QlikView features that Qlik Sense does not have, and so some scripting may have to be performed to rectify any issues or alternative solutions put in place.

Possible migration methods include:

The two methods mentioned above only copy over the load script from QVW files and none of the front end. This can be somewhat achieved with the third method below.

Set up and Architecture

Qlik Sense's server setup mimics that of QlikView's, where a central server (or cluster of servers) stores and serves a collection of Qlik Sense apps to requesting web and mobile clients. The minimum specification that a Qlik Sense server requires is a Windows server with a 1gb HHD, 8gb RAM and multi-core x64 compatible processors.

Another option is Qlik Cloud. This is where Qlik host your Qlik Sense apps on their servers. There are three pricing models involved with Qlik Cloud:

img

Qlik Cloud business is an ideal way to go – providing an agile solution that has all the features of a Qlik Sense Enterprise server. One thing to note with Qlik Cloud is that there are app size limits at each level that increase with the level. On Qlik Sense Enterprise server there are no such limits.

Quilliup

Quilliup is a data governance application that allows you to connect both QlikView, Qlik Sense, and your underlying source systems (both RDBMS and Hadoop), and compare both data and components in an automated fashion. Testing criteria and alerting can be configured to help you have a safe, well managed migration.

Benefits of validating your migration using software such as Quilliup include:

Our Approach

Our recommended approach to migrating from QlikView to Qlik Sense is the following:

Keyrus are offering migration services around Qlik Sense training, license acquisition, and QlikView dashboard migrations. If any of these may be of interest, don't hesitate to get in touch.