Operating in conjunction with its core Convert Product Suite, are these Forecross modernization tools:
Data Evaluator™ allows Forecross to perform automated data analysis early in the migration process, long before the data conversion phase begins. This unique process identifies any data that the target DBMS would consider invalid - such as alpha or special characters in a field defined as numeric or a date field containing values that are out of range (year, month or day) - giving clients a head start in cleaning up their data.
Key benefits of using Data Evaluator include:
Based on a client's specific rules, it identifies data that either the client or DB2 considers to be invalid
It allows the Forecross schema conversion process to accommodate situations where cleansing may not be appropriate
It allows the Forecross data conversion process to automatically cleanse data according to rules established by the client
Data Evaluator, in concert with the Forecross Data Conversion process, guarantees that no data will be left behind when the data is extracted. Which means that clients can go into production confident that all their mission-critical data is present and valid.
DBAdvisor™ is the tool of choice for re-platforming your CA-IDMS/DB database to an SQL environment. It instantly converts IDMS schemas to standard DDL and generates the extract programs and JCL required to perform the data load.
With DBAdvisor, you can quickly and easily verify all of your database redesign assumptions and analyze the data to determine accuracy of content, discover missing or incomplete data, identify data that should be archived, and many other issues that could affect the final database design.
DB Migrator™ combines the power and repeatability of automation with rich customization features to provide two critical components of any IDMS migration - transforming the definition of each IDMS schema into SQL table definitions, and extracting and transforming the IDMS data into SQL relational data.
In schema conversion mode, DB Migrator:
Creates a true relational SQL database design from the IDMS schema - with all primary and foreign keys properly implemented.
Doesn't generate "junction" tables to implement SQL relationships. This results in an architecture that has superior usability and exceptional performance because there is no unnecessary I/O.
In data conversion mode, DB Migrator:
Applies all default data transformation rules and any custom rules that may have been created using the Forecross Data Evaluator product for data analysis and cleansing. (Please see separate Fact Sheet for Data Evaluator).
Generates hash totals on any non-occurring display numeric or packed decimal field - which can be used if desired in conjunction with IDMS or SQL queries to aid in verifying that all IDMS data has been moved to SQL.
Guarantees that no data will be left behind at extract time. Other vendors use a data extraction method that can easily overlook data records under certain conditions. Waiting until production implementation to learn that you've lost critical data is avoided with DB Migrator.