• No results found

IBM InfoSphere Optim Test Data Management


Academic year: 2021

Share "IBM InfoSphere Optim Test Data Management"


Full text


IBM InfoSphere Optim

Test Data Management


• Create referentially intact, right-sized test databases or data warehouses

• Automate test result comparisons to identify hidden errors and correct defects before deployment

• Protect sensitive data used in testing, training and development

• Shorten iterative testing cycles and accelerate time-to-market

• Manage, access and refresh test data easily through services on demand • Establish and enforce enterprise test data

management policies and rules

How can you speed solution delivery?

Your organization depends on critical applications and business analytic platforms to drive results. But it can be challenging to stay within tight budgets while striving to speed the deployment of new functionality, upgrades and enhancements.

Creating realistic development and testing environments is critical to delivering the right solutions for the business. However, cloning large production databases or data warehouses for development and testing extends cycle times, increases the amount of data propagated across the organization and significantly raises costs.

In addition, cloned data may not support the specific error and boundary conditions required for effective testing. Cloning production systems means manually validating test results. This exercise is often time-consuming and error-prone. With so much test data to manage, time and costs can quickly spiral, maintenance burdens may increase and rolling out new features will require much more of your organization’s time and resources.


2 IBM® InfoSphere® Optim™ Test Data Management offers easy-to-use, proven technology to optimize and automate the test data management process, complete with workflows and services on demand. Development and testing teams can utilize realistic, right-sized test databases or data warehouses, made up of one or more business objects, for targeted test scenarios based on enterprise-wide data governance policies. InfoSphere Optim Test Data Management protects data privacy by applying masking routines to de-identify data, which facilitates testing while keeping sensitive data secure. Also, InfoSphere Optim Test Data Management will compare the data from “before” and “after” testing with speed and accuracy to help testers and developers pinpoint errors or defects.

InfoSphere Optim Test Data Management provides a user-friendly test data management workflow, improving predictability and repeatability of testing efforts. Testers and developers can access and refresh test data on demand that has been masked and provisioned by database administrators (DBAs), and reuse test data artifacts through the test data knowledge base. With InfoSphere Optim Test Data Management, developers and testers can request services, access test data, refresh test data and more via a web interface. For DBAs, InfoSphere Optim offers an intuitive user experience to get projects started more quickly. The solution empowers novice users to contribute immediately.

Finally, InfoSphere Optim promotes data governance by providing organizations with a standard way to define test data management policies and standards throughout the data lifecycle. InfoSphere Optim can create and execute policies, validate compliance with internal and external standards and report on test data management practices.

Create production-like environments

for testing

Test data management is the process of creating targeted, right-sized test environments instead of cloning entire production environments. Development and test environments are then more manageable, which speeds up testing and solution delivery.

In contrast to cloning large production databases or data warehouses, a more effective alternative is to implement test data management capabilities that minimize storage requirements while expanding test coverage. It is much faster to test with smaller, realistic subsets of data that accurately reflect the production environment.

The first step is to understand your complex heterogeneous data landscape. Without this understanding, it is impossible to create the required test data. Some of the challenges include knowing what data is needed for test cases, being aware of where the data is located and how the data is related, and understanding the confidential data elements.


3 By managing data at the business-object level, InfoSphere Optim preserves both the relational integrity of the data an its original business context. Business objects can be pulled from a single database or several related applications and databases. This “federated” extract capability makes it easy t create production-like environments that accurately reflect end-to-end test cases (see Figure 1).

InfoSphere Optim provides a full range of data analysis capabilities to capture hidden correlations and bring them clearly into view. Techniques include single-source and



cross-source data overlap analysis, advanced matching, key discovery, transformation logic discovery and more. The relationships identified during the discovery process are aggregated to create the baseline business object for subsetting. Results of the discovery process can be stored and leveraged for future projects.

Definition of the business object is one part of subsetting. Additional subsetting is done by determining the volume of data that is required to meet the particular type of testing underway. Once your selection criteria are defined, the InfoSphere Optim processing capabilities identify and extract the precise subsets of data and document the policy for future use.

For example, it is easy to populate a test environment with referentially intact customer and order information for a specific business unit or fiscal year. To quickly refresh the test environment, you can reload baseline data on demand. Alternatively, you can extract new records from production to expand test coverage or obtain data for a unique test case. Test data management capabilities delivered through InfoSphere Optim help control the size of development and testing environments. Eliminating excess data volume reduces storage requirements and trims costs. You can create any number of right-sized development, test and training databases to satisfy specific requirements, improving both coverage and accuracy. Streamlined test databases are also easy to manage and maintain, so you can speed iterative testing cycles and shorten the time necessary to deploy new functionality.

Figure 1: InfoSphere Optim helps improve every stage of the application

testing process by providing the data you need.



Protect privacy in development, testing

and training environments

InfoSphere Optim offers a variety of methods for masking test data to protect privacy and support regulatory compliance initiatives. Organizations can leverage context-aware data masking routines to de-identify key data elements across the enterprise. InfoSphere Optim captures and accurately processes data elements so that the masked data does not violate application logic and produces valid results. InfoSphere Optim provides comprehensive data masking techniques, including built-in lookup tables and prepackaged routines that support transforming complex data elements, such as credit card numbers and email addresses. You can also incorporate custom transformation routines based on site-specific requirements.

Force error conditions

Another way to optimize your testing environment is to create targeted test scenarios. InfoSphere Optim includes comprehensive relational editing capabilities that make it easy to compose this special data. It also provides capabilities for browsing and editing data in its relational context across multiple tables, which offers a better way to envision the data relationships. A powerful undo capability helps you reverse an unlimited number of editing changes and a sophisticated audit facility tracks changes and saves details for review by authorized users.

Automate data comparisons

and analyze results

The ability to analyze and validate test results is critical for ensuring application quality. Database size and complexity significantly increase the effort involved in examining test results. After a test run, InfoSphere Optim analyzes

the “before” and “after” images of the data, automatically detecting any differences and presenting the results in a concise report, saving countless hours of manual inspection. InfoSphere Optim enhances all phases of application testing. An intuitive, online interface and full-function browse utility help eliminate time-consuming, error-prone table-by-table comparisons. InfoSphere Optim not only identifies the expected database changes, but also uncovers differences that might otherwise go undetected. Application defects that are hidden or difficult to trace can be identified quickly and resolved at a fraction of the cost.

Streamline test data delivery

As organizations are looking to shorten iterative test cycles and accelerate time-to-market, testers and developers need access to test data on demand. Organizations are embracing agile development, which relies on agile testing. Agile testing requires continuous access to test data in order to run tests and builds, and the ability to run them continuously until the test requirements are satisfied.



Establish and enforce enterprise test data

management policies and rules

Data governance is an organizational priority. InfoSphere Optim provides a standard way to govern the test data management process and validate that policies and standards are honored throughout the lifecycle. InfoSphere Optim enables people, processes and technology to come together to create value.

Support your enterprise environments

InfoSphere Optim provides a central data management solution that scales to meet enterprise needs. In addition to supporting your custom and packaged applications, InfoSphere Optim provides a consistent data lifecycle management approach across leading enterprise resource planning (ERP) and customer relationship management (CRM) applications: Oracle E-Business Suite, PeopleSoft Enterprise, JD Edwards EnterpriseOne, Siebel CRM, Amdocs CRM and SAP applications. Plus, it supports major enterprise databases, data warehouses and operating systems: IBM DB2®, Oracle, Sybase, Microsoft SQL Server, IBM Informix®, IBM IMS™, IBM Virtual Storage Access Method (VSAM), Teradata, IBM Netezza®, Microsoft Windows, UNIX, Linux and IBM z/OS®.

About IBM InfoSphere

IBM InfoSphere Optim is a key part of the InfoSphere portfolio. InfoSphere software is an integrated platform for defining, integrating, protecting and managing trusted information across your systems. The InfoSphere platform provides the foundational building blocks of trusted

information, including data integration, data warehousing, master data management and information governance, all integrated around a core of shared metadata and models. The portfolio is modular, helping you to start anywhere, and then mix and match InfoSphere software building blocks with components from other vendors—or choose to deploy multiple building blocks together for increased acceleration and value. The InfoSphere platform offers an enterprise-class foundation for information-intensive projects, providing the performance, scalability, reliability and acceleration needed to simplify difficult challenges and deliver trusted information to your business faster.

For more information

To learn more about IBM InfoSphere, please contact your IBM sales representative or visit: ibm.com/software/data/


To learn more about the IBM InfoSphere Optim Test Data Management Solution, please contact your IBM sales representative or visit: ibm.com/software/data/optim/



Produced in the United States of America December 2012

IBM, the IBM logo, ibm.com, DB2, IMS, Informix, InfoSphere, Optim and z/OS are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at “Copyright and trademark information” at ibm.com/legal/copytrade.shtml

Netezza is a trademark or registered trademark of IBM International Group B.V., an IBM Company.

Linux is a registered trademark of Linus Torvalds in the United States, other countries or both.

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries or both. UNIX is a registered trademark of The Open Group in the United States and other countries.

This document is current as of the initial date of publication and may be changed by IBM at any time. Not all offerings are available in every country in which IBM operates.



NON-INFRINGEMENT. IBM products are warranted according to the terms and conditions of the agreements under which they are provided. The client is responsible for ensuring compliance with laws and

regulations applicable to it. IBM does not provide legal advice or represent or warrant that its services or products will ensure that the client is in compliance with any law or regulation.

Statements regarding IBM’s future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.

Please Recycle


Related documents

attribute: library attribute: total_reads attribute: type attribute: lane attribute: is_paired_read attribute: study_accession_number attribute: library_id

Atlan et al., “Pulsed acousto-optic imaging in dynamic scattering media with heterodyne parallel speckle detection, ” Optic.. Creath, “Phase-shifting speckle

The innovative interest of the proposed research is in the use of bond graph as a multidisciplinary tool for dynamic modelling of a different electrical equivalent circuit of

On or after a Merger Date or Tender Offer Date (as defined below), the Calculation Agent will either (i) (A) make adjustment(s), if any, to any one or more of the Initial

And we humbly beseech thee, O heavenly Father, so to assist us with thy grace, that we may continue in that holy fellowship, and do all such good works as thou hast prepared for us

• Most of these places offer student discounts on membership fees.. Social life and

In particular, our studies have sought to deal with potential errors in the interpolated climate variables (chapters 2 and 3), the development of a structural Ricardian

In Chapter V, I focus on Liza and share the findings from phase two of this study which addressed the following research questions: In what ways does a teacher construct and enact

Ada 1 doktrin umum dalam ilmu politik bahwa instansi administrasi hanya dipengaruhi oleh kebijakan yang ditentukan oleh pemerintah, namun saat ini diakui bahwa politik dan

The IBM® InfoSphere™ Optim™ Test Data Management Solution offers proven technology to optimize and automate processes that create and manage data in nonproduction (test-

• Mark the corresponding printer icon and delete it (e. Express or PLUS printer) in the Server Properties window (see chapter 9.2, page 18) in order to took over the new

Following these smaller-scale trials in Algem photobioreac- tors, we compared the biomass productivity and lupeol content of Figure 6 mRNA expression of sterol biosynthesis

You should check the generic features on all Bank of England banknotes, such as the feel of the paper and raised print, the metallic thread, and the watermark?. You should also check

This is Thailand's favourite hot sauce, containing her two favourite ingredients: chilli (prig) and shrimp paste (kapee). Here I'm using some of the nam prig from page

Then with introducing the concept of profit model, the paper tries to find out the factors that influence the profit model and explicates two patterns from which the bank

Moreover, the embodied capital of knowledge, politics, history, and creative practice that thrives in much of hip-hop culture can and should influence the embodied, objectified

In general, Islamic banking, by definition of the International Association of Islamic Banks (IAJB), is a banking system which was established to utilize fund in

Bistatic and monostatic RCS patterns for two wind turbine configurations, a horizontal axis three-blade design and a vertical axis helical design, are shown.. The unique

Ana Paula Belon, Laura M. Nieuwendyk, Helen Vallianatos, Candace I.J. PhotoVoice participants from four communities in Alberta, Canada took pictures of barriers and opportunities

The IBM® InfoSphere™ Optim™ Test Data Management solution for Oracle E-Business Suite offers the technology to optimize and automate processes that create and manage data

The IBM® InfoSphere® Optim™ Data Masking solution provides comprehensive capabilities to mask sensitive data effectively across applications, reports and databases in production

The IBM InfoSphere Optim™ Archive solution can help enterprises manage and support data retention policies by archiving historical data and storing that data in its original