Qlik Sense Enterprise on Windows deployed to Oracle Cloud
In an Oracle Cloud deployment, you install Qlik Sense Enterprise on Oracle Cloud Infrastructure (OCI) which is flexible, high performance, and quick to set up.
Deploying Qlik Sense Enterprise on Oracle will enable you to quickly add new applications in a simple and scalable manner. You can do this with a basic knowledge of Oracle security and scalability options but without the need to follow complex on-premise installation and configuration procedures. Using Oracle will enable you to get your Qlik Sense infrastructure up and running in fraction of the time required for an on-premise deployment, and will enable you to scale your deployment quickly and easily, regardless of unexpected changes in demand.
You can only deploy Qlik Sense to Oracle Cloud manually at this time.
Benefits of using OCI
- A quick and effective way of deploying Qlik Sense to the cloud.
- Simple and cost-effective, reducing overall deployment times.
- Quick and easy to deploy Qlik Sense applications.
- Scalable, elastic storage that can be expanded and contracted on demand.
-
Oracle security and networking functionality.
- Geographic deployment to multiple regions around the world makes lower latency possible.
- A reliable and high performance platform which is autoscalable.
-
Oracle Autonomous DB in the same cloud.
Components
To successfully deploy Qlik Sense on OCI you need a basic understanding of the architecture and services available in an OCI deployment. As part of a Qlik Sense deployment on OCI , you need the following components:
-
Oracle Compute instances
-
Oracle Virtual Cloud Network (VCN)
OCI services
You should also have a basic understanding of other OCI services that you can use for managing resources and as data stores for your Qlik Sense applications:
-
OCI IAM Policies
-
Virtual Cloud Networks (VCN)
-
OCI block volumes
-
OCI Compute
-
Bastion
For more information about OCI services, see Oracle Cloud Infrastructure Documentation.
Microsoft Windows versions
Your OCI instance needs to be running a Microsoft operating system onto which you can install a Qlik Sense instance. Qlik Sense supports the following Windows operating systems for an OCI deployment:
- Microsoft Windows Server 2016
- Microsoft Windows Server 2019
- Microsoft Windows Server 2022
Qlik Sense Enterprise
Install a single-node Qlik Sense server on your OCI instance.
Qlik Sense Enterprise configuration:
Use the QMC to configure the following:
Licensing
- Tokens (only token-based license)
- User access (token-based license) or Professional access (user-based license)
- CPU cores
- Security groups
Create a proxy setup for allowing HTTP access.
Other considerations
When you deploy Qlik Sense to OCI for the first time you should also consider the following.
Security
Use the OCI IAM to configure OCI users and IAM policies and the QMC to configure all security groups and authentication settings in Qlik Sense.
For more information about security, see:
Connectivity
Qlik Sense applications can use the following Oracle web services as data stores:
-
Oracle Autonomous DB
-
Oracle Base Database Service (Standard and Enterprise Edition)
-
MySQL Database Service
-
Essbase
-
Oracle Exadata Database Service
In an OCI deployment you can use the following connectivity mechanisms to connect to different data sources:
- ODBC connection
- OLE DB connection
- REST API connection
- Native connector to a specific source
Connectivity scenarios:
- Qlik Sense instance that uses Oracle Database instances specified above.
- Hybrid Qlik Sense instance - uses data stored in Oracle data sources as well as data stored on premise.
For more information about connectivity, see Connecting to data sources.
Scalability
As environments grow in terms of number of users, number and size of applications, and number of data sources it is important to understand how to size the environment correctly and how to scale the environment accordingly. You need to create a multi-node environment to effectively scale up or down, by creating dedicated servers for different purposes. You can then allocate resources correctly across the following Qlik Sense services.
- Engine Service – The QIX engine, provides in-memory Associative Data Indexing and calculation supporting analysis
- Proxy Service – Manages authentication, handles user sessions and load balancing
- Repository Service –Manages Qlik Sense applications, controls access, and handles configuration
- Scheduling Service – Manages reloads of Qlik Sense applications and other scheduled tasks
- Service Dispatcher – Launch and manage the data profiling service for the data load model
For more information about scalability, see the Qlik Sense Performance Benchmark technical brief.