Loading and querying XML documents in the Oracle Database

In Oracle databases, you have two methods for handling XML data: Schema on Read and Schema on Write. Schema on Read allows direct storage of XML in a table without…
Uli Bethke March 4, 2024

Converting XML documents from an Oracle CLOB to a relational format

In this post we will show you how easy it is to convert XML data from Oracle CLOB to a relational format. We will be using Enterprise Flexter which ships…
Uli Bethke August 31, 2020

Converting and Masking Zendesk JSON to a database (Oracle)

For this post we will mask and convert Zendesk JSON data to Oracle. We will use Sonra’s obfuscation tool Paranoid (open source) and Sonra’s data warehouse automation tool for XML,…
Uli Bethke September 17, 2019

Masking and converting Guidewire XML to a database (Oracle)

In this post we will guide you through the process of masking Guidewire XML data and converting it to Oracle. This process normally take days or weeks. With our solution…
Uli Bethke August 8, 2019

Oracle SQL Developer Data Modeler with Snowflake

Why Oracle SQL Data Modeler Oracle Sql Developer Data Modeler (SDDM) is a free-to-use data modeling tool born to support developers while designing their database, or architecture, at a logical,…
Federico Sicilia November 28, 2018

Converting and analysing Rugby JSON data to Oracle Data Visualization Desktop

Here is another post that will show how you can work with the output from Flexter to analyse your data. In this post we will show you how to convert…
Uli Bethke May 22, 2018
spinner