Case study · August 2022

Criminal Justice System (CJIS) migrates to the cloud

Illustration of applications moving to the cloud

Migration from Broadcom (formerly CA) Datacom to the cloud using automated tools.

The Criminal Justice System supporting a large California county depended on older legacy technologies and platforms. With much at stake, it was crucial for the government to manage its Criminal Justice System as efficiently as possible. But the 20-year-old IBM mainframe technology handling the job, with a custom COBOL-based application, was showing its age.

When business analysts needed reports, the IT department had to take data offline, transform it into a format that could be analyzed, and run the report. Writing new reports to meet new requirements could add days or weeks to the process. Personnel were dedicated to maintaining arcane mainframe-to-server connections and mainframe procedures — people who could otherwise have been dedicated to customer support or other higher-value work.

The data in the system was needed by a growing number of departments and agencies throughout the county — public safety, zoning, planning, permits and library among them — but integrating the mainframe with those departments’ systems, and with the county’s Enterprise Resource Planning software, was cumbersome. Integrating the system with web services was equally difficult.

The solution

Digital Strategy Group used its automated tools to convert the existing legacy application, including the existing user screens. Migrating and validating the database included the conversion of hundreds of tables with millions of rows of data.

The result

The county achieved its stated aims — and more — by migrating its mainframe-based CJIS system to Windows Server. It is now positioned to take advantage of the .NET Framework, Microsoft SQL Server, Visual Studio and web services. The system can now be integrated not only with other systems throughout the county — boosting accuracy and efficiency by enabling all agencies to work from a single database — but also with state and federal systems.

More case studies

Take the next step

Ready to retire your legacy 4GL? Schedule a no-cost call to review your source and conversion options.