Recent Articles

XML,

Complete Oracle XSD Guide – Register XSD & Validate XML

In this blog post we cover the most important aspects of working with XML Schema Definitions (XSD) in Oracle. Here is what you can expect from this article. We start…

Maciek August 2, 2024

Snowflake, flexter,

How to Parse & Flatten XML in Snowflake with Examples

In this post we cover every detail of parsing XML in Snowflake including storing, loading, querying, and parsing XML. Very few cloud data platforms have native support for parsing XML.…

Uli Bethke June 3, 2024

XML,

XML Conversion Using Python

XML Conversion Using Python in 2024

XML (eXtensible Markup Language) is a common data format for data exchange and used in various industry data standards such as ISO 20022, HL7, ACORD just to name a few.…

Maciek March 21, 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?…

Maciek March 4, 2024

XML,

9 Critical Types of XML Tools for Developers

Trying to code XML and XSDs by hand is really tedious. It can be easy to mess up, especially with more complex XML based on industry data standards. XML software…

Maciek February 9, 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…

Maciek January 25, 2024