Converting XML to Hive

Chinmay Sinha XML

In this example we will use the Flexter XML converter to generate a Hive schema and parse an XML file into a Hive database. We will then use the spark-sql interface to query the generated tables. TVAnytime XML standard For the example we will use TVAnytime XML standard. You can download sample XML files and an XSD for this standard ...

Convert Oracle XMLTYPE to Oracle tables

Chinmay Sinha Oracle, XML

In this example we will read XML data from a table with an XMLTYPE column in the Oracle database and convert the XML to tables in the same Oracle database. We will use Flexter to extract the data to and from the same database in this example. We need to give Flexter table and column name that contains the XML ...

Convert XML with Spark to Parquet

Chinmay Sinha Spark, XML

It can be very easy to use Spark to convert XML to Parquet and then query and analyse the output data. As I have outlined in a previous post, XML processing can be painful especially when you need to convert large volumes of complex XML files. Apache Spark has various features that make it a perfect fit for processing XML ...

Convert FpML XML to Oracle Data Modeler with Enterprise Flexter

Uli Bethke Flexter, XML

Today we will show you how easy it is to convert FpML XML files to relational tables in an Oracle database with the enterprise version of Flexter. We then reverse engineer the DDL into Oracle Data Modeler and visualise the target schema. FpML XML Data FpML ( Financial Products Markup Language) is an XML message standard for the OTC Derivates ...

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.

Can you help us liberate the data?

Vadim Mytarev Flexter, XML, XSD

Can you help us liberate data from awkward data formats by filling out a short survey? At Sonra we have already automated the conversion of XML and JSON to a database, text, or Hadoop. We are now looking for the next data format to liberate. Have you come across a data format that gives you the heebie jeebies? Yes? Then ...