Convert MISMO XML to Hive and Parquet

Anvesh Gali XML

In this walkthrough, we will convert the MISMO (The Mortgage Industry Standards Maintenance Organization) XML files to Parquet and query in Hive. The XML files are converted to Parquet using the enterprise version of Flexter. The enterprise version provides users with numerous additional features which aren’t available on the free version of Flexter (try for free). In the following steps, ...

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 XML to AWS ATHENA

Anvesh Gali XML

Convert XML to Text. Load to S3. Query with Athena In this walk-through, we will demonstrate the process of loading XML data into Athena – a query engine on AWS. We download the XML files from Clinicaltrials.gov and then convert them into TSV files using Flexter, a powerful XML parser from Sonra. We then load the TSV files into Amazon ...

Converting and Analysing EU Tender data in XML with Flexter and Dataiku DSS

Uli Bethke Dataiku, Flexter, XML

TED: EU tender notices in XML The European Union publishes public procurement contracts across the EU and EEA on a daily basis. The raw data is made available in XML and can be downloaded from the Tenders Electronic Daily FTP servers. In this tutorial we will see how the Flexter XML parser works hand in hand with Dataiku’s data science ...

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 ...