SimbaEngine ODBC SDK is a Software Development Kit for developing fully-featured, optimized ODBC Drivers for any SQL-enabled or non-SQL data store. SimbaEngine ODBC SDK’s documentation provides you with comprehensive information to rapidly develop a prototype data driver, which can then be extended to include additional functionality and optimizations. Once you have built your ODBC Driver, you can also easily and quickly add JDBC, OLE DB, and ADO.NET connectivity.
You can build a prototype ODBC Driver using SimbaEngine ODBC SDK within five days. Use our Quickstart driver and one of our “5-Day Guides” for ODBC, JDBC or ADO.NET to accelerate the development process according to the requirements of your data store. You can quickly build a prototype read-only ODBC Driver, then add further functionality to your ODBC Driver. You can continue working with your original prototype ODBC Driver to prepare it for distribution and, if you want, add advanced functionality if necessary.
Once you have developed an ODBC Driver using SimbaEngine ODBC SDK, simply use the following additional components with the ODBC Driver to create either a JDBC Driver, OLE DB Driver, or an ADO.NET Data Provider.
- Create a JDBC Driver by simply employing our JDBC Client with SimbaServer.
- Create an OLE DB Driver by simply employing an OLE DB / ODBC Bridge.
- Create an ADO.NET Data Provider by simply employing the ODBC.NET Data Provider from Microsoft.
Our ODBC SDK enables our customers to develop a proof-of-concept ODBC Driver within five days with the ability to add advanced functionality after that. Building a high-performance, commercial quality ODBC connectivity solution is done quickly and easily using our comprehensive SDK, which includes:
- A fully-operational sample Codebase driver to quickly and efficiently learn how to code an ODBC Driver;
- Simba "Quickstart" template to quickly and easily connect SimbaEngine ODBC SDK to your SQL or non-SQL data store, enabling you to quickly create a prototype ODBC Driver;
- Our extensive, professional, technical documentation, providing all the thorough and comprehensive information needed to support development efforts, including optimization;
- Simba's powerful, flexible, multi-user ODBC/SQL processor;
- Ready to use, high-performance client-to-server networking components, available to quickly and easily extend your solution.
Any application with ODBC connectivity will connect to an ODBC driver built with SimbaEngine ODBC SDK. Your ODBC driver will work with all ODBC-based applications, such as Microsoft Excel, Microsoft Access, SAP Business Objects Crystal Reports and others.
ODBC specifies three levels of SQL grammar conformance: Minimum, Core and Extended. Each higher level provides more fully-implemented data definition and data manipulation language support. SimbaEngine ODBC SDK fully supports the Minimum read-only SQL grammar, as well as many Core and Extended grammars.
Unique to SimbaEngine ODBC SDK, you can build an interface to derived data, dynamic metadata and "in-memory" data. SimbaEngine ODBC SDK is the only ODBC SDK that gathers this information at query time, enabling you to determine and support changes to your schema.
Simba's client-server toolkit provides our universal ODBC and JDBC thin-client drivers, a proprietary network transport layer and a server component. The components are combined with the ODBC Driver code that you develop using our ODBC SDK; no network gateway or client-side programming is required. Our Simba thin-clients greatly reduce configuration issues on the desktop, while providing robust, centralized server-side deployment. Simba's network transport layer is designed to provide high-performance data access over the LAN, WAN, or Internet.
Even if you are currently only seeking ODBC connectivity through a native ODBC interface to your proprietary database, you may also want the flexibility to easily and quickly adopt a JDBC Driver, OLE DB Driver, or an ADO.NET Data Provider in the future. SimbaEngine ODBC SDK is a complete ODBC SDK for building an ODBC Driver to provide both ODBC and JDBC, as well as OLE DB and ADO.NET access to your existing database, enabling you to take full advantage of any of the newer development platforms you may consider. If you choose to migrate to a different database server in the future, you can quickly and efficiently leverage the investment made in your ODBC Driver by reusing your ODBC-enabled shell with a new or upgraded database.
You can do this with Simba’s unique Collaborative Query Execution feature, which allows your data store to execute any part of a SQL query.
Simba SQL Engine’s unique Collaborative Query Execution takes full advantage of your data store’s special processing capabilities and strengths by allowing your data store to execute any part of any SQL query. Simba SQL Engine will not execute the parts of the query that your data store is handling. Instead, Simba SQL Engine will execute the remaining parts of the query and combine into a single result set its own results and the results from your data store. Many non-SQL data stores can perform table filtering or aggregation very quickly, as part of their end-user value. Collaborative Query Execution allows your data store to continue to deliver this high-value performance as part of complete SQL query processing. Pass-down filters and pass-down aggregations are two specific examples of this functionality.
This feature can be especially valuable if the data store is being accessed across a network connection. With fewer results-set rows returned to Simba SQL Engine, the query processing doesn’t wait for data and the final result set is returned to the user sooner.
After your ODBC Driver, OLE DB Driver, JDBC Driver, or ADO.NET Data Provider is complete, SimbaEngine ODBC SDK continues to save you development time. When you build a data driver using SimbaEngine ODBC SDK, you don't have the headache of rewriting your driver every time the ODBC specification changes. We provide our customers with updates that add functionality to your data driver. We provide the upgrade path to new versions of the ODBC specification, as well as to other technologies, such as JDBC, OLE DB, XML data streaming and ADO.NET.
The only true way to effectively evaluate our software is to evaluate it in your environment. We provide you with our complete SimbaEngine ODBC SDK Evaluation Software and a dedicated support team to assist you throughout the evaluation effort at no cost. Your development team will work closely with the Simba Technical Support team to ensure that your evaluation criteria are met and your efforts are successful.
Download a 30-day evaluation of SimbaEngine ODBC SDK.
For more information about SimbaEngine ODBC SDK, contact us.
