Problem solve Get help with specific problems with your technologies, process and projects.

Data warehousing tools for industry-specific data warehouses

Learn the most important things to consider when selecting a data warehousing tool for an industry-specific data warehouse project.

Can you please explain some methods for building a data warehouse for a construction company and specify the data warehousing tools we should use?
Many methods and best practices of data warehousing don't vary across industries. However, companies within particular industries may face many common issues. In the construction industry, we have seen companies challenged to source and combine data from multiple sources, both internal and external to the organization. As well, we often see a need to quantify and report on data from unstructured sources.

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


Dig Deeper on Data warehouse software

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.