ecobee chooses Flexter to make valuable IoT data in XML accessible to BigQuery users for analytics
The challenge A world leader in smart home devices that introduced the world’s first smart thermostat, ecobee has expanded rapidly in the last decade. Naturally, with company growth has come a surge in the amount of data generated by the company, particularly from their sensor devices – and subsequently, the need for clean data, analytics, ...
Read MoreThe Data Marketplace. A missing piece in modern data architecture
What is a Data Marketplace? Data Marketplaces are a relatively recent phenomenon in data management. They bring together providers and buyers of data. Organisations were able to buy data from third parties in the past. However, Data Marketplaces make it significantly easier to find and buy data. They also cut out the middleman and bring ...
Read MoreSnowflake Data Marketplace: UK Administrative Boundaries
Overview We have published administrative boundary data for the UK on the Snowflake data marketplace. In this blog post we document what you need to know about the data including the data model and sample queries. Reach out to us if you have a requirement for administrative boundaries from other countries. Administrative boundary data covers ...
Read MoreConverting 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 with a feature that enables us to use Oracle CLOB as source data and to convert it. Flexter is available in three editions. An enterprise ...
Read More