BACKGROUND: Ilmarinen is one of the leading pension insurance companies in Finland, with a one-third share of the market.

PLATFORMS: Intel/Windows NT and IBM OS/390 servers.

PROBLEM SOLVED: Ilmarinen needed to create referentially intact subsets of relational test data across heterogeneous hardware and software environments for testing its enterprise applications. Application unit testing is performed on NT client workstations using Oracle on NT servers, while integration and system testing is performed on NT client workstations using DB2 for UDB on OS/390 servers. In addition, the databases were very complex, the relational data was fragmented and there were subtle relationships that were not defined to the database. Prior to using Princeton Softech's Move for Servers, Ilmarinen was manually creating test data using in-house programs that were difficult to use, too simplistic and could only be used by the DBA.

PRODUCT FUNCTIONALITY: Princeton Softech's Move for Servers extracts complete, relationally intact subsets of DB2 and Oracle data that Ilmarinen uses for cross-platform testing. Ilmarinen's programmers transform and migrate production quality, referentially intact data from Oracle to Oracle, Oracle to DB2, DB2 to DB2 and DB2 to Oracle. Move for Servers supports Oracle, DB2 Universal Database, DB2 Universal Database for OS/390, Sybase, SQL Server and Informix. In the future, Ilmarinen will be using Move for Servers to migrate data between SQL Server, Oracle and DB2. As we add additional databases to our environment, we will use Move for Servers to transform and migrate data between disparate DBMSs.

STRENGTHS: With Move for Servers, we have far more functionality than with our in-house programs, and the developers do not need to depend on the DBA to transform and migrate the data. Move for Servers is a powerful and stable tool to create test data. The product saves us an enormous amount of time and is very flexible. We can maintain reference test data after testing in the extract file; and if additional test cases need to be run, it is quite easy to refresh the data. Plus, when we need to extract data from multiple databases, we use Move for Servers to define the relationships between the databases. We are much more confident in the test data that we generate with Move for Servers. We would never have been able to develop such a comprehensive program in house.

WEAKNESSES: There is no support in Release 1.0 of the product when changing the version of the database: however, this capability has been added to the product's Configuration Program with Release 2.0, which became generally available on November 1, 1999.

SELECTION CRITERIA: Princeton Softech is the only vendor whose products guarantee referentially intact extracts from an arbitrarily complex data model with no limit on the number of tables or relationships across heterogeneous database environments. Princeton Softech's Move for Servers even understands application and database managed relationships and accounts for them during the extract process.

DELIVERABLES: Princeton Softech's Move for Servers enables Ilmarinen to subset Oracle and DB2 databases in preparation for creating realistic test data that can be used across diverse environments. Ilmarinen can now use test databases that are more representative of the production environment. In addition, Ilmarinen has been able to eliminate its complex, in-house data extraction utilities and has been able to decrease the number of test databases, resulting in better performance and tremendous time savings in checking the results. Ilmarinen's application testing is more consistent, and testers can verify the test results at each phase of the testing process now that Ilmarinen has the ability to use the same test cases in all three testing environments.

VENDOR SUPPORT: Princeton Softech's support was very responsive, and we look forward to the new Web-based support services in Release 2.0, which include the ability to upgrade software via the Internet. In addition, Princeton Softech's Global Network offers FAQs and other Web-based support services 24x7.

DOCUMENTATION: We found it difficult to configure the product using the existing documentation, but this documentation has undergone significant revisions for Release 2.0. The bottom line is that the product is good and we are very happy to have it.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access