Displaying items by tag: DB2 Database

Educational Testing Service (ETS) is the world's largest private educational testing and measurement organization. Each year, they develop, administer,  and score more than 50 million tests, including the TOEFL®, TOEIC®, GRE®, and Praxis® tests, in more than 180 countries. This requires an enormous data management capability. ETS turned to TSRI to transform their ECT and Praxis applications and databases from IBM job control language (JCL) and COBOL Batch to modern Java SE 17 in a cloud-native optimized AWS environment. To do this, they used a spring boot-type application to implement web services invoked by Python. TSRI also converted the IBM DB2 database and VSAM sequential database files to a relational PostgreSQL database on AWS Aurora.

Customer: Educational Testing Service (ETS) Source & Target Language: IBM COBOL to Java SE 17 on AWS Lines of Code: 1,199,633 lines of COBOL and JCL Duration:  11 Months Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation "To-Be" Blueprint®, Application "As-Is" Blueprint®, Code Warranty

CRA and AWS engaged with TSRI to complete the modernization of their COBOL-based system to Java on AWS. To Achieve CRA's goals, TSRI tuned JANUS Studio® to parse, transform, document, and refactor the IBM z/OS COBOL application. In just 1.5 months, TSRI modernized the application from an IBM Mainframe COBOL and CICS monolith to a modern multi-tier architecture in Java on the AWS cloud. Just as important, TSRI also converted the DB2 database and VSAM sequential files to a relational PostgreSQL database on AWS Aurora.

Customer: Canada Revenue Agency (CRA) and AWS Source & Target Language: IBM COBOL to Java on AWS Lines of Code: 168,000 Duration:  1.5 Months Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation "To-Be" Blueprint®, Application "As-Is" Blueprint®

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

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®