Application Modernization

Bring your data apps to life

The world is changing faster and faster. Costs are rising. Data security risks are a real threat, and are increasing by the day. Consumers are increasingly demanding and preferential. Employees are tasked with more duties every day. Staying on top of the digital wave is a full-time job.

Now, more than ever, you need to take charge of your application footprint and bring applications to modern.

Empower your customers and staff for self-service.

Reduce slowness. Improve data security.

THE FRONT-END

Bring your data to life by modernizing application front ends. End users expect snappy, easy to read and easy to navigate interfaces. Research has shown that the simple change of fonts and white-space on input screens can dramatically decrease errors just because the subconscious believes it's simpler to use. This is especially true for an aging workforce.

Modernization of the front end means you take some or all of the screens and reports of the application and make them better using new technologies.

  • AnyKey has created new Web-based interfaces for legacy applications that provide access to self-service functionality without having to throw away the old system. That allows the old workflows and customer-driven self-paced workflows to continue in parallel.
  • In another case, AnyKey migrated an internal Microsoft Access database over to a purely Web-based Portal where their member-owners could gain access to timely information about their national quick service supply chain.

THE BACK-END

Bring your data to life by upgrading the back-end database storage to a Modernized SQL Server 2016/2017 from a legacy desktop database system (Microsoft Access, Visual FoxPro, Paradox, dBase III/IV, MSDE/SQL Express), end of life SQL Server (SQL Server 7, 2000, 2005, 2008/R2, etc), or open source database system (MySQL).

  • AnyKey has implemented numerous Access -> SQL Server re-platforming projects.
  • AnyKey converted an enterprise Engineering Project Construction Management application backend from Visual FoxPro to Microsoft SQL Server -- even when Microsoft said it wasn't possible. We crafted custom middle-tier interfaces that "translated" FoxPro database commands and queries into SQL Server queries and result sets. Over 200 forms and 200 reports were impacted.
  • AnyKey has assessed hundreds of databases for modernization from SQL Server 2000, 2008/2008 R2, 2012 and 2014 towards SQL Server 2016 backends -- reviewing database level code (functions and procedures) plus schema and data storage types.

Talking tech

Read further at your own risk. We're going to get our "nerd on" for those who are curious.

The following partial list is only a sampling of the mainstream technologies we've worked on and can move from / to, or modernize to newer versions.

Our technology experience has brought us into projects for web, client/server, multi-tier, cloud hyper-scaled, and mobile applications on Windows (Win32/64/ARM/.NET), Linux/Unix, macOS, Android, iOS (and even some OS/2 Warp, but shhh, don't tell anyone).

RDBMS and friends : Development IDEs, Environments, Languages, etc:
  • Microsoft SQL Server
  • Oracle
  • IBM DB/2
  • PostgreDB
  • Sybase/ASE
  • MySQL
  • SQLite
  • Borland/Embarcadero Interbase
  • Microsoft Access
  • Visual FoxPro/dBase/Paradox (DB?)
  • NoSQL
  • XML / JSON / CSV
  • SSIS Packages, ETL, BCP
  • Microsoft GW BASIC, Visual Basic, VB.NET; all the Microsoft basics, basically...
  • Microsoft C#, F#
  • R
  • PHP, Node.js, Python, AJAX, Java, JavaScript, HTML/HTML5, CSS, etc.
  • Borland/Coderage/Embarcadero Turbo Pascal, Delphi, C++Builder, RAD Studio (VCL, FireMonkey, DataSnap, IntraWeb bases), HTML5Builder
  • GNU C++ / Watcom C
  • Xamarin, Firemonkey, HTML5Builder, XCode
  • Microsoft FoxPro and Visual FoxPro all versions
  • Paradox, all versions.
  • dBase III, IV

Some APIs and SDKs we've developed with:

  • Microsoft DirectX 7, 8, and 9
  • Microsoft COM Add-Ins for Microsoft Project, Outlook, Excel and Word
  • Wordpress custom add-ins
  • WooCommerce database-level integrations for product management
  • Numerous third party Components for Visual Studio and RAD Studio+

Disclaimer: AnyKey has extensive experience in pretty close to all business horizontals and verticals, large and small, and as such have been privileged to be exposed to technologies (good, bad and ugly). As a general policy, we're tools and technologies agnostic. We believe that there are more than one approach and more than one way of achieving the business requirements, and so while we have our preferential tools we don't play favorites. If we don't list a technology, it's not because we don't "do it", it's because we didn't list it. We have an extensive international team of developers and we can work with pretty much any development technologies, tools, IDEs, APIs, SDKs, interfaces, etc...

Benefits

  • Empower self-service strategies.
  • Reduce slowness.
  • Improve data security.

Call AnyKey to Continue™