Qlik

Qlik Data Integration

Qlik’s Data Integration Platform accelerates the discovery and availability of analytics-ready data by automating real-time data streaming, refinement, cataloging and publishing. It enables DataOps and drives agility in the analytics process through automated data pipelines (ETL/ELT) that stream from transactional systems, warehouses, or data lakes to create actionable data on-demand.

Features

• Log-based Change Data Capture (CDC) on premise and cloud databases.
• Real time data replication for data offload and reporting.
• Data migration to cloud and between cloud and on premise.
• Hetergenous replication for 40+ sources/targets including SAP and mainframe
• Automated creation of Historical and Operational data stores(ODS).
• Big data ingest for Data Lakes and Data Warehousing.
• Data Integration for real time cloud reporting.
• Automated data loading for Hadoop and Hive.
• Gold Client for SAP Test Data Management
• Data obvisification and masking GDPR compliant.

Benefits

• Easily migrate database to Cloud Infrastructure,
• Enable data warehousing in the Cloud, Redshift, Snowflake, AzureDW,
• Consolidate database to ease data management and reduce costs.
• Data Distribution, deliver data where and when it is needed.
• Single Ingest solution for all systems including SAP and mainframe
• Support Big Data Platforms in the Cloud - S3, ADLS.
• Build a trusted data foundation for Generative AI
• Create real time dev and test instances in the cloud.
• Helps organisations achieve GDPR compliance with data hashing.
• Accelerate delivery of data project with agile code automation.

£6,300 a unit a year

• Education pricing available
• Free trial available

Service documents

• Pricing document

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at nick.ward@qlik.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

200764203337661

Contact

Nick Ward
07557267116
nick.ward@qlik.com

Service scope

• Software add-on or extension: Yes, but can also be used as a standalone service
• What software services is the service an extension to: The Qlik Data Platform can be an add-on service to AWS, Azure and Google Cloud, the software being selected through market place for each vendor. Licensing for AWS can be either through their market place or directly with Qlik , Azure and Google licenses are purchased directly with Qlik.
• Cloud deployment model:
  • Public cloud
  • Private cloud
  • Hybrid cloud
• Service constraints: The Qlik Data Integration platform is available on multiple deployment models. It can be Public, Private or Hybrid and can be deployed across all suitable Public & Private Cloud providers including AWS, Azure, GCP, UK Fast, UKCloud, Oracle, etc., subject to appropriate charging mechanisms being in place for each provider.
• System requirements:
  • Quad Core CPU
  • 8 GB RAM
  • 320 GB Storage
  • Windows Server or Linux
  • 1000MB Network Bandwidth

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: Depending on the severity: Severity P1 within 30 minutes 24x7, Severity P2 within 1 hours within working week, Severity P3 within 4 hours within working week.
• User can manage status and priority of support tickets: Yes
• Online ticketing support accessibility: None or don’t know
• Phone support: Yes
• Phone support availability: 24 hours, 7 days a week
• Web chat support: Web chat
• Web chat support availability: 24 hours, 7 days a week
• Web chat support accessibility standard: WCAG 2.1 AAA
• Web chat accessibility testing: In our effort to make the Qlik support website accessible to visitors with disabilities and optimize the user experience for all site visitors, Qlik has partnered with ADA Site Compliance, a third-party provider of web accessibility testing, remediation, and monitoring services.
• Onsite support: Yes, at extra cost
• Support levels: There are 2 support options available; standard business hours and 24x7 support. Support includes all software upgrades, access to documentation and support desk. Support services include a number of methods for assisting customers including email and remote PC support.
• Support available to third parties: Yes

Onboarding and offboarding

• Getting started: A bespoke training and professional services program is designed to help onboard new customers which includes training and initial consulting services. Training is generally conducted onsite by our UK services team, however at the customer's request and to be flexible we can present training as a live online web session.; Qlik also provides an online Continuous Classroom which provides registered users with training material including "How To" videos for all levels of experience from beginner to advanced.
• Service documentation: Yes
• Documentation formats:
  • HTML
  • PDF
• End-of-contract data extraction: Not applicable.; No data is stored by the solution.
• End-of-contract process: The contract includes term license to use Qlik Data Integration software. ; Support is included for the duration of the term. At the end of the term the customer can renew the agreement or stop using the service. If the service is terminated data will still reside on the customer's platform as no customer data is stored within the solution. However on termination all data replication tasks will stop. Offboarding is an easy process since no data is stored within the Qlik product so the customer simply stops using the software.

Using the service

• Web browser interface: Yes
• Supported browsers:
  • Internet Explorer 11
  • Microsoft Edge
  • Firefox
  • Chrome
• Application to install: Yes
• Compatible operating systems:
  • Linux or Unix
  • Windows
• Designed for use on mobile devices: No
• Service interface: Yes
• User support accessibility: WCAG 2.1 AAA
• Description of service interface: The solution interface is web browser-based. Browsers such as Chrome, Firefox, IE and Edge can be used to access the service interface, as well as provide accessibility features that the user can take advantage of.
• Accessibility standards: None or don’t know
• Description of accessibility: Accessibility of the service will be browser dependant
• Accessibility testing: In our effort to make Qlik products and website accessible to visitors with disabilities and optimize the user experience for all site visitors, Qlik has partnered with ADA Site Compliance, a third-party provider of web accessibility testing, remediation, and monitoring services.
• API: Yes
• What users can and can't do using the API: A REST and .NET API is available for control of the Integration Server via the Qlik Enterprise Management Product. Full documentation can be provided on request.
• API documentation: Yes
• API documentation formats:
  • HTML
  • PDF
• API sandbox or test environment: Yes
• Customisation available: Yes
• Description of customisation: Each installation is configured to the users requirement. Users normally purchase training to become familiar with the product and a few days professional services to help get started. Guidance on best practice is also imparted. Once trained the user interface allows the user to configure and customise tasks as required.; Users can configure source and target data repositories and what selection of data is required to be replicated. Filters can be applied to restrict the data being replicated. A comprehensive range of transformations can be applied to manipulate the data in transit.

Scaling

• Independence of resources: Qlik Data Integration platform is not a shared service and is not affected by the number of users. The solution can be scaled to cater for data volumes being managed by the service

Analytics

• Service usage metrics: Yes
• Metrics types: The user interface provides metrics on throughput of data including, but not limited to: Number of tables and rows replicated, volume data, latency and changes.
• Reporting types:
  • API access
  • Real-time dashboards

Resellers

• Supplier type: Not a reseller

Staff security

• Staff security clearance: Staff screening not performed
• Government security clearance: Up to Security Clearance (SC)

Asset protection

• Knowledge of data storage and processing locations: Yes
• Data storage and processing locations:
  • United Kingdom
  • European Economic Area (EEA)
  • Other locations
• User control over data storage and processing locations: Yes
• Datacentre security standards: Supplier-defined controls
• Penetration testing frequency: At least every 6 months
• Penetration testing approach: Another external penetration testing organisation
• Protecting data at rest: Other
• Other data at rest protection approach: The Qlik Data Integration platform can be deployed on Azure, AWS, Google, UKCloud or other infrastructure. Therefore customers can utilize the security capabilities of their chosen deployment for the protection of data at rest with their chosen environments where the Qlik Data Integration platform is managing data movement and transformations.
• Data sanitisation process: Yes
• Data sanitisation type:
  • Explicit overwriting of storage before reallocation
  • Deleted data can’t be directly accessed
• Equipment disposal approach: In-house destruction process

Data importing and exporting

• Data export approach: While no data is stored in the Qlik Data Integration applications, it is possible to export metadata such as replication tasks and data modelling projects. e.g. to move across environments from (DEV to PROD)
• Data export formats:
  • CSV
  • Other
• Other data export formats: Meta data e.g. log files and product configuration
• Data import formats:
  • CSV
  • Other
• Other data import formats: Meta data e.g. log files and product configuration

Data-in-transit protection

• Data protection between buyer and supplier networks:
  • Private network or public sector network
  • TLS (version 1.2 or above)
• Data protection within supplier network:
  • TLS (version 1.2 or above)
  • Other
• Other protection within supplier network: The Qlik Data Integration platform does not store customer data in the Qlik network. All data is stored within the client's network and infrastructure. This network could include Azure, AWS, Google, UKCloud or other infrastructure. The protection of the network is therefore established by the customer's own protocols and those of the Cloud platform provider of their choice.

Availability and resilience

• Guaranteed availability: Availability is subject to customer's chosen platform. The Qlik Data Integration platform can be installed in a clustered or high availability environment.
• Approach to resilience: The Qlik Data Integration platform can be deployed on Azure, AWS, Google, UKCloud or other infrastructure. Therefore customers can utilize the resilience capabilities of their chosen deployment for their business continuity plans for outages, regional use cases, load-balancing, server instance back-ups, etc.
• Outage reporting: The Qlik Data Integration platform has built-in monitoring and management capabilities for performance, throughput and highlights any issues. Security can be set to view only mode specifically to view this. In addition, alerts can be set to email service issues to relevant recipients. Notifications can be written to the Windows event logs which can be parsed by standard monitoring tools such as HP Openview, MS SCOM, BMC Patrol, etc. In addition, the analytics logs can be viewed in any BI tools of choice, including Qlik Sense.

Identity and authentication

• User authentication needed: Yes
• User authentication:
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google Apps)
  • Limited access network (for example PSN)
  • Dedicated link (for example VPN)
  • Username or password
  • Other
• Other user authentication: User names are defined for individuals and passwords can be specified to meet specific criteria. Qlik Replication Platform can also use LDAP and Active Directory.
• Access restrictions in management interfaces and support channels: Security can be defined in existing Active Directory policies or defined to different security levels within the product on user roles.
• Access restriction testing frequency: At least every 6 months
• Management access authentication: 2-factor authentication

Audit information for users

• Access to user activity audit information: Users have access to real-time audit information
• How long user audit data is stored for: User-defined
• Access to supplier activity audit information: No audit information available
• How long system logs are stored for: User-defined

Standards and certifications

• ISO/IEC 27001 certification: Yes
• Who accredited the ISO/IEC 27001: The Standards Institute of Israel
• ISO/IEC 27001 accreditation date: 20/10/2020
• What the ISO/IEC 27001 doesn’t cover: The service is completely covered by the certification
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: No
• Cyber essentials plus: No
• Other security certifications: Yes
• Any other security certifications:
  • AICPA SSAE18 SOC2 Type II
  • AICPA SSAE18 SOC 3

Security governance

• Named board-level person responsible for service security: Yes
• Security governance certified: Yes
• Security governance standards: ISO/IEC 27001
• Information security policies and processes: The Qlik Data Integration platform can be deployed on Azure, AWS, Google, UKCloud or other infrastructure within a hardened environment. Therefore customers can utilize the security capabilities of their chosen deployment for their own policies and processes. The Qlik Data Integration platform does support user authentication and allows for governed access permissions within the products.

Operational security

• Configuration and change management standard: Supplier-defined controls
• Configuration and change management approach: The Qlik Data Integration platform can be deployed on Azure, AWS, Google, UKCloud or other infrastructure. Therefore customers can utilize the change management capabilities of their chosen deployment for their change management processes, etc. The Qlik Data Integration platform does offer auditing capabilities that can be integrated into 3rd party systems to monitor for potential security impacts.
• Vulnerability management type: Supplier-defined controls
• Vulnerability management approach: The Qlik Data Integration platform can be deployed on Azure, AWS, Google, UKCloud or other infrastructure. Therefore customers can utilize the vulnerability management capabilities of their chosen deployment for the threat and patch management of their own environments. The Qlik Data Integration platform currently has an annual four release cadence for product improvements and new capabilities, etc. In addition, patch releases can also be used to address any potential major security vulnerabilities that may occur and if found to impact Qlik's product capabilities.
• Protective monitoring type: Supplier-defined controls
• Protective monitoring approach: Qlik contracts a 3rd party, MSSP, as a SOC as a Service provider. They provide us with ongoing monitoring and analysing of security alerts. Penetration testing is carried out on new releases using industry standard test tools.
• Incident management type: Supplier-defined controls
• Incident management approach: The Qlik Data Integration platform can be deployed on Azure, AWS, Google, UKCloud or other infrastructure. Therefore customers can utilize the incident management capabilities of their chosen deployment for incident reporting of their own environments. The Qlik Data Integration platform supports various performance and error reporting and logging capabilities along with APIs which can be utilised as a part of the customer's incident management processes.

Secure development

• Approach to secure software development best practice: Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v3.0)

Public sector networks

• Connection to public sector networks: Yes
• Connected networks:
  • Public Services Network (PSN)
  • Police National Network (PNN)
  • NHS Network (N3)
  • Joint Academic Network (JANET)
  • Scottish Wide Area Network (SWAN)
  • Health and Social Care Network (HSCN)

Social Value

• Social Value:

  Social Value

  • Fighting climate change
  • Covid-19 recovery
  • Tackling economic inequality
  • Equal opportunity
  • Wellbeing

  Fighting climate change

  As a technology company, we have specific responsibilities to our stakeholders to engage in good business practices. As people, we have personal responsibilities to others and our planet. Because we want all of our actions and interactions to impact society in a positive way, we adopted and continually measure our progress against the triple bottom line model. It’s the best way to ensure we’re doing all we can to drive tangible economic, social, and environmental value across our global community.

  Covid-19 recovery

  As a technology company, we have specific responsibilities to our stakeholders to engage in good business practices. As people, we have personal responsibilities to others and our planet. Because we want all of our actions and interactions to impact society in a positive way, we adopted and continually measure our progress against the triple bottom line model. It’s the best way to ensure we’re doing all we can to drive tangible economic, social, and environmental value across our global community.

  Tackling economic inequality

  As a technology company, we have specific responsibilities to our stakeholders to engage in good business practices. As people, we have personal responsibilities to others and our planet. Because we want all of our actions and interactions to impact society in a positive way, we adopted and continually measure our progress against the triple bottom line model. It’s the best way to ensure we’re doing all we can to drive tangible economic, social, and environmental value across our global community.

  Equal opportunity

  As a technology company, we have specific responsibilities to our stakeholders to engage in good business practices. As people, we have personal responsibilities to others and our planet. Because we want all of our actions and interactions to impact society in a positive way, we adopted and continually measure our progress against the triple bottom line model. It’s the best way to ensure we’re doing all we can to drive tangible economic, social, and environmental value across our global community.

  Wellbeing

  As a technology company, we have specific responsibilities to our stakeholders to engage in good business practices. As people, we have personal responsibilities to others and our planet. Because we want all of our actions and interactions to impact society in a positive way, we adopted and continually measure our progress against the triple bottom line model. It’s the best way to ensure we’re doing all we can to drive tangible economic, social, and environmental value across our global community.

Pricing

• Price: £6,300 a unit a year
• Discount for educational organisations: Yes
• Free trial available: Yes
• Description of free trial: Explore Qlik Replicate features:; ; GUI that automates data ingestion and replication; High performance, real-time updates enabled by world-class CDC; Broad support for many enterprise data source and target platforms; Centralized monitoring and control with scheduling, notifications, and alerts; Replicating database changes to another database; Streaming database changes to Apache Kafka
• Link to free trial: https://www.qlik.com/us/trial/replicate

Service documents

• Pricing document

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at nick.ward@qlik.com. Tell them what format you need. It will help if you say what assistive technology you use.