Why is concurrency overrated to measure performance of data warehouse platforms?

Uli Bethke Redshift

The difference between making a good and a bad decisions often comes down to the quality of the pre-defined metrics. If the metric is poor so will be the decision. When comparing performance between different technologies such as Google Big Query (based on a distributed file system - Colossus to be precise) and MPP technologies such as Redshift, people tend ...

Using Apache Airflow to build reusable ETL on AWS Redshift

Dorian Beganovic Apache

Building a data pipeline on Apache Airflow to populate AWS Redshift In this post we will introduce you to the most popular workflow management tool - Apache Airflow. Using Python as our programming language we will utilize Airflow to develop re-usable and parameterizable ETL processes that ingest data from S3 into Redshift and perform an upsert from a source table ...

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

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

[Video] Converting MedlinePlus XML to QlikView

Uli Bethke XML, XSD

In this video we will show you how easy it is to convert MedlinePlus XML to QlikView with Flexter's powerful XML Converter. The XML conversion goes through the following sequence of steps Upload XML files to Flexter Convert the XML to text files (Tab Separated Values, TSV) Import the text file to QlikView Analyze the Data If you have any ...