https://community.qlik.com/t5/Official-Support-Articles/Replicating-and-Transforming-Semi-structured-Data-with-Replicate/ta-p/1737881 <P>This whitepaper discusses how to convert and consume semi-structured data with the Qlik Data Integration solution.</P> <P>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&nbsp;SQL databases such as Microsoft SQL Server, PostgreSQL, Oracle,Snowflake and others, that support a variety of data types such as&nbsp;character, datetime, numeric, varchar, and more.&nbsp; Additionally, support for new data types such as Character Large Object (CLOB), Geography&nbsp;(GEO), JavaScript Object Notation (JSON) and Extensible Markup Language (XML) were added as databases evolved.</P> <P>This whitepaper shows how to replicate and transform semi-structured data with Qlik Replicate and Qlik Compose for Data Warehouses.&nbsp; The examples covered in this article are based on the semi-structured data format called JavaScript Object Notation (JSON).</P> Tue, 01 Feb 2022 14:08:20 GMT benperezg 2022-02-01T14:08:20Z https://community.qlik.com/t5/Official-Support-Articles/Replicating-and-Transforming-Semi-structured-Data-with-Replicate/ta-p/1737881 <P>This whitepaper discusses how to convert and consume semi-structured data with the Qlik Data Integration solution.</P> <P>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&nbsp;SQL databases such as Microsoft SQL Server, PostgreSQL, Oracle,Snowflake and others, that support a variety of data types such as&nbsp;character, datetime, numeric, varchar, and more.&nbsp; Additionally, support for new data types such as Character Large Object (CLOB), Geography&nbsp;(GEO), JavaScript Object Notation (JSON) and Extensible Markup Language (XML) were added as databases evolved.</P> <P>This whitepaper shows how to replicate and transform semi-structured data with Qlik Replicate and Qlik Compose for Data Warehouses.&nbsp; The examples covered in this article are based on the semi-structured data format called JavaScript Object Notation (JSON).</P> Tue, 01 Feb 2022 14:08:20 GMT https://community.qlik.com/t5/Official-Support-Articles/Replicating-and-Transforming-Semi-structured-Data-with-Replicate/ta-p/1737881 benperezg 2022-02-01T14:08:20Z