Qlik Community

Technology Partners Ecosystem Documents

Documents & videos related to the Qlik Technology Partners Ecosystem

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

Getting Started with Google Cloud Platform

cancel
Showing results for 
Search instead for 
Did you mean: 
MichaelRobertshaw

Getting Started with Google Cloud Platform

Google Cloud Platform

The Google Cloud Platform (GCP) contains many components and capabilities that are directly relevant to a deployment of Qlik software. This non-exhaustive list catalogs some of the commonly used services. More detail can be found at https://cloud.google.com/products/

Relational Datasources

These may be accessed using the corresponding ODBC driver that may be downloaded from Google, or often using one of the drivers in the Qlik ODBC Connector package that is embedded in Qlik Sense.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Introd...

Infrastructure

  • Storage
    • Persistent Disk – durable and high performance block storage (SSD & HDD) that may be attached to instances of Google Compute Engine (Virtual Machines) or Google Kubernetes Engine (Containers)
      https://cloud.google.com/persistent-disk/
    • Cloud Filestore – a managed Network Attached Storage (NAS) solution that supports NFS client connectivity (basically Linux only)
      https://cloud.google.com/filestore/
    • Cloud Storage (GCS) – Object storage with global edge-caching. May be used for CLOB artifacts such as extractions from BigQuery but not suitable as a fileserver.
      https://cloud.google.com/storage/
  • Compute
    • Compute Engine (GCE) – Virtual Machines running in Google data centers. This is the simplest step towards Cloud whereby you no longer manage Hardware, but you do still have to maintain (patch) the Operating System and manage all applications on the host. QlikView and Qlik Sense Enterprise for Windows require Compute Engines.
      https://cloud.google.com/compute/
    • Kubernetes Engine (GKE) – Containerized Application Management. Containers are a step beyond Compute Engines, in which you no longer maintain the [typically Linux] Operating System, but only configure how many Containers your Application runs in. Qlik Sense Enterprise for Elastic runs in Kubernetes-managed Containers.
      https://cloud.google.com/kubernetes-engine
  • Network

Additional Products

Many additional Google Cloud capabilities may also be used in relation to Qlik but are not directly discussed in this document. Much more can be seen at https://cloud.google.com/products/

GCP-Qlik Dependency Matrix

 

Qlikview Server (QvS)

Qlik Sense Enterprise
for Windows (QSEfW)

Qlik Sense Enterprise
for Elastic (QSEfE)

Network

Virtual Private Cloud and Connectivity

Google Virtual Network.pngVirtual Network


Google Interconnect.pngInterconnect or VPN

Presentation
or Web Tier

Load Distribution and Content Delivery

Google Load Balancer.pngLoad Balancer

Google Compute Engine.pngCompute Engine

Google Load Balancer.pngLoad Balancer

Google Compute Engine.pngCompute Engine

Google Load Balancer.pngLoad Balancer

 

Kubernetes_(container_engine).pngKubernetes

 

Google Container.pngContainer

Application
or Engine Tier

Associative Engine
and Document Reloads

Google Compute Engine.pngCompute Engine

Google Compute Engine.pngCompute Engine

Persistence

Application Data shared amongst clustered components

Google Compute Engine.pngCompute Engine

Google Persistent Disk.pngPersistent Disk

 

Google Compute Engine.pngCompute Engine


Google Persistent Disk.pngPersistent Disk

 

Google Cloud SQL.pngCloud SQL (Postgres)

Google FileStore.pngFileStore

mongoDB.png

Datasources

 

Google BigQuery.pngBigQuery

And many other datasources

 

Further detail can be found in additional Qlik Community documents:

Several core and underlying infrastructure decisions need to be made and deployed before beginning the Qlik implementation, particularly the Network Tier where the Virtual Private Cloud is organized (address ranges chosen, connectivity with any on-premise datacenter established).

Connectivity between Qlik components, to Datasources and interaction with the Persistence Tier is highly dependent on how the customer has configured their Cloud Network (use of Public or only VPC-internal addresses, requirement for Proxy components, Firewall rules).

Is the Presentation or Web Tier going to be made publicly accessible via the Load Balancers using Public IP Addresses, or is access to the solution available only from the on-premise network and via additional end-user VPN Connectivity?

The customer must also give serious consideration to Identity and Access Management. How will users authenticate when accessing the Qlik solution? Does this require replication of Active Directory into a cloud component, or is there already a SAML Identity Provider that can be integrated with Qlik? Many other possibilities are also viable.

Readers are strongly advised to seek guidance from both Qlik Consulting and their account-specific GCP team to research options that are applicable within their specific IT & Security constraints.  Some customers are commencing their transition to Cloud and making decisions that could have long-lasting implications or are negatively disruptive to adjust later.

The Design that is chosen may vary from the guidance in this document and should be clearly documented and agreed by all parties BEFORE commencing implementation.

Labels (1)
Comments
pauljohansson
Creator III
Creator III

Hej,

Are there any guidelines for GCE settings to optimize QlikSense performance?

Any pointers are appreciated,

thanks in advance,

br

Paul

0 Likes
MichaelRobertshaw

Nothing dramatic that directly affects performance ... bigger is not always better. Certainly Qlik products are RAM intensive, but also try to use SSD disk for the Persistence Tier, and several machines with few vCPUs generally outperform one large machine. 

obo
Employee
Employee

Hi Michael

Just to mention about Cloud SQL for PostgreSQL and Qlik Sense; currently there is a problem using version 9.6 where does not work using this Cloud SQL solution and Qlik Sense, only working version is Postgres11.x and Qlik Sense Nov 2019 so far.

 

pauljohansson
Creator III
Creator III

Hej,

Is there any example where QlikSense connect to Cloud DataStore ?

Thanks in advance

br

Paul

0 Likes
MichaelRobertshaw

We haven't looked into querying Cloud DataStore (or FireStore) from Qlik Sense, but it may be feasible using the REST Connector and guidance from Google (though not trivial, and will certainly require Scripting). 

It may be simpler to create a node.js webservice that exposes your Cloud DataStore/FireStore collections to Qlik in a simpler tabular format that can be more easily consumed via the Web Connector. 

Google recommend that you use Cloud DataStore or Spanner for OLTP but periodically import that data into BigQuery for easier interaction from the Business Intelligence tier. 

0 Likes
pauljohansson
Creator III
Creator III

Thanks for quick reply Michael,

Regards

Paul

0 Likes
Version history
Last update:
‎2019-01-16 08:44 AM
Updated by: