Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL & MariaDB.
Stuck in Crystal XI? Upgrade and use the latest versions of Crystal Reports with DataFlex applications.
Convert from Btrieve / P.SQL / Actian transactional engines to Oracle, MS SQL Server, and PostgreSQL
Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP, Thrift, and gRPC.
Led by founder F.A. "Woody" Spencer, USA Software's team of software engineers and former police professionals provide law enforcement agencies across the U.S. with information management and communications software. As the agencies USA Software worked with began switching to industry-standard SQL databases, USA Software knew they needed to make the move as well. Mertech's Flex2SQL driver helped USA Software easily connect with customers' SQL databases and migrate their own data, creating a faster, more robust law enforcement software solution.
Since 1989, USA Software has provided communications and information management solutions to law enforcement agencies throughout the United States. With more than 150 installations in Florida and Georgia alone, and nearly 200 years combined law enforcement experience, USA Software’s team specializes in computing, policing, and offering products that work.
With more than 150 installations in Florida and Georgia alone, and nearly 200 years combined law enforcement experience, USA Software takes pride in helping law enforcement agencies manage their information systems and improve communications.
But as USA’s customers and competitors began utilizing SQL-enabled software solutions, the company found themselves behind the curve. USA’s DataFlex application, and the database behind it, couldn’t offer the same robust features as SQL-based apps. That didn’t sit well with F.A. “Woody” Spencer, USA Software’s founder and President.
"Our customers were asking for a more standardized backend database, such as Microsoft SQL server, since many cities and counties were adopting that as their standard."
To make that conversion happen, USA Software turned to Mertech’s Flex2SQL driver. Flex2SQL allowed USA to seamlessly connect their DataFlex application to their customers’ SQL databases, as well as migrate customers’ existing DataFlex data to SQL.
Many of USA’s customers were using multiple DataFlex tables, each of which contained hundreds of thousands of records. Still, the migration from DataFlex to SQL went as smoothly could be imagined, with Mertech’s support team stepping in to aid USA Software the one time they did need assistance.
“We chose Flex2SQL for its ease of use and its simplicity. We already knew of the product's speed and reliability. Even still, the ease of converting an existing customer from DataFlex to SQL impressed us.”
- F.A. "Woody" Spencer
With Flex2SQL in place, USA Software can now supply law enforcement agencies with a faster, more robust software solution, making policing just a little bit easier. USA’s applications now provide increased data integrity, speedier reporting, easier third-party integrations, and online backup and disaster recovery, all thanks to their connection to SQL.
"Now, when our sales staff does presentations, we lead with the fact that our products support the leading SQL databases. I’m glad we finally made the move.”
- F.A. "Woody" Spencer
Read how Flex2SQL can help your business transition to industry-standard databases.
Mertech: Mar 29, 2024 8:53:00 AM
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
Mertech: Mar 7, 2024 4:32:00 PM
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Mertech: Mar 5, 2024 5:06:00 PM
Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...
Mertech