Advantages of Moving Data from ADABAS toÂ DB2
A broad view of organizational data is vital for management reporting, business intelligence, analytics and decisionÂ support. But what happens when critical data from important lines of business is locked up in a legacy system, technicallyÂ incompatible with modern data management solutions? Â Dealing with non-relational databases has long been theÂ domain of specialist DBAs. Now itâ€™s impacting the business,Â preventing a full view of the organizational data necessary toÂ make decisions.
Old Data vs. Big Data
Database modernization efforts worldwide are being driven by Business Intelligence (BI) reporting and the processes thatÂ support it. BI systems integrate data across the enterprise, equipping corporate decision makers with the informationÂ they need to maintain and improve business performance, successfully scale as their businesses grow, and identifyÂ and implement new business initiatives and strategies. BI has been a key driver of as companies are moving quickly to leverage data warehousing capabilities for competitive advantage.
However, the more obvious, quantifiable reason for moving from ADABAS to DB2Â is cost. Â Software AG has chosen to maximize the revenueÂ coming in for ADABASÂ Â while it stillÂ can. Â Most ADABASÂ customers areÂ large enterprises, so each customerÂ could pay a lot more than a typicalÂ Open Systems customer. Prices forÂ ADABAS haveÂ quickly jumped into the hundredsÂ of thousands US dollars. Â This short term revenue strategy hasÂ been effective. In January 2014,Â Software AG reported a record levelÂ of license sales in the final quarter,Â with Group license revenue climbingÂ 22 percent. However, the numberÂ of ADABAS installations has steadilyÂ declined, and revenue predictionsÂ for the same group in 2015 are 9 toÂ 16% lower.
Â Modern Systems Solution for Migrating from ADABAS toÂ DB2
The Modern Systems ADABASÂ conversion strategy includes the generation of a new relational database to replace the functionality, multiple-occurring fields and groups, and other data element structures that are currently part of the ADABASÂ inverted list database. The new target database can reside on the mainframe or off the mainframe, and can use any of the standard relational database management systems (RDBMS): Microsoft SQL Server, Oracle or IBM DB2.
Modern Systems also handles the conversion of the applications that use the ADABASÂ files. We can convert Natural, COBOL, Assembler, Easytrieve, JCL and Procs for ADABAS applications.
Replacement of Adabas Database Functionality
The Modern Systems solution provides a complete replacement for all ADABASÂ database functionality including MU and PE management, ISN usage, super descriptors, sub descriptors and more. The resulting database is fully relational. Primary keys and index definitions are automatically created. All constraints are generated into the resulting DDL. Table spaces, indexes, table names and column names are all generated according to your naming standards.
ADABAS to DB2Â Data Conversion
The Adabas data extract and relational load process is simple, straightforward and fast. Modern Systems can provide a number of extract variations for sites that have special requirements for a short Adabas data conversion window. Special workbenches within DB-ShuttleÂ® provide additional capabilities for tailoring your Adabas migration so that the new database meets your needs and requirements.
Special workbenches within DB-Shuttleâ„¢ provide additional capabilities for tailoring your Adabas migration so that it better meets your needs and requirements:
- Re-name Workbenches to allow full naming of all tables, columns, table spaces and indexes using a rules basis or a full-name basis
- Data Cleansing Workbench to provide rule-based data cleansing during the Adabas data extract process
- Date Conversion Workbench to allow the specification of the format of Adabas date fields along with the individual Adabas date field minimum and maximum values so that the DATE type specification can be used in relational databases (all date formats are supported)
- Element Rename Workbench which allows selection of group level or elementary Adabas fields for use as columns in the relational database
- Record Re-Definition Workbench to allow changes to field types and lengths during the relational conversion
Migration Isn’t Your Only Choice
Modern Systems also has an ADABAS rehost solution that allows end users to continue interacting with the legacy system through familiar screens while processing against a new relational database. Natural developers continue to maintain and enhance the application through an improved interface. The Modern SystemsÂ Application Transparency Platform is an alternative solution to ADABASÂ conversion.
This isÂ the lowest-risk and fastest way to escape expensive Adabas license fees without disrupting users, developers or support resources. Â The Natural syntax from your existing applications is moved to Windows and executes in the Windows environment as a rich client. Â Natural source code resides as data in a SQL Server database and can be accessed, changed, debugged and executed using a workbench designed specifically for Natural developers. Â The rehostingÂ engine reads the Natural syntax as data and interprets the processing at a byte level to produce results that are identical to Natural that executes in the mainframe environment. Â All Adabas databases are converted to SQL Server, Oracle or DB2, and eachÂ resulting relational database will have the same functionality and traversal capabilities as the current Adabas database. Â We offer two options for rehosting Natural applications:
- Mainframe: migrate your Adabas data to DB2 for z/OS and re-host/re-platform the Natural applications in the rehostingÂ environment (example below)
- Off Mainframe: migrate your Adabas data to the Database Server of your choice (DB2, SQL Server or Oracle) and re-host/re-platform the Natural applications in theÂ rehostingÂ environment
ThisÂ solution brings with it a full development platform, enabling application documentation, debugging, dual run-mode execution, version control, and enhanced features beyond the original programming language environment. Â No Software AG licenses are required for processing the Natural syntax. No Software AG licenses are required for processing of the new relational databases (SQL Server, Oracle or DB2), nor for the execution of the COBOL or C#/Java batch programs that are converted to process against the new database.
Given the complexity of moving from one data tier to another, it’s important to choose the right partner. Â With over 20 years experience, Modern Systems is the right choice for ADABAS to DB2Â data migration.