Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

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

Replicating and Transforming Semi-structured Data with Replicate and Compose

cancel
Showing results for 
Search instead for 
Did you mean: 
benperezg
Employee
Employee

Replicating and Transforming Semi-structured Data with Replicate and Compose

Attachments

This whitepaper discusses how to convert and consume semi-structured data with the Qlik Data Integration solution.

Today, most on-line transactional processing systems (OLTP) store data in a tabular format of tables and columns. In most cases, data is stored in SQL databases such as Microsoft SQL Server, PostgreSQL, Oracle,Snowflake and others, that support a variety of data types such as character, datetime, numeric, varchar, and more.  Additionally, support for new data types such as Character Large Object (CLOB), Geography (GEO), JavaScript Object Notation (JSON) and Extensible Markup Language (XML) were added as databases evolved.

This whitepaper shows how to replicate and transform semi-structured data with Qlik Replicate and Qlik Compose for Data Warehouses.  The examples covered in this article are based on the semi-structured data format called JavaScript Object Notation (JSON).

Labels (2)
Version history
Last update:
‎2022-02-01 09:08 AM
Updated by: