So you want to build an ODBC driver?
First, I want to say congratulations since this project reflects well on the popularity of your data source. As a Systems Engineer, I have worked with numerous shops on this project in each phase from planning, development, testing all the way to production; and I want to share the things that typically go overlooked.
This applies to all the common approaches including:
Building an ODBC driver is very much like the Harlem Shake. You build a single prototype and it seems to be doing ok, and then the base drops; and you have total chaos ranging from "our largest prospect cannot use open source driver managers on Linux" to "a request for a 64-bit AIX client the very next day for Informatica PowerCenter".
If you've never seen a Harlem Shake, our friends at Plex Systems produced one, along with great ODBC connectivity:
When you build a Unix/Linux ODBC client, there are a lot of things to consider upon releasing a driver:
ODBC has been around for decades and there are thousands of applications out there ranging from Microsoft Office and SQL Server to data visualization tools like Tableau, Qliktech or Spotfire. It's important to choose a codebase that has been battle tested. Here are some things to look out for:
For shops using a published protocol, you can own the end user experience by distributing commercial drivers such as the DataDirect Connect and Connect64 for ODBC Postgres drivers or the Hadoop Ecosystem.
As soon as you release an ODBC driver, I guarantee someone will ask for JDBC, OLEDB or ADO.NET that very same day. I am definitely hearing more about JDBC data integration tools such as Pentaho Data Integrator, Talend, and Oracle Data Integrator; as wells as Java web applications.
We do. And so do these guys: NetSuite, COINS Global, or Hewlett Packard.
Download a trial of the DataDirect OpenAccess SDK to address all the questions above, or call 1-800-876-3101 to speak live with an OpenAccess Systems Engineer to share your plans, and learn how other organizations are making progress with DataDirect OpenAccess when building drivers for a wide variety of data sources:
SaaS or On-premise Applications
File-based data stores
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.