Qlik Community

Ask a Question

Data Integration Documents

Data Integration documentation and resources.

Replicating and Transforming Semi-structured Data with Replicate and Compose

benperezg
Employee
Employee

Replicating and Transforming Semi-structured Data with Replicate and Compose

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).

Attachments
Version history
Revision #:
7 of 7
Last update:
‎2021-05-04 07:15 AM
Updated by: