Displaying items by tag: sql

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®

The Pitney Bowes Postage Payment Application had been running COBOL for decades on an HP NonStop Tandem mainframe, however, to seize the opportunities of the digital cloud age and to reduce overall technical debt, Pitney Bowes needed to modernize the Tandem COBOL to C# .NET Core. Just as important as the code, the HP NonStop Tandem database needed to also be migrated to a modern Microsoft SQL Server database and deployed to AWS. TSRI successfully transformed the application at 99.96% automation, and deployed the modernized application on the AWS cloud.

Customer: Pitney Bowes Inc. Source & Target Language: COBOL to C# .Net Core on AWS Lines of Code: 390,000 Duration: 6 Months   Services:  Automated Code Transformation (99.96% level of automation), Automated Refactoring, Database Conversion: File based system to a Microsoft SQL Environment, Integration and Testing Support, Transformation Blueprint®, Application "As-Is" Blueprint®,

Shaw Cable Systems, one of TSRI's Candian customers, engaged TSRI to modernize their CBS system, which involved 772,684 lines of VMS VAX BASIC source code and 275,707 of VAX Basic comments.  The system modernization called for code conversion to C#, along with other services. 

Customer: Shaw Cable System Source & Target Language: VMS VAX BASIC to C# Lines of Code: 1.1 Million Duration:  5 months Services: Automated Code Transformation, Automated Refactoring, Separation of the business and data logic into tiers, Integration and Testing Support,  Engineering Support, Transformation Blueprint®

Sempra Energy needed to move their Microgrid Control System (MCS) application into a more contemporary environment. The challenge that TSRI and mLogica faced was transforming Sempra Energy's existing Sybase OpenServer platform into a more modern .NET/MS-SQL server environment under strict budget and schedule constraints. The project, which included the modernization, documentation, refactoring, testing, and integration of the application, was successfully concluded on-time and within budget constraints.

Customer: Sempra Energy & mLogica Source & Target Language: C to MS-SQL/C Lines of Code: 211,000 Duration: 4 Months Services: Automated Code Transformation, Automated Refactoring, Round-tripping, Unit Testing, Third Party Code Quality Refactoring, Integration and Testing Support, Transformation Blueprint®, Application Blueprint®

GEMS (Geospatial Environmental Mapping Software) , provides the B52, F15 and TX training jet—with mission-critical data to provide air crews with real-time information. TSRI was able to modernize GEMS against the government mandated LDRA compliance tool, with 100% successful unit testing that meet and exceeded the mandated avionics standards.

Customer: Boeing Source & Target Language: Ada to C++ Lines of Code: 388,896 Duration: 16 Months Services: Automated Code Transformation, Automated Refactoring, Unit Testing, Third Party Code Quality Refactoring, Integration and Testing, Transformation Blueprint®, Application Blueprint®

TSRI, in partnership with Hewlett-Packard, rapidly adapted its automated JANUS Studio® transformation engine to be ALC-compatible so they could conduct an ALC-to-Java prototype modernization effort for the US IRS. The high levels of automation enabled quick transformation and refactoring iteration, which rapidly and systematically discovered and isolated defects. Allowing TSRI engineers to quickly adjust the automated conversion rules, and quickly regenerate the system at higher output quatlity.

Customer: Hewlett-Packard and The US Internal Revenue Service (IRS) Source & Target Language: Assembly to Java Lines of Code: 8,000 Duration:  1 Month Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Defect Isolation, Transformation Blueprints ®, Application Blueprints ®

Navigant Consulting Services was tasked to modernize The Corporate Maintenance & Stop Loss System for HCSC (Health Care Services Corporation). This legacy system was written in the PowerBuilder and Magna-X software languages. Navigant contracted with TSRI to perform the code transformation of both languages into Java, refactor the application to improve performance, and produce bridge documentation.

Customer: Navigant Consulting Services Source & Target Language: MagnaX and PowerBuilder to Java Lines of Code: 1,972,691 (MagnaX - 1,785,691, PowerBuilder - 187,000) Duration:  15 months Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Engineering Support, Transformation Blueprint®, Application "As-Is" Blueprint®

Raytheon Corporation awarded a sole-source contract to TSRI for modernization of the US Air Force’s Weather Data Analysis Capability (WDAC) program.  This project was completed very quickly and successfully, using TSRI's fully automated toolset, including the automated production of documentation and refactoring to remove dead and redundant code.

Customer: The US Air Force & Raytheon Source & Target Language: Fortran to Java Lines of Code: 47,426 Duration: 1 month Services:  Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Transformation Blueprint®, Application "As-Is" Blueprint®

The State of Washington’s Office of the Superintendent of Public Instruction (OSPI) awarded a sole-source contract to TSRI for modernization of the State’s Apportionment System.

Customer: The State of Washington OSPI Source & Target Language: COBOL to C#/.Net Lines of Code: 204,176 Duration: 5 Months   Services:  Automated Code Transformation, Automated Refactoring, Database Conversion: Open VMS RMS Flat Files to a Microsoft SQL Environment, Integration and Testing Support, Transformation Blueprint®, Application "As-Is" Blueprint®,