Geo and location analytics in action with OpenStreetMap and census data In this blog post we integrate and analyse OpenStreetMap, Census, and Geo Data from Ireland. We will use Flexter to convert the data to a Snowflake database. Flexter is a data warehouse automation solution for XML, JSON, CSV, and relational databases. It converts these data sets to CSV, ORC, ...
Flexter, our data warehouse automation solution for the conversion of XML, JSON, industry data standards (HL7, FpML, ISO 20022 etc.) automatically creates Target Schema when we create a Data Flow. It allows us to see relational representation of our XML or JSON documents. In this post we show you how easy it is to create a Target Schema from an ...
Optimisation algorithms for converting XML and JSON to a relational format. Part 1 - Elevate Flexter, our data warehouse automation solution for the conversion of XML, JSON, industry data standards (HL7, FpML, ISO 20022 etc.) ships with two optimisation algorithms. The purpose of these algorithms is to simplify the relational target schema that Flexter auto-generates. In this blog post we ...
Don't miss the Data for Breakfast event at The Davenport Hotel on 24th of March. Solve your most frustrating Data challenges with expert advice. This is a free event so invite everyone who would benefit from this event. DISCOVER THE POWER OF A CLOUD DATA PLATFORM To stay competitive in today’s world, organisations must remove the barriers that prevent them ...
In this post we will convert the TransXChange XML standard to a relational format on MariaDB. We will query the output with SQL to show the bus schedule (pick up and drop down routes and times). We will use the relational database management system Maria DB and Sonra’s data warehouse automation tool for XML, JSON, and industry data standards Flexter ...
