Leading Edge Admin
Leading Edge Admin is a Third Party Health Benefits Administration.
They have access to a critical vendor database for some of their reporting. The issue was that they only had read only and could not create indexes, views, functions and stored procedures in the vendor database. This posed a problem for Leading Edge Admin as some of their reports would time out or take significant time to run.
Everconnect was brought to write a fully customized replication solution to provide LEA with their only copy database that they had full control over. Not only did Everconnect complete the replication of the database, but also advised on the index strategies and writing (and optimizing) many stored procedures to make their reporting process run smoothly.