Your Testing Environment is Too Big.
It is not uncommon for organizations, over time, to get to the point where they have a production environment with multiple business critical applications that are integrated with one another. It’s also likely that those operational systems feed data into a data warehouse. As the amount of systems and the level of integration increases, so does the environment complexity. That complexity is then reflected in various testing environments.
The complexity impacts numerous things related to the testing environment. One, in particular, relates to the loading of test data. Most would acknowledge that other than for load/performance testing purposes, you don’t really need to have your test environment loaded with the same volume of data that you have in production – you can complete your functional and integration testing using just a subset of the production data.
However, the complexity of an environment can make creating and loading a referentially intact subset of the production data a real challenge. So, most firms just resort to making a complete copy of the database and loading into each environment. That has numerous negative impacts. First, there’s time. Loading a full database versus a fractional subset just takes more time. Second, your environments require more storage and processing power which may unnecessarily increase your budget.
Deploying a robust test data management (TDM) solution is a better alternative.
Semele Data’s TDM toolset enables your team to quickly and cost effectively create a right-sized subset of your full production database. Let the tool do the hard work of managing the referential integrity between the applications. You can create jobs for multiple variations or iterations that can be re-run, on demand, to load data for particular testing needs.
About the author.
Carl’s insights are grounded by a 30 year career in the technology field. Starting as a tester for a large system integrator, he has written software; managed software development teams and led large technology organizations. As a manager and leader Carl enbraces new technology, productivity tools and processes to help teams exceed customer expectations. Carl leads the professional services organization at Semele Data; ensuring that our software is deployed to enable our clients provision the best test data possible while eliminating test data bottlenecks.
You can follow Carl on LinkedIn. www.linkedin.com/in/camiller000