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
02/28/2012 By Leave a Comment
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
01/26/2012 By 1 Comment
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...]
Growing data volumes present problems for data warehouse projects
01/26/2012 By Leave a Comment
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...]
Kimball University: Should You Use An ETL Tool?
01/26/2012 By Leave a Comment
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...]
Why All Content Matters: Getting Started with Unstructured Data
01/26/2012 By Leave a Comment
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...]
Value-Driven Data Warehousing
01/26/2012 By Leave a Comment
“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...]
Data warehousers face many challenges
01/26/2012 By Leave a Comment
A’dam – March, 3th 2008 – With several books on data warehousing to his name, and a business that trains IT staff in the field, Ralph Kimball has been named in some quarters the “father of data warehousing” — though he appears to share that title with another data warehousing pioneer ,Bill Inmon, if a Google search of the two is anything to go by. [Read more...]
The case for a data quality platform
01/26/2012 By Leave a Comment
We have recently been investigating why so many data migration projects (84%) run over time or budget. Over half of the respondents in our survey who had run over budget blamed inadequate scoping (that is, they had not properly or fully profiled their data) and more than two thirds of those that had gone over time put their emphasis in the same place. [Read more...]
SAP to Acquire Business Objects in Friendly Takeover
01/26/2012 By Leave a Comment
SAP AG (NYSE:SAP) and Business Objects S.A. (Nasdaq:BOBJ) (Euronext Paris ISIN code: FR0004026250 – BOB) today announced that the companies have reached an agreement that will bring together two of the information technology industry’s leaders, resulting in an unmatched offering for Business Users, enabling timely and accurate decision-making. [Read more...]
