Extractor Professional database analysis and data extraction.

Extractor for iSeries or Oracle dramatically simplifies the process of creating and extracting data subsets from your live database – with great efficiency, 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. Extract data from remote sources. Data maintenance becomes simple and efficient. Data integrity – for any purpose – is assured:

• Training
• Testing
• Data Warehousing
• Archiving Development

Database analysis

Powerful file scanning technology analyzes your live database structure to create ‘join hierarchy’ and key relationships automatically. Even inconsistent naming standards are manageable. Extractor automatically creates a highly visible, documented system tree structure - for easier maintenance and selection definitions. All definitions are stored so the extraction can be repeated at any time.

• Database structure analysis and replication
• Precise format and content control
• Remote data extraction capability
• Data sampling, updating and archiving
• Full data quantity, content and balance control
• Simple – but comprehensive - data maintenance
• Structure analysis and extraction reporting
• Maximize integrity and usability of data
• Minimize time to create a test database

Automatic data extraction

Flexible selection enables precise definition of data requirement. Automatic creation of objects in specified library - including: data areas, physical & logical files, constraints and triggers. 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.

Maximum data 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 control the quantities and balance of the data you are extracting precisely, to meet your exact business needs. All definitions and changes are stored so the data extraction can be repeated, reviewed & audited at any time. Data subsets can be retrieved from remote sources quickly and efficiently using the Extractor Remote module.

A specially designed corporate Compliance Edition of Extractor is available, which also includes data scrambling!

Back to Top^