Outcome: a high performance, standards-based custom ODBC driver allows the company’s legacy applications to continue to work while enabling additional functionality in their data landscape.
A large, well known On – Line travel company.
The company has an existing on premise solution that uses only Microsoft’s SQL Server as the database solution. The company wished to modernize their data infrastructure to be able to handle an architecture that had a more heterogeneous data landscape. More specifically, they wanted the ability to be able to have other non-Microsoft data sources and also the ability to locate their databases in a mixed on-premise and cloud environment.
- The solution needed to provide 100% backwards compatibility with the existing solution to allow the legacy applications to continue to function as if nothing had changed
- Move their data from on-premise to the cloud and not impact existing applications
- Add custom security into the middle tier to further secure their data
- Have the ability to change the underlying database from SQL Server to another source without impacting existing applications
The solution was to build a custom ODBC driver specific to their needs. An ODBC driver is quite complex and they were concerned more with their own specific needs rather than the intricacies of ODBC and compatibility. The solution was to leverage the industrial strength SimbaEngine ODBC SDK to quickly build a fully compliant ODBC driver where they could customize specific functionality. Their plan was a multi-faceted approach:
- Use the SimbaEngine ODBC SDK, they built a custom ODBC driver to replace the existing SQL Server ODBC driver.
- Add a REST interface to their cloud layer, where they relocated their SQL Server instances.
- Utilize the SQL Engine in the SimbaEngine ODBC SDK so the custom ODBC driver could properly parse the SQL that their new and legacy applications were issuing
- Enable their additional security because the parts of the driver that talked to the REST API were completely under the control of the company.
The company now has a high performance, standards-based custom ODBC driver that allows their legacy applications to continue to work while enabling additional functionality in their data landscape. They were able to add additional security and scalability by moving to the cloud and adding a REST layer, while reducing the dependency on SQL Server by adding an abstraction layer. This allows them the freedom to explore other data sources while allowing their embedded BI applications to work as they always have.