Convert ESMA XML to Snowflake

Anvesh Gali XML

Introduction to this walkthrough In this walkthrough, we will demonstrate the process of loading XML data into Snowflake – a cloud based data warehousing service. We have downloaded the XML files from ESMA and then converted them into TSV files using Flexter, a powerful XML parser from Sonra. We then load the TSV files into Snowflake and execute queries. XML ...

Convert FpML XML to BigQuery

Anvesh Gali BigQuery, XML

About this walk-through In this walk-through we will load XML files processed by Flexter into BigQuery. Flexter is a powerful XML parsing tool that can convert complex XML files into readable format which can then be loaded into BigQuery which is an enterprise data warehouse available on the Google cloud platform. FpML XML Data We have chosen the XML data ...

Automating XML Conversion with Oracle's ETL Tool ODI

Uli Bethke Big Data, Data Warehouse, Flexter, Oracle Data Integrator (ODI), XML

In the previous posts we demonstrated how Flexter liberates data from complex XML  files (Converting complex XML to CSV and Bulk loading XML files to Oracle with Flexter), we also presented the challenges when using ODI for the same purpose (Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI and Tips for Parsing and Loading complex ...

Parsing XML to Oracle. ODI vs Flexter Enterprise XML Parser

Maciek Kocon Flexter, Oracle, Oracle Data Integrator (ODI), SQL, XML, XSD

In some previous posts we demonstrated how to load XML data into an Oracle database using ODI. We first looked at some of the issues when reverse engineering an XSD in ODI. Next we looked at various issues when parsing and processing XML files in ODI. We also showed that Flexter parses XML files without creating a single data flow ...

Converting complex XML to CSV

Maciek Kocon XML

Have you ever tried to process data in XML? Did you have to load its values into a relational database or simply convert it to plain CSV? Before I show you a simple way of processing complex XMLs, let’s first think out loud what XML actually is used for. Note: If you have a good grasp on XML specifics you ...