Data Migration

The Infinite I Database Migration Tool for DB2 for IBM I (DB2/400) enables you to completely migrate IBM I, iSeries, and AS/400 data to your Oracle or MS SQL environment. This tool is part of a comprehensive suite of solutions designed to migrate and integrate heterogeneous applications and data stores.

Integrated Access

Access to up-to-date, complete information is critical to making informed business decisions. But accessing that information can be difficult, particularly if your data is scattered among different systems, stored in different formats, and seemingly impossible to merge.

Infinite I Database Migration Tool’s technology meets the challenge of migrating and integrating IBM I, iSeries, and AS/400 data sets. Once migrated all data resides in Oracle or MS SQL. You now have the power to fully integrate all your data to create true enterprise information systems. You can streamline operations, analyze data in real-time, and minimize data redundancy and inconsistency.

Open Up Your IBM i Environment

With the Infinite Database Migration Tool for DB2/400, Oracle or MS SQL users on any supported Oracle or MS SQL database platform have read and write access to all data previously residing under the IBM I, iSeries, and AS/400 . The Infinite i Database Migration Tool for DB2/400 provides transparent access, making IBM I, iSeries, and AS/400 data part of an Oracle or MS SQL database. In fact, end users may actually be unaware that the data ever resided on an iSeries machine. With the Infinite Database Migration Tool for DB2/400, your iSeries data is now part of an open system.

Levels of Transparency

The Infinite I Database Migration Tool for DB2/400 provides many levels of transparency, including:
• Geographic transparency - Users do not need to know the physical location of data, just the names of the tables to be accessed.
• Network transparency - Users can access the data regardless of the network protocols.
• Operating system transparency - Users do not need to know the operating systems on which the data resides.
• Data storage transparency - Uses can access data regardless of the methodology used for data storage.
• Data access transparency - Applications can access foreign data stores using the same feature-rich language.

These levels of transparency dramatically expand your ability to access and analyze data. For example, in a single request you can integrate sales information from Oracle on AIX and inventory information from Oracle on z/OS with customer information from a migrated AS/400 database without having to know where each piece of information is located or how it is stored. Such transparent data access protects your company's investment in data and applications, while extending your data management power.

Flexible Cloud Computing Architecture

The Infinite Database Migration Tool for DB2/400 makes CloudComputing Architecture a reality. You can select the most cost-effective platform to serve as the client, using tools and applications from Oracle Corporation and Microsoft to access AS/400 data. End users can enjoy access to the AS/400 data from Linux, Microsoft Windows, or even z/OS and OS/390.

Immediate Information Access

Unlike other database migration products that require extensive programming and customizing, the Infinite Database Migration Tool for DB2/400 is a complete, ready-to-use solution, with no programming necessary. From the first day, you can migrate all your AS/400 data to Oracle or MS SQL and use Oracle's or Microsoft’s tools, or any of the many third-party products available for Oracle or MS SQL, to access information in your former AS/400 database because it will actually bean Oracle or MS SQL Database. If your requirements change, Once migrated, Oracle and Microsoft technology makes it easy to relocate your data without changing your application programs.

Sophisticated Services

The Infinite Database Migration Tool for DB2/400, together with the Oracle or MS SQLdatabase, gives you a sophisticated set of services because all your data resides in a single local Oracle or MS SQL database. These services include SQL statement parsing for distribution, database link processing, two-phase commit processing, data dictionary support for Oracle and Microsoft tools, and data type conversions. The Oracle Database Gateway for DB2/400 and Oracle also provide distributed capabilities, including multisite queries, subqueries, joins, and views, all with a single SQL statement.

A Powerful Language

The Infinite Database Migration Tool for DB2/400 is tightly integrated with the Oracle and MS SQL databases. This allows Oracle's powerful SQL and MS SQL to be used against the AS/400 data. You need not learn a new API, SQL language, or AS/400-specific SQL. It allows you to fully leverage your Oracle or MS SQL knowledge today, and exploit Oracle or MS SQL language enhancements in the future.

Superior Connectivity

Connectivity to the AS/400 is provided by Infinite Services with support for TCP/IP. Whether you need to migrate the data from your iSeries to Linux, Windows or a mainframe running z/OS or OS/390, the Infinite Database Migration Tool for DB2/400 delivers true distributed relational database access to the AS/400 data.

Complete Security

Unauthorized access to AS/400 data is protected through a combination of Oracle and MS SQL security mechanisms.

Complete and Easy Data Migration

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 from the to 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.

KEY FEATURES

Configuration

• The Infinite Database Migration Tool for DB2/400 resides on the Oracle or MS SQL server.
• Number of users limited only by underlying operating system and the 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 mapping 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.
• Access control on a per-user basis.
• 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.