Having data warehouse problems
and failures?
• Your ETL (Extract, Transform and Load) process fails to achieve a complete
loading
• You get incorrect data transformations due to defects in system
mappings
• Your ETL doesn't properly correct, reject or substitute invalid
data
• Your systems is slow or crashes because your business intelligence
tool doesn't scale as users expect
• Your business intelligence tool's customized features do not comply with
the specification
You Need a Data Warehouse Quality Program. We can help you.
|
Which Data Warehouse Quality Program is
right for you? |
| |
DIY (or Do
it Yourself) |
End-to-End |
Custom |
You Need...
|
a tool to handle data verification but already have
dedicated staff to data warehouse testing |
help developing, strategizing or implementing data warehouse
testing and don't have tools or expert staff. |
a lot more help than you thought.
|
Description
|
Doing it yourself is the way to go
if you have strategies and experts in place. QuerySurge™ is
designed to streamline and simplify your data verification
process. |
Experts join your team
on a
consulting basis and work with your team to achieve all your
data warehouse testing needs.
|
Your needs can't be packaged up and
you need something more.
|
Includes
|
QuerySurge™ license
Additional services (e.g. mentoring & implemen-tation) may be
added on an a-la-carte basis.
|
• QuerySurge™ usage
• Tool Implementation
• Mentoring
• Data Verification
• Regression Testing
• Performance/Scalability
• Testing & Automation |
Customized for you.
|
Contact us for more information and pricing >
RTTS' Strategy: Data Verification,
Regression and Scalability
• Bulk compare data with RTTS'
QuerySurge™ Data Warehouse testing tool - a Java based tool for volume
data testing
• Bulk compare data between
the Data Warehouse, the Datamart(s), the staging databases and the data
sources
• Automate Regression testing
of the Business Intelligence tool
• Automate Performance/Scalability
testing of the Business Intelligence tool
Data Verification with QuerySurge™
• Automate bulk data comparisons
with RTTS' QuerySurge™ Data Warehouse testing framework to validate
data at every point in the ETL process.
• QuerySurge™ reporting feature
gives you both high-level and granular reports on testing for your organization's
different reporting needs
• QuerySurge™ licensing is
available at all levels for purchase or rental, along with training,
mentoring and implementation services.
Regression Strategy
Automate testing of reports in
the Business Intelligence tool using an industry-standard test automation
tool.
Performance/Scalability Strategy
• Characterize each subsystem's response under load.
• The Business Intelligence
tool is the initial focus because it is user-facing.
• Performance may be an issue
at the Datamart(s), the Data Warehouse or any other data source component.
|
