The cost of maintaining AS/400 systems for cold storage is exorbitant. Infinite can migrate legacy data to AWS, Azure and Google Cloud in less than four weeks at a cost dramatically less than maintaining the obsolete AS/400 hosting rarely accessed information.
The conversation is performed automatically by the Infinite Toolset. It reads the external definition of each physical file, creates a corresponding table in Oracle or MS SQL, and directly populates the table. The toolset manages all procedurals and administration.
The legacy data in AWS, Azure and Google Cloud cold storage maintains the same file and record names. Reporting can be done via queries or more sophisticated database tools. A standard data analytics tool like Tableau will let you to easily produce meaningful information from historic data.
Infinite i is a secure direct repopulation of data within the same system. The operation does not depend upon on mapping via scripts or transferring data across networks. Each file, field and record are identical from source to target, only the format changes. The system confirms successful completion of each table. Should an error occur, the system will generate an error message, the entire table will be deleted from the target database, and the operation will be repeated. Once moved to the target, it is stored in a standard Oracle or MS SQL database with all the protections those systems provide.
With the Infinite Database Migration Tool for DB2/400, the tool simply takes a complete SAVF from the AS/400 physical and logical files, recompiles them into their new target platform and writes the data to Oracle in one complete set. This automatically translates EBCDIC data to ASCII and automatically creates tables and views from the original physical and logical files. This is a one-time complete data migration process. Once migrated, you can easily move data to and from workstations or PCs for data manipulation and analysis because it is all in either Oracle or MS SQL.
For decades, Infinite Corporation has provided enterprise-wide data access across disparate hardware platforms. With Infinite's proven migration and integration technology, your AS/400 data can now easily be migrated to an open database environment. The benefits mean that data can be shared in real-time with other Oracle or MS SQL-based applications, BI tools, and data management requirements.
Configuration
• The Infinite Database Migration Tool for DB2/400 automatically creates schema in Oracle or MS SQL server.
• Target is a standard Oracle or MS SQL database.
Access Capabilities
• Read/write access to the former AS/400 database.
• Distributed access through Oracle or MS SQL, including multisite queries, subqueries, joins, and views.
• Distributed transactions protected by Oracle's or Microsoft’s two-phase commit protocol.
• Data transfer between the AS/400 and Oracle or MS SQL, performed in a single statement.
Data Types
• Automatic repopulation from AS/400 to Oracle or MS SQL.
• All Oracle or MS SQL data types supported, including CHAR, NUMBER, and DATE.
• All AS/400 data types supported, including packed and zoned decimal.
Database Administration Facilities
• Complete site autonomy.
• Normal database administration procedures per corporate policies.
• No need to duplicate AS/400 data definitions in Oracle or MS SQL.
SQL Language
• Uses ANSI/ISO standard SQL.
• Provides Oracle or MS SQLdata dictionary views of foreign data.
• Supports most Oracle or MS SQL Data Manipulation Language (DML) SQL extensions.
• Oracle or MS SQL stored procedures and packages.