Kevin Kline : ETL

Simplifying CSV Data Loads

KKline — Thu, 27 Oct 2011 17:55:00 GMT

Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database. When it comes to loading CSV data into the database, many options exist, however, few make it...(read more)

ETL Demo With Data from Data.Gov

KKline — Fri, 05 Aug 2011 21:45:00 GMT

The idea of ETL leveraging semantic abstraction is quite intriguing and it me a good excuse to use data from data.gov to build a quick demo....(read more)

Is There Such a Thing as Easy ETL?

KKline — Thu, 30 Jun 2011 04:57:00 GMT

As soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard. I've found a cool, free tool - expressor studio - that shields your data integration application, with its associated business and transformation rules, from changes that might occur to underlying target or source files....(read more)