Major Update of the ETL Tools & Data Integration Survey

In the last week of September 2012, Passionned’s ETL Tools & Data Integration Survey has been updated to reflect the latest versions of the major ETL tools in the market. Two ETL products were added to the survey and four ETL tools have been updated to show their new functions and features. In the list of ETL tools you will find a list of all the ETL tools included in the survey, including both commercial and open source ETL tools. [Read more...]

Oracle Announces Availability of Oracle Exalytics In-Memory Machine

Oracle today announced the availability of Oracle Exalytics In-Memory Machine, the industry’s first high-speed engineered system featuring in-memory business intelligence (BI) software and hardware to deliver extreme performance for analytic and performance management applications. [Read more...]

Bikes (SQL) can’t ever beat cars (ETL tools) – Data Vault discussion

Question: Which ETL tools can support Data Vault modeling out-of-the-box? What are the challenges and issues building a data vault with ETL tools? [Read more...]

Why All Content Matters: Getting Started with Unstructured Data

After users become familiar with your BI project’s benefits, they’ll likely want more. Be prepared to provide analysis of unstructured data. We’ll show you how to begin. [Read more...]

Kimball University: Should You Use An ETL Tool?

You can still hand-code an extract, transform and load system, but in most cases the self-documentation, structured development path and extensibility of an ETL tool is well worth the cost. Here’s a close look at the pros and cons of buying rather than building.

By Joy Mundy

The Extract, Transformation, and Load (ETL) system is the most time-consuming and expensive part of building a data warehouse and delivering business intelligence to your user community. [Read more...]

Growing data volumes present problems for data warehouse projects

Many companies are seeing very significant increases in data volumes and these are having an impact on their data warehouse programmes, according to the latest survey from PMP Research. The research has been commissioned by the Evaluation Centre (www.evaluationcentre.com). [Read more...]

Value-Driven Data Warehousing

“I am tired of IT people. They’ll talk to you for half an hour about what they do, but by the time they’re finished, you still don’t have any idea what they’ve told you or why it’s important,” so complained a friend of mine in a recent conversation. [Read more...]

How To Mine All That Customer Data

A’dam – September, 22th 2007 – The seeming simplicity of a term like “business intelligence” belies the rich potential its implementation can provide to a small or midsize company. Data mining is the backbone of BI–it means sorting through company data and identifying and extracting valuable information about operations. [Read more...]

Oracle buys Sunopsis to fight Informatica

Oracle (Nasdaq: ORCL) today announced plans to enhance its Oracle Fusion Middleware offerings through the acquisition of Sunopsis, a leading provider of heterogeneous data integration products. [Read more...]

Open Source ETL

Some 18 months ago I wrote an article called “the case for open source ETL“. At that time I had identified four products (one of which, Kettle, has since been acquired by Pentaho) in the open source data integration market. [Read more...]