 |
 |
 |
 |
 |
 |
 |
|
This is the 13th installment in a continuing series of articles featuring tRelational and Data Propagation System (DPS), Treehouse Software’s ADABAS-to-RDBMS product implementation, in several “real world” environments. tRelational/DPS is a robust product set that provides modeling and data migration of legacy ADABAS data into new RDBMS-based platforms. The modeling and mapping facility (tRelational) auto-generates complete RDBMS schemata from existing ADABAS files and allows for easy mapping of ADABAS fields to already existing data warehouse or ERP schemata. After the mapping is completed, DPS can materialize (initially load) and propagate (subsequently keep synchronized) the ADABAS data into the RDBMS without requiring direct access to ADABAS.
Whether a site is completely replacing a legacy ADABAS system with an RDBMS-based system as was done at Grede Foundries (now Grede Holdings LLC), or if the need is a long-term data transfer and synchronization solution for data warehousing/Internet/Intranet/ERP applications, tRelational/DPS is the answer. This article illustrates how Treehouse Software’s tRelational/DPS product set and expert consultants helped Grede Foundries migrate its mainframe data to it’s new home—on time and under budget. Grede Foundries chose the Treehouse products for migration of their legacy ADABAS data as part of their plan to move from the mainframe by the end of June, 2010. About Grede Foundries (Now Grede Holdings LLC) Grede is a full-service manufacturer and supplier of innovative metal components to the transportation and industrial markets. Headquartered in Novi, Michigan, with sales and technical support throughout the United States and Europe, Grede delivers quality products to a global customer base. Additionally, Grede’s customers look to the company to manage logistics, packaging, and freight to ensure their products arrive on schedule. This requires leveraging global purchases, and working with suppliers to ensure they're meeting Grede’s quality and delivery expectations. A Time For Change… Until recently, Grede had relied on their mainframe database and file environment, which was running ADABAS v7.4.4 and NATURAL v3.1.5. The mainframe applications were to be retired, and the data had to be stored in a queryable format for archival purposes. The target RDBMS for data storage was SQL Server 2008 running on Windows Server 2008 64-bit. Treehouse Was The Logical Choice Treehouse had been a long-time provider of remote and on-site DBA services for Grede Foundries, and years ago, Grede was one of the very first tRelational/DPS users. When the decision was made to retire their mainframe system, the Grede team contacted Treehouse and asked if it was possible to migrate all of their ADABAS data in a very tight time frame. The migration plan needed to address the volume of files and records that had to be migrated in an extremely short period of time. The Grede mainframe was scheduled to be shut down for the final time the evening of June 30th. This meant that only 3 ½ weeks were available from the start of the project to migrate 108 ADABAS files containing 63.7 million records. Additionally, 25 files were in use on June 29th, and 5 of those files were still in use the morning of June 30th. This meant that the final conversion of 25 files, containing 24.5 million records, had to be migrated from ADABAS to SQL Server during a 24-hour window. The migration of the Grede's data was delivered by TSI consultants in four phases:
In the end, the Grede team was very pleased that the migration went so smoothly and the new system was up and running on time, with no problems. Treehouse Software is Ready to Help with Your ADABAS-to-RDBMS Project Treehouse Software’s tRelational/DPS product set has been the trusted best-of-breed ADABAS data migration solution by hundreds of customers since the mid-1990's, and is a proven solution for moving ADABAS data to relational databases, either for coexistence with, or full migration to new systems. DPS and tRelational Literature and Presentations:Download other TSI product documentation sets and Powerpoint presentations.
Contact Treehouse Software Today!To receive more information about DPS, or to request a free 30-day trial, contact Treehouse Software or your Treehouse affiliate. TSI is looking for reference sites for the DPS software. If you are interested in becoming a DPS reference site in exchange for special pricing and other considerations, contact TSI today! TREEHOUSE
SOFTWARE, INC.
What's
New | Products |
Services | About Us | Newsletter | Management | Partners | Support Copyright © 2012 Treehouse Software, Inc. |
DPS
FactSheet (English)
tRelational/DPS
Presentation