Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Data warehouse/BI performance testing tool recommendations

Expert selects preferred performance testing tools for data warehouse/BI software testing needs.

What testing tool would you recommend for performance testing in a Data Warehouse/BI space?

For each of the data warehouse and business intelligence implementations that I've been involved in were finalized in a similar fashion. The load testing for the data warehouses, databases, ETLs, etc, have been done using simple monitoring tools and some script code for seeding data, test setup, and execution. I've not seen many large commercial tools used in that space, unless it was a database or network monitoring tool that the company already had. Performance testing the data warehouse is typically fairly straightforward. It has more to do with the data than it does the tools you're using.

For the business intelligence side of the project, running canned reports, ad hoc reporting, multi-user load, is where you tend to find some of the more traditional performance testing tools come into play. This testing tends to look similar to other performance testing efforts. The big tool vendors HP, IBM, Microsoft and the like, all have a place based on the technologies your business intelligence solution leverages. Open source tools like JMeter and OpenSTA, can also be used for some aspects of the testing depending on complexity and/or technology constraints.

I've found with business intelligence testing, that the data still has a lot to do with your scenarios. So while you're likely adding an element of load, you're still likely going to be doing a lot of data staging/seeding. Any tool that is compatible with your business intelligence interface is likely to do the trick for you.

This was last published in October 2009

Dig Deeper on Stress, Load and Software Performance Testing

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchMicroservices

TheServerSide.com

SearchCloudApplications

SearchAWS

SearchBusinessAnalytics

SearchFinancialApplications

SearchHealthIT

DevOpsAgenda

Close