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...]
Microsoft to buy data-warehouse appliance vendor
01/26/2012 By Leave a Comment
By Elizabeth Montalbano , IDG News Service , 07/24/2008
Microsoft continues its shopping spree to bolster its SQL Server database platform to make it more suitable for large-scale enterprise deployments. On Thursday the company said it plans to buy DATAllegro, a privately held maker of data-warehouse appliances. [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...]
When Right-Time Isn’t Real-Time Enough
01/26/2012 By Leave a Comment
When is right-time not real-time enough? That, as it happens, is the million-dollar question. Business intelligence (BI) and performance management (PM) vendors have made an awful lot of noise about a “new generation” of “real-time”, “near-real-time”, or “decisioning” tools, touting everything from their ability to provide “actionable business insight” to other intangible (and usually unspecified) competitive advantages. [Read more...]
Open Source ETL
01/26/2012 By Leave a Comment
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...]
