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

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