Recent Articles

All JSON Snowflake XML
JSON,

CSV vs JSON vs XML – The Best Comparison Guide 2024

We’ve all been there, going from spec to Wikipedia page to another spec to some other article on the topic trying to pick between CSV, XML, and JSON for the…
abbi September 25, 2024
XML,

Convert XML to CSV Like a Pro – Essential Tools & Methods

This blog post talks about everything you need to know to convert XML to CSV. From simple, flat XML to deeply nested XML with many branches we also cover two…
abbi August 13, 2024
XML,

Best Way to Load & Convert XML Data to Oracle Tables

It's very easy to get lost in the Oracle features for working with XML. The following questions come up frequently: What are my options for working with XML in Oracle?…
abbi March 4, 2024
XML,

How to Parse XML Data in SQL Server

The many options available for loading, querying, shredding, and converting XML on SQL Server can often be overwhelming for beginners. SQLXML, XPath, XQuery, OPENXML, FOR XML, OPENROWSET, BULK INSERT are…
abbi January 25, 2024
XML,

The Ultimate Guide to XML Mapping in 2024

XML mapping is a critical process in data integration, ETL, and system interoperability. As an architect, analyst, engineer, or manager involved in XML mapping projects, you're likely familiar with the…
abbi January 11, 2024
XML,

How to Insert XML Data into SQL Table?

You have 3 options for inserting XML data into an SQL table. Schema on read: Import the XML document into an SQL database table without converting the data to a…
abbi December 22, 2023