Fortunately, there are a number of tools out there that can help with these challenges. Informatica is probably the industry leader in this area. Informatica took a big step into unstructured data integration with their acquisition of Itemfield last year. However, there are also a number of other vendors who can provide similar or more specialized functionality.
There is no single data warehouse tool that is the right tool in every case, although the Microsoft BI suite is becoming quite common for smaller businesses. The key is to perform the due diligence necessary to understand your business requirements and find the set of tools that will meet your company's individual needs for functionality and growth. Even more important than the tools you select is the program that you establish for data governance and quality.
More on data warehousing
- Listen to the podcast, Data warehousing software update: Bill Inmon makes the case for DW 2.0
- Get expert advice on business intelligence and data warehousing team structure
Dig Deeper on Data warehouse software
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.