Home     Contact Us     SoftLanding Europe     Deutsch     Español

The Software Management Experts

Extractor for iSeries

Extractor for iSeries dramatically simplifies the process of creating and extracting data subsets from live databases — local or remote — with greater efficiency and full referential integrity. And NO program compilations!

Create multiple subset variations for specific project needs. Reduce data to manageable volumes and enable operation within hardware constraints. Control and amend data during extraction. Data maintenance becomes simple and efficient, and data integrity is assured. Perfect for subsetting data for testing, development, or training; data warehousing; or data archiving.

Database Analysis: Complete, Accurate and Powerful


  • Analyze and replicate your database structure
  • Minimize time to create a test database
  • Maximize integrity and usability of data

Powerful file scanning technology analyzes your live database structure automatically, showing you all join hierarchy and key relationships. Even inconsistent naming standards are manageable through field name and access path search sequences. Extractor automatically creates a highly visual, documented system tree structure for easier maintenance and selection definitions. All definitions are stored so the extraction can be repeated quickly and easily at any time.

  • Automatic file relationship and join hierarchy detection and recording.
  • Tailored search parameters to suit your database and naming standards.
  • Extract and alter data case types for automatic data modification.
  • Archiving capabilities extract data to a target library and delete the original records.
  • Data sampling to set maximum record levels, and sample records at regular intervals — or according to specific field values.
  • Model structure, file joins, and selection data reports enhance understanding and documentation of production database.
  • Tree-structure view of relationships and record numbers for clarity.
  • Multi-relationship file support.
  • Specification of selection or update at run-time.
  • Remote extraction capability option using a remote SQL-driven module.
  • Support for extractions from multiple remote sources.
  • No complex configuration required!

No other iSeries data extraction solution offers this level of functionality and ease of use. Extractor also offers full integration with TestBench for iSeries for complete iSeries software test automation.

Easy Automatic Data Extraction


  • Precise format and content control
  • Structure analysis and extraction reporting
  • Simple, comprehensive data maintenance

Flexible selection enables precise definition of data requirements. Automatic creation of objects in specified library including: data areas, physical and logical files, constraints and triggers. Use features such as inverted structure, record output controls and much more for total extract process management. Referential integrity is assured through intelligent tree structure processing. Maximum flexibility — minimum effort.

  • Simple data selection for any field and data combination.
  • Super SQL Syntax for easier use of SQL statements.
  • Field content interrogation during selection set-up for greater accuracy.
  • Multi-library extractions.
  • Data replace and add to options for flexible data set creation.
  • Interactive, batch or scheduled job extraction.
  • Scan and replace for mass change efficiency.
  • Search and positioning options simplify updates.
  • Project structure and data case documentation for organization and control.
  • Separate Data Case merge for maximum data creation and user flexibility.

Comprehensive Data Model with Maximum Control


  • Remote data extraction capability
  • Data updating, archiving and manipulation
  • Data sampling for quantity and balance control

New data case types enable data to be amended as it is moved to the target file — or deleted from the source file as it is moved. The data sampling facilities allow you to precisely control the quantities and balance of the data you are extracting, to meet your exact business needs. All definitions and changes are stored so the extraction can be repeated, reviewed and audited at any time. Data subsets can be retrieved from remote sources quickly and efficiently using the Extractor Remote module. Database subset management has never been easier.

  • Handles data files, source files and data areas to reproduce the entire database.
  • Automatic logical and join logical file rebuild option.
  • Optional handling of triggers and constraints — reconstructs exact copies of objects so new database is ready for immediate use.
  • Volume and space saving reports.
  • Multi-member file handling.
  • Support of data selections based on field comparisons, substrings, concatenations, or arithmetic operations.
  • Pre-checking of target library for errors before extraction.
  • Time-saving empty object creation option.
  • S/36-style file support and enhanced selection.
  • All iSeries field types supported including: binary, DATE, TIME.
WHAT'S NEW

WHITE PAPERS
"Application Testing Basics: A Practical Guide to Improving Software Quality" by Paul Conte | more
NEW! Conte's "Survival Guide" sequel: "Making the Case for Software Management" | more
Free White Paper: A Unified Approach to iSeries App Testing
| more
Free White Paper: Paul Conte's Software Development Survival Guide | more
Free White Paper: "Meeting Strategic Challenges through Effective Software Testing" | more

ARTICLES

Cargill Simplifies Its Software Application Testing | more