Skip to the main content.
Downloads Thriftly Login
Downloads Thriftly Login
Group 762

Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL &  MariaDB.

flex2Crystal

Stuck in Crystal XI?  Upgrade and use the latest versions of Crystal Reports with DataFlex applications. 

BTR2SQL

Seamlessly convert from Btrieve transactional database to PostgreSQL, Oracle, and MS SQL Server.

thriftly-1

Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP,  Thrift, and gRPC.

 Group 671-1

 

Why Mertech?

2 min read

Bank of America Migrates from Btrieve to Oracle with BTR2SQL

Bank of America Migrates from Btrieve to Oracle with BTR2SQL

When William Stucky & Associates (WSA) set out to migrate Bank of America's loan processing application from Btrieve to Oracle, they used Mertech's BTR2SQL driver to facilitate the process. A transition that could've required thousands of hours of costly code rewrites and data reformatting was instead made simple through WSA's partnership with Mertech.


Mertech Product Provided

BTR2SQL


Seeking the Oracle

Since 1979, William Stucky & Associates (WSA) has provided over 400 prominent banks and commercial finance companies with software tools to automate their businesses. In particular, WSA is the U.S.’s leading supplier of asset-based lending software. Their system, Windows Asset-Based Lending Manager (WinABLM) allows lenders with portfolios ranging from one million to ten billion dollars worth of loans to access up-to-the-minute info on their assets, from anywhere in their corporate network.

William Stucky & Associates, Inc.
Bank of America

About WSA

William Stucky & Associates produces the industry's most widely used asset-based lending and factoring software. Located in San Francisco and founded in 1979, WSA works with over 400 prominent banks and commercial finance institutions, including Bank of America.

Read Bank of America Case Study

 


One of WSA’s more notable clients, Bank of America, used WinABLM to process large-scale precious metal loans. While Bank of America was mostly happy with the software’s multi-branch reporting capabilities, they experienced difficulties when attempting to synchronize six branches worth of data at their main New York office. Tired of having to manually dump disparate piles of Btrieve data into their main Oracle database, Bank of America decided to move to a single, enterprise-wide database platform. Due to the size and scope of their needs, Bank of America selected Oracle.


Typically, when companies providing transactional-based (Btrieve) applications assist customers in migrating to set-based (Oracle) databases, the project requires significant time and effort, up to and including a complete code overhaul. Neither able nor willing to invest in rewriting WinABLM’s code or creating a new solution from scratch, WSA approached Mertech to aid in Bank of America’s migration process.

 


No other product would have allowed this complex, Btreive-based application
to work with Oracle without a significant rewrite.

– Riaz Merchant, CEO at Mertech

 

 


 

Keeping the Transition Cost-Effective

Without Mertech’s assistance, WSA’s Bank of America migration project was estimated to require over 4,000 hours of developer time, to say nothing of the time necessary for testing and iteration. By incorporating Mertech’s BTR2SQL driver into the project, WSA was instead able to complete the entire migration in just a few months.


Mertech’s BTR2SQL driver headed off the need for a code rewrite by creating a seamless connection between WSA’s application and Bank of America’s database. BTR2SQL intercepts Btrieve-based commands, like those coming from WSA’s application, and relays them to Oracle databases as optimized, efficient Oracle statements. After a series of thorough testing phases, WSA went live alongside Bank of America’s new database.


Our transition and testing phases were very smooth. Whenever we had a question
or hit a snag, the Mertech support people were right there with the answer.

– Bill Stucky, President of William Stucky & Associates

 

 


 

Efficient Large-Scale Reporting Without an App Overhaul

With the transition completed, Bank of America no longer had to manually transmit, upload, and resend data when looking for a big-picture view of their branches’ activity. In a fraction of the time it would’ve taken to rewrite WSA’s application code, Bank of America was live on WSA’s app alongside Oracle, providing the financial institution with improved performance, greater scalability, and enhanced reporting, thanks to BTR2SQL.

 

 



Learn More

Read how BTR2SQL can help your business transition to industry-standard databases.

Download Our BTR2SQL Whitepaper

Application Modernization 101: Ultimate Guide to Digital Transformation

Application Modernization 101: Ultimate Guide to Digital Transformation

Imagine breaking free from the constraints of old, monolithic systems and embracing the agility and innovation of cloud-based solutions.

Read More
Cloud Outages: Causes & Risks (and How to Handle Them)

Cloud Outages: Causes & Risks (and How to Handle Them)

This post has been co-authored with Matt Ledger.

Read More
A Comprehensive Guide to Enterprise Application Modernization

A Comprehensive Guide to Enterprise Application Modernization

In a world where technology often outpaces business strategy, enterprise application modernization emerges as a critical bridge. This strategic...

Read More