SimbaEngine SDK

Relational Data Connectivity - ODBC, JDBC, ADO.NET and OLE DB
Overview
Features
Specifications
FAQs
Documentation

sdk-overview-thumbThe SimbaEngine software development kit (SDK) enables you to build fully-featured and high- performance data drivers (ODBC, JDBC, ADO.NET, and OLE DB) for SQL-enabled and non-SQL data stores. The SimbaEngine SDK features industry- first support for ODBC 3.8 and JDBC 4.1. It also delivers JDBC 3.0/4.0, ADO.NET, native Unicode capability, and the industry’s widest support for 32-bit and 64-bit platforms (including OS X).

Get Started

  • Choose your framework: Learn how to build an ODBC driver, JDBC driver, ADO.NET provider, or OLE DB provider.
  • Download and try the SimbaEngine SDK for free.
  • Watch the video: Build an ODBC driver in five days.

See the Impact

  • Easy to Use: Develop a driver in just five days.
  • Proven: Simba partners like Cloudera, Microsoft, Teradata, SAP, Hortonworks, and MapR embed SimbaEngine-developed connectivity drivers in their own products.
  • Flexible: Deploy your driver the way you want, as a client-side, client-server, or cloud solution.
  • Extensible: Connect your applications (Excel, Tableau, or any reporting or analytics tool) to any data source, be it SQL-enabled, NoSQL, or proprietary.
  • Certified for Tableau: The Simba Certified-for-Tableau Custom ODBC Driver Program provides Tableau interoperability validation for your SimbaEngine SDK-developed custom ODBC drivers. Learn more here.
  • Ground-breaking: The SimbaEngine SDK is the first in the industry to support ODBC 3.8 and JDBC 4.1.

Compare Features

  • How does the SimbaEngine SDK Stack Up Against the Competition? See for yourself:
 Feature Another SDK SimbaEngine SDK
 ODBC 3.8 Support No Yes
 JDBC 4.1 Support No Yes
 Mac OS Support No Yes
 Tableau TDC Sample No Yes
 Tableau Connectivity Best Practices Guide No Yes
 Extended C, SQL, Custom-SQL Data Type Support No Yes
 Collaborative Query Execution No Yes

 

m4s0n501

Product Features

  • ODBC 3.8 support, including full asynchronous execution
  • JDBC 4.1, 4.0, and 3.0 support
  • ADO.NET support
  • Tableau Integration
  • Auto Detection of Driver Managers
  • ODBC 3.8 C Data Type Extensibility
  • Custom aggregate function support: If an aggregate function is not supported by default, add support for it via your data-source
  • Index Support
  • Kerberos Support for C++ and Java
  • Full custom scalar function support: If a scalar function is not supported by default, then easily implement
  • Ability to fully rebrand Simba Clients
  • Collaborative Query Execution
  • Data Definition Language (DDL) is now supported. Specifically, CREATE/DROP tables and indices are supported.
  • CASE Expression Support: The SQL Engine now accepts <SIMPLE CASE> and <SEARCHED CASE> expressions in SQL queries. Case abbreviations (NULLIF & COALESCE) are also allowed.
  • Visual Studio 2012 Support: Users can now develop ODBC Drivers and ADO.NET Providers using the latest development technology from Microsoft.
  • Support for dynamic schema
  • Full Unicode support for data, metadata and API parameters
  • Windows 8, 8.1 & 2012 Support
  • Native support for 32-bit and 64-bit operating systems
  • Supports Client Server Architectures
  • Advanced pass-down functionality
  • Responsive customer support
  • Quickstart and Ultralight driver samples/templates and guide
  • Default support for 13 Locales: English, German, French, Spanish, Italian, Japanese, Simplified Chinese, Traditional Chinese, Korean, Dutch, Russian, Portuguese, Swedish

Product Specifications

SimbaEngine SDK supports the following platforms and tools:

Stand-alone Data Driver and Server Platforms

  • All SimbaEngine SDK components support 32- and 64-bit versions of Windows, Linux, Solaris, AIX, HPUX, as well as Mac OS.

Client Platforms

  • SimbaClient for ODBC supports the 32- and 64-bit versions of Windows, UNIX, Linux, Max OS X, AIX, HPUX, Solaris
  • SimbaClient for JDBC supports all client operating systems running a Java Virtual Machine (JVM) 1.5 or above
  • SimbaClient for ADO.NET for Windows only

Development Software

  • Windows: Microsoft Visual Studio 2012/2013
  • UNIX: For all platforms, the native compiler is supported.
  • Linux: GNU Compiler environment.
  • Mac: GNU Compiler environment.

Desktop Tool Support

  • Any ODBC-capable application, including IBM Cognos, Microsoft Office, MicroStrategy, Tableau and SAP Business Objects Crystal Reports, etc

Quick and Easy ODBC Driver Development for Industry-Standard, High Performance Data Connectivity

SimbaEngine’s ODBC SDK supports a wide variety of implementations to meet your project and system requirements. The SimbaEngine ODBC toolkit includes all the components you need to deploy your ODBC driver as a single tier, two-tier or three-tier standards-based solution in as little as a few days.

Key ODBC Features

The SimbaEngine ODBC toolkit provides you with a complete set of components to quickly, easily and cost-effectively implement a full-featured ODBC driver. Following the ODBC SDK’s comprehensive documentation, you can choose to add an array of pre-defined functionality to easily deploy a fully-optimized ODBC driver ideally suited to your data connectivity requirements. SimbaEngine ODBC SDK supports the latest data standard advancements to ensure the utmost interoperability with ODBC standard-based products in the marketplace.

  • ODBC 3.8 Support – SimbaEngine ODBC SDK supports the ODBC 3.8 specification, as well as custom metadata and attributes for greater flexibility.
  • Unicode Support – SimbaEngine ODBC SDK provides Unicode support for character sets of all international languages. This allows your customers to access their data in virtually any language, resulting in the widest interoperability. Unicode capable ODBC drivers also improve performance and remove the restrictions inherent in Unicode and ANSI mapping.
  • 32- and 64-bit Support – SimbaEngine ODBC SDK natively supports both 32-bit and 64-bit platforms, including Windows, Linux, Solaris, HP-UX, AIX and Mac OS. In addition, 32-bit and 64-bit platforms will interoperate across the client/server connection.
  • Support for SQL and Non-SQL Data Stores – SimbaEngine ODBC SDK supports both SQL-enabled and non-SQL data stores. Non-SQL data stores can use Simba’s SQL Engine to provide SQL processing. SQL-enabled data stores will use SimbaODBC to provide ODBC 3.52 processing.
  • Collaborative Query Execution – SimbaEngine ODBC SDK’s innovative Collaborative Query Execution allows your data store to execute the parts of the query for which it is designed and dynamically leave the rest of the query to be executed by Simba SQL Engine. Because Simba SQL Engine does not redundantly execute the same parts of the query as your data store, your SimbaEngine ODBC SDK data driver delivers the full performance of your data store.
  • Dynamic Indexing within the SQL Engine – Simba SQL Engine supports dynamic indices creation on joining columns when no such indices exist. This speeds up table joins exponentially for faster data access and information retrieval.
  • Pass-Down Processing – Table filters, joins and aggregations can be passed down to your data store for execution if your data store is optimized for those functions.
  • Stored Procedures – SimbaEngine ODBC SDK supports Stored Procedures.
  • Scalar Functions – Support is provided for over 60 scalar and aggregate functions, in addition to allowing you to define your own custom functions.
  • Custom SQL Data Types – Your ODBC driver can choose to implement behaviours different from those provided by the SDK.
  • Custom Data Converters – Your ODBC driver can choose to implement data conversion routines that are the most efficient possible for custom data formats.
  • Interval Data Types – All 13 interval types defined by ODBC 3.52 are fully supported.
  • Maintainability & Extensibility – SimbaEngine ODBC SDK uses the object-oriented paradigm, allowing you to extend features, as well as upgrade to newer versions with ease and predictability.
  • Full Localization Support – All messages from the SDK and specific to the ODBC driver can be localized.
  • Data Driver Samples/Template – SimbaEngine ODBC SDK’s Quickstart and Ultralight Driver Templates are specially designed to provide you with sample code and sample data from which you can quickly build your custom ODBC driver.

Quick and Easy JDBC Driver Development for Industry-Standard, High-Performance Data Connectivity

SimbaEngine’s JDBC SDK supports a wide variety of implementations to meet your project and system requirements. The SimbaEngine JDBC toolkit includes all the components you need to deploy your JDBC driver as a single-tier, two-tier, or three-tier standards-based solution in as little as a few days.

Key JDBC Features

The SimbaEngine JDBC toolkit provides you with a complete set of components to quickly, easily and cost-effectively implement a full-featured JDBC driver. Following the JDBC toolkit’s comprehensive documentation, you can choose to add an array of pre-defined functionality to easily deploy a fully-optimzed JDBC driver ideally suited to your data connectivity requirements. SimbaEngine JDBC SDK supports the latest data standard advancements to ensure the utmost interoperability with JDBC standard-based products in the marketplace.

  • Fully Java Development Environment – SimbaEngine JDBC SDK fully supports a native Java development environment. Choose to implement your JDBC driver in the environment that best suits you.
  • JDBC 3.0 and 4.0 Support – SimbaEngine JDBC SDK supports the JDBC 3.0 and JDBC 4.0 specifications, as well as custom metadata and attributes for greater flexibility.
  • JDBC Type 3 and Type 4 Support – SimbaEngine JDBC SDK can be used to develop both pure Java Type 3 or Type 4 data drivers.
  • Unicode Support – SimbaEngine JDBC SDK provides Unicode support for character sets of all international languages. This allows your customers to access their data in virtually any language, resulting in the widest interoperability. Unicode capable JDBC drivers also improve performance and remove the restrictions inherent in Unicode and ANSI mapping.
  • 32- and 64-bit Support – SimbaEngine JDBC SDK natively supports both 32-bit and 64-bit platforms, including Windows, Linux, Solaris, HP-UX, AIX and Mac OS. In addition, 32-bit and 64-bit platforms will interoperate across the client/server connection.
  • Support for SQL and Non-SQL Data Stores – SimbaEngine JDBC SDK supports both SQL-enabled and non-SQL data stores. Non-SQL data stores can use Simba’s SQL Engine to provide SQL processing.
  • Collaborative Query Execution – SimbaEngine JDBC SDK’s innovative Collaborative Query Execution allows your data store to execute the parts of the query for which it is designed and dynamically leave the rest of the query to be executed by Simba SQL Engine. Because Simba SQL Engine does not redundantly execute the same parts of the query as your data store, your SimbaEngine JDBC SDK data driver delivers the full performance of your data store.
  • Pass-Down Processing – Table filters, joins and aggregations can be passed down to your data store for execution if your data store is optimized for those functions.
  • Stored Procedures – SimbaEngine JDBC SDK supports Stored Procedures.
  • Scalar Functions – Support is provided for over 60 scalar and aggregate functions.
  • Maintainability & Extensibility – SimbaEngine JDBC SDK uses the object-oriented paradigm, allowing you to extend features, as well as upgrade to newer versions with ease and predictability.
  • Full Localization Support – All messages from the SDK and specific to the JDBC driver can be localized.
  • Data Driver Samples/Template – SimbaEngine JDBC SDK’s Quickstart and Ultralight Driver Templates are specially designed to provide you with sample code and sample data from which you can quickly build your custom JDBC driver.

 

Quick and Easy ADO.NET Provider Development for Industry-Standard, High-Performance Data Connectivity

SimbaEngine’s ADO.NET SDK supports a wide variety of implementations to meet your project and system requirements. The SimbaEngine ADO.NET toolkit includes all the components you need to deploy your ADO.NET provider as a two-tier or three-tier standards-based solution in as little as a few days.

Key ADO.NET Features

The SimbaEngine ADO.NET toolkit provides you with a complete set of components to quickly, easily and cost-effectively implement a full-featured ADO.NET provider. Following the ADO.NET SDK’s comprehensive documentation, you can choose to add an array of pre-defined functionality to easily deploy a fully-optimzed ADO.NET provider ideally suited to your data connectivity requirements. SimbaEngine ADO.NET SDK supports the latest data standard advancements to ensure the utmost interoperability with ADO.NET standard-based products in the marketplace.

  • 100% Managed ADO.NET Data Provider – SimbaEngine ADO.NET SDK supports developing 100% managed code ADO.NET data providers against any SQL-enabled data stores, unlocking the full performance potential of your data store.
  • Unicode Support – SimbaEngine ADO.NET SDK provides Unicode support for character sets of all international languages. This allows your customers to access their data in virtually any language, resulting in the widest interoperability.
  • 32- and 64-bit Support – SimbaEngine ADO.NET SDK natively supports both 32-bit and 64-bit platforms, including Windows, Linux, Solaris, HP-UX, AIX and Mac OS. In addition, 32-bit and 64-bit platforms will interoperate across the client/server connection.
  • Support for SQL and Non-SQL Data Stores – SimbaEngine ADO.NET SDK supports both SQL-enabled and non-SQL data stores. Non-SQL data stores can use Simba’s SQL Engine to provide SQL processing.
  • Maintainability & Extensibility – SimbaEngine ADO.NET SDK uses the object-oriented paradigm, allowing you to extend features, as well as upgrade to newer versions with ease and predictability.
  • Scalar Functions – Support is provided for over 60 scalar and aggregate functions.
  • Full Localization Support – All messages from the SDK and specific to the ADO.NET provider can be localized.
  • Data Driver Samples/Template – SimbaEngine ADO.NET SDK’s Quickstart Driver Template is specially designed to provide you with sample code and sample data from which you can quickly build your custom ADO.NET data provider.

Quick and Easy OLE DB Provider Development for Industry-Standard, High-Performance Data Connectivity

SimbaEngine’s OLE DB SDK supports a wide variety of implementations to meet your project and system requirements. The SimbaEngine OLE DB toolkit includes the components you need to deploy your OLE DB provider as a single tier, two-tier or three-tier standards-based solution in as little as a few days.

Key OLE DB Features

The SimbaEngine OLE DB toolkit provides two standards-based data interfaces – OLE DB and ODBC – for the effort required to implement just one.

The SimbaEngine OLE DB toolkit provides you with components you’ll need to quickly, easily and cost-effectively implement a full-featured OLE DB provider. Following the OLE DB SDK’s comprehensive documentation, you can choose to add an array of pre-defined functionality to quickly and easily implement an ODBC driver, gaining full OLE DB connectivity. SimbaEngine OLE DB SDK supports the latest data standard advancements to ensure the utmost interoperability with OLE DB and ODBC standards-based products in the marketplace.

  • Unicode Support – SimbaEngine OLE DB SDK provides Unicode support for character sets of all international languages. This allows your customers to access their data in virtually any language, resulting in the widest interoperability. Unicode capable OLE DB providers also improve performance and remove the restrictions inherent in Unicode and ANSI mapping.
  • 32- and 64-bit Support – SimbaEngine OLE DB SDK natively supports both 32-bit and 64-bit platforms, including Windows, Linux, Solaris, HP-UX, AIX and Mac OS. In addition, 32-bit and 64-bit platforms will interoperate across the client/server connection.
  • Support for SQL and Non-SQL Data Stores – SimbaEngine OLE DB SDK supports both SQL-enabled and non-SQL data stores. Non-SQL data stores can use Simba’s SQL Engine to provide SQL processing.
  • Collaborative Query Execution – SimbaEngine OLE DB SDK’s innovative Collaborative Query Execution allows your data store to execute the parts of the query for which it is designed and dynamically leave the rest of the query to be executed by Simba SQL Engine. Because Simba SQL Engine does not redundantly execute the same parts of the query as your data store, your SimbaEngine OLE DB SDK data driver delivers the full performance of your data store.
  • Pass-Down Processing – Table filters, joins and aggregations can be passed down to your data store for execution if your data store is optimized for those functions.
  • Maintainability & Extensibility – SimbaEngine OLE DB SDK uses the object-oriented paradigm, allowing you to extend features, as well as upgrade to newer versions with ease and predictability.
  • Scalar Functions – Support is provided for over 60 scalar and aggregate functions, in addition to allowing you to define your own custom functions.
  • Data Driver Samples/Template – SimbaEngine OLE DB SDK’s ODBC Quickstart and Ultralight Driver Templates are specially designed to provide you with sample code and sample data from which you can quickly build your custom ODBC driver.

 

Product FAQ

  • What is SimbaEngine SDK?

    SimbaEngine SDK is a Software Development Kit (SDK) for developing fully-featured, optimized ODBC Drivers, JDBC Drivers, ADO.NET Providers and OLE DB data connectivity for any SQL-enabled or non-SQL data store. SimbaEngine 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.

  • How do I build an ODBC Driver using SimbaEngine ODBC SDK?

    You can build a prototype ODBC Driver using SimbaEngine ODBC SDK within five days. Use our Quickstart sample 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.

  • How do I build a JDBC Driver, ADO.NET Provider or OLE DB Provider using SimbaEngine SDK?

    You can build a native JDBC Driver or ADO.NET Provider directly against your data store following SimbaEngine SDK’s comprehensive documentation.

    Alternatively, once you have developed an ODBC Driver using SimbaEngine ODBC SDK, you may choose to simply use the following additional components with the ODBC Driver to create either a JDBC Driver, ADO.NET Provider or OLE DB Provider.

    • Create a JDBC Driver by simply employing JDBC Client with SimbaServer.
    • Create an OLE DB Driver by simply employing OLE DB Client with SimbaServer.
    • Create an ADO.NET Data Provider by simply employing the ADO.NET Client with SimbaServer.
  • How long will it take to build my ODBC Driver with SimbaEngine ODBC SDK?

    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 ODBC codebase sample 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.
  • What applications can connect to an ODBC driver built using SimbaEngine ODBC SDK?

    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.

  • What SQL conformance level does SimbaEngine SDK provide?

    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 SDK fully supports Core DML SQL grammar, as well as many Extended grammars.

  • Does SimbaEngine SDK provide support for dynamic schemas and metadata?

    Unique to SimbaEngine SDK, you can build an interface to derived data, dynamic metadata and “in-memory” data. SimbaEngine SDK is the only toolkit that gathers this information at query time, enabling you to determine and support changes to your schema.

  • Is SimbaEngine SDK client-server enabled?

    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.

  • What about my future connectivity requirements?

    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, ADO.NET Provider or OLE DB Provider in the future. SimbaEngine SDK is a complete toolkit 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.

  • How can I take advantage of my existing database's performance strengths?

    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.

    Additionally, if you have support for indexes within your data source, the SimbaEngine SDK can make use of these indexes to speed up the performance of many different types of SQL operations with little additional work.

  • What is the cost of ownership?

    After your ODBC Driver, JDBC Driver, ADO.NET Provider or OLE DB Provider is complete, SimbaEngine SDK continues to save you development time. When you build a data driver using SimbaEngine SDK, you don’t have the headache of rewriting your driver every time specifications change. 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.

  • How can I evaluate SimbaEngine SDK?

    The only true way to effectively evaluate our software is to evaluate it in your environment. We provide you with our complete SimbaEngine 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 SDK.

  • How can I obtain more information about SimbaEngine SDK?

    For more information about SimbaEngine SDK, contact us.

FREE Trial

ODBC

A password will be emailed to you.

Contact Sales

+1 (604) 633-0008
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar