Displaying items by tag: sql

The United States Customs and Border Protection agency contracted with The Software Revolution, Inc. (TSRI) for a Phase 1 assessment as well as a conversion and modernization of the Customs and Border Protection (CBP) Cargo ACS/Quota (QUOTA) Conversion Pilot code from COBOL/CICS to Java or .Net.

Customer: US Customs and Border Protection

Source & Target Language: COBOL/CICS & JCL to Java

Lines of Code: 163,700

Duration:  4 Months

Services:  Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Internal and External Dependancy Analysis, Transformation Blueprint®Application "As-Is" Blueprint®, Target Architecture Design

 

 

Published in Case-Studies
Wednesday, 30 March 2022 13:43

PL/1 & JCL to C# - KMD e-Boks

Originally developed by Denmark-based KMD in 2001 as a mainframe software application, the e-Boks system became more difficult and costly to maintain over time. The original platform also lacked the agility to expand to additional countries at scale and was not agile enough to expeditiously react to business changes. TSRI and KMD were able to modernize the e-Boks application from its original IBM PL/1 legacy code in a monolithic architecture to a modern, multi-tier application in a modern computing environment, running .NET, with no impact on the business and end-user experience. As a result, e-Boks has the potential to save more than 50-60 percent per year in operations and maintenance costs.

Customer: KMD and The Government of Denmark

Source & Target Language: PL/1 & JCL to C#

Lines of Code: 974,201 (781,893 - PL/1 and 192,308 - JCL)

Duration:  6 Months

Services: Transformation Blueprint®, Automated Code Transformation, Automated Refactoring, Integration and Testing Support

 

 

Published in Case-Studies
Wednesday, 30 March 2022 13:43

COBOL & JCL to Java & Python - Deutsche Bank KM

Deutsche Bank's relatively reliable mainframe infrastructure utilized COBOL and JCL languages running DB2 and VSAM flat-file databases for a variety of their key financial applications. The company’s leadership knew they would need to be cloud-enabled with a modern architecture to stay relevant for its customers and ongoing market needs. Following a successful proof of concept against other well-known industry soluitons, TSRI emerged as the best solution (highest quality output and most advanced architecture) for the full modernization effort of Deutsche Bank’s internal KreditManager application. An application which gives the company’s employees all of the tools they need to handle all of the company’s loan, credit and mortgage applications.

Customer: Deutsche Bank

Source & Target Language: COBOL & JCL to Java & Python

Lines of Code: 397,222 (383,358 - COBOL, 13,864 - JCL)

Duration:  12 Months

Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation Blueprint®, Application "As-Is" Blueprint®

 

 

Published in Case-Studies

This case study documents technologies, processes, and methods of the timely and 100% automated conversion of a portion of the VHA (Veterans Health Administration) Information Systems and Technology Architecture (VistA) system, written in 2.1 million lines of MUMPS. The modernized module resulted in object-oriented and highly maintainable Java compatible with the J2EE framework. VistA is the core Electronic Healthcare Recordkeeping (EHR) system for the VHA hospital system, which provides EHR record keeping for more than 4.5 million veterans.

Customer: Veterans Health Administration and SAIC

Source & Target Language: Mumps to Java

Lines of Code: 300,000

Duration:  5 Months

Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Engineering Support, Transformation Blueprint®, Application "As-Is" Blueprint®

 

 

Published in Case-Studies

Using money from the Technology Modernization Fund (TMF) under the Modernizing Government Technology Act disbursed by the General Services Administration (GSA) of the U.S. government, the Department of Housing and Urban Development (HUD) sought to modernize several of its remaining critical systems on a legacy Unisys mainframe written in COBOL with a flat-file DMS-II database.

Customer: Department of Housing and Urban Development and Salient CRGT

Source & Target Language: Unisys COBOL to Java

Lines of Code: 1.3 Million

Duration:  8 Months

Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Enginerring Support, Software Maintenance Agreement, Transformation Blueprint®Application "As-Is" Blueprint®

 

 

Published in Case-Studies
Friday, 30 April 2021 11:21

COBOL to C# - Retail Client

A $39 billion clothing retailer with 4,300 stores worldwide sought to modernize its suite of mainframe COBOL supply chain applications. These applications supported the client’s unique business process, which provided them with a major competitive advantage and fueled years of unprecedented growth. Today, the clients business logic was preserved and their services are hosted on Azure with data integration directly through service bus queues and scheduling handled via Logic Apps.

Customer:  Retail Client

Source & Target Language: COBOL to C#

Lines of Code: 86,000

Duration:  3 months

Services: Code Transformation, Automated Refactoring, Testing and Implementation Support, Transformation Blueprint®

 

 

Published in Case-Studies
Monday, 04 April 2011 16:03

BASIC to PL/SQL - Capita Prism

Capita, a company based in England and Wales, determined that one of their important software assets called PRISM required modernization, including code transformation, platform migration, and database migration. Capita engaged TSRI, with their proven automated modernization services, to complete this project, which was finished in 3 months.

Customer: Capita

Source & Target Language: BASIC to PL/SQL

Lines of Code: 660,000

Duration:  3 months

Services: Transformation Blueprint®, Automated Code Transformation, Automated Refactoring, Integration and Testing Support

 

 

Published in Case-Studies
Wednesday, 10 October 2001 13:00

COBOL to C++ - NEA / Administrative Systems

The National Endowments for the Arts (NEA) Grants Management System (GMS), Financial Management System (FMIS), and Automated Panel Bank System (APBS) were unique one-of-a-kind 27-year old legacy systems written in Wang VS COBOL, running on a WANG VS Operating System, and using a WANG VS DMS database. TSRI was engaged to transform these systems into C++ and completed the project successfully in 7 months.

Customer: National Endowments for the Arts

Source & Target Language: COBOL to C++

Lines of Code: 656,000

Duration:  5 months

Services: Code Transformation, Automated Refactoring, System Integration Support, Testing Support, Transformation Blueprint ®

 

Published in Case-Studies
Page 2 of 2