Informix to Teradata, United States

Customer

A leading integrated energy company, featuring among the top 20 companies on the Fortune Global 500 list. The company is a globally renowned leader in crude oil, natural gas, and alternative energy production with business activities and numerous retail outlets worldwide.

Challenge

The customer was looking for a solution to improve internal business process management and data administration by moving their business-critical Informix database to Teradata. The capabilities of the target platform were expected to meet the needs of the corporation. At that moment, it was a new type of migration for Ispirer, which was not supported at a good level in our toolkit. Therefore, the challenge of this project was to add a new migration direction to the toolkit and ensure a high level of automated migration. This very project included tables and data conversion.

Solution

To evaluate the volume of data in Informix that needed to be converted to Teradata, the customer used a free Ispirer Migration Assessment Wizard. This tool is able of collecting statistical information about the source database.

During the Extension Stage, the Ispirer developers successfully added the Informix to Teradata migration direction to the toolkit and tailored it for the customer’s migration needs. The company was provided with the Ispirer software, meeting all the requirements for the targeted Teradata database. Having purchased a license for Ispirer Tooolkit, the customer utilized our migration tool to automatically migrate data and tables to Teradata.

As a result, the source Informix database with around 100 GB, contained in 1,000 tables was entirely moved to Teradata.

Benefits Derived from Conversion

The outdated Informix database was automatically migrated, and minor manual changes were made to the code. Database migration with Ispirer software was very fast, and the cost of this solution was much less than the alternatives.