fbpx

Custom ODBC and JDBC Driver SDK for Any Data Source

Reduce time-to-market, development cost and risk for your custom ODBC and JDBC drivers with the Simba SDK

Current Versions 10.2.1
Simba SDK Custom ODBC JDBC Driver

The Simba SDK increases developer productivity and allows you to build custom ODBC and JDBC connectors in as few as five days.

The same Simba Software Development Kit (SDK) that our engineering team uses to develop Simba connectors is available for you to develop your custom ODBC/JDBC connector for any SQL-enabled or NoSQL data source. With Simba SDK, you reduce cost, complexity, risks, and time to market compared to developing a connector from scratch.

The Simba SDK provides:

Custom ODBC Driver Speed of development

Speed of development

Develop a connector proof-of-concept in just five days.

Custom ODBC Driver Flexibility

Flexibility

Deploy your connector as a client-side, client-server or cloud solution.

Custom ODBC Driver Extensibility

Extensibility

Connect your applications to any data source, be it SQL, NoSQL or proprietary.

Application compatibility fot custom ODBC Driver

Application compatibility

Major data applications like Tableau, Power BI, Alteryx and Informatica embed Simba-developed connectors in their own products.

Custom ODBC Driver developer friendly

Developer Friendly

Sample connectors for SQL capable and non-SQL capable with full source code.

Proven Quality Custom ODBC Driver

Proven

Partners like Cloudera, Microsoft, Teradata, SAP and MapR embed Simba-developed connectors in their own products.

How it Works

The Simba SDK provides you with a complete set of components to quickly, easily and cost-effectively implement the connector that meets your data connectivity requirements. The SDK includes all the components you need to deploy your ODBC, JDBC, ADO.NET, or OLE DB connector as a single tier or client/server, standards-based solution as quickly as 5 days. Using our comprehensive documentation, you can include an array of pre-defined functionality to easily deploy a fully optimized connector ideally suited to your specific requirements.

Simba SDK Custom ODBC Driver

Features

Simba SDK Overview

Best-in-Class Standards Support

  • ODBC 3.8 support, including full asynchronous execution.
  • JDBC 4.3 and 4.2 support
  • ADO.NET support
  • OLE DB support
  • Certified Tableau Integration
  • Kerberos support

Flexible and Extensible

  • Flexible collation support: Filter and sort string data in any order that your data store supports
  • Auto Configuration of Connector Managers: Save your customers’ setup time for different Connector Managers
  • Custom aggregate function support: If an aggregate function is not supported by default, add support for it via your data source
  • ODBC 3.8 C Data Type Extensibility
  • Support for dynamic schema

SQL Engine Features

  • Full custom scalar function support: If a scalar function is not supported by default, you can easily implement
  • Data Manipulation Language (INSERT/UPDATE/DELETE)
  • Data Definition Language (CREATE/DROP)
  • Advanced performance capabilities. Pass-down SQL processing to your backend (i.e. Joins, filtering, aggregation, etc.)

Productivity

  • Quickstart and ultralight connector samples/templates and guide
  • Responsive customer support

Other Features

  • Full Unicode support for data, metadata and API parameters
  • Native support for 32-bit and 64-bit operating systems
  • Supports client-server architectures
  • Fully localizable error messages
  • Ability to fully rebrand Simba Clients

ODBC

  • ODBC 3.8 Support
    Simba SDK supports the ODBC 3.8 specification, plus custom metadata and attributes for greater flexibility.
  • Unicode Support
    Simba 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 connectors also improve performance and remove the restrictions inherent in Unicode and ANSI mapping.
  • 32- and 64-bit Support
    Simba SDKnatively supports both 32-bit and 64-bit platforms, including Windows, Linux, Solaris, HP-UX, AIX, Mac OS, and iOS. In addition, 32-bit and 64-bit platforms will interoperate across the client/server connection.
  • Support for SQL and Non-SQL Data Stores
    Simba 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 Simba ODBC to provide ODBC 3.8 processing.
  • Collaborative Query Execution
    Simba 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 the Simba SQL Engine. Because Simba SQL Engine does not redundantly execute the same parts of the query as your data store, your Simba ODBC SDK data connector 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, aggregations, group bys, order bys, distincts, and projections can be passed down to your data store for execution if your data store is optimized for those functions.
  • Stored Procedures
    Simba 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 connector can choose to implement behaviors different from those provided by the SDK.
  • Custom Data Converters
    Your ODBC connector 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.80 are fully supported.
  • Maintainability & Extensibility
    Simba 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 connector can be localized.
  • Data Connector Samples/Template
    Simba SDK quickstart and ultralight connector templates are specially designed to provide you with sample code and sample data from which you can quickly build your custom ODBC connector.

JDBC

  • Fully Java Development Environment
    Simba SDK fully supports a native Java development environment, including pure Java SQL Engine. Choose to implement your JDBC connector in the environment that best suits you.
  • JDBC 4.3 and 4.2 Support
    Simba SDK supports the JDBC 4.3 and 4.2 specifications, plus custom metadata and attributes for greater flexibility.
  • JDBC Type 3 and Type 4 Support
    Simba SDK can be used to develop both pure Java Type 3 or Type 4 data connectors.
  • Unicode Support
    Simba 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 connectors also improve performance and remove the restrictions inherent in Unicode and ANSI mapping.
  • Support for SQL and Non-SQL Data Stores
    Simba 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
    Simba SDK 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 Simba SDK data connector delivers the full performance of your data store.
  • Pass-Down Processing
    Table filters, joins, aggregations, group bys, order bys, distincts, and projections can be passed down to your data store for execution if your data store is optimized for those functions.
  • Stored Procedures
    Simba SDK supports Stored Procedures.
  • Scalar Functions
    Support is provided for over 60 scalar and aggregate functions.
  • Maintainability & Extensibility
    Simba 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 Simba SDK and specific to the JDBC connector can be localized.
  • Data Connector Samples/Template
    Simba SDK quickstart and ultralight connector templates are specially designed to provide you with sample code and sample data from which you can quickly build your custom JDBC connector

ADO.NET

  • 100% Managed ADO.NET Data Provider
    Simba 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
    Simba 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.
  • Maintainability & Extensibility
    Simba 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 Simba SDK and specific to the ADO.NET provider can be localized.
  • Data Connector Samples/Template
    Simba SDK Quickstart Connector 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.

OLE DB

  • Unicode Support
    Simba 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.
  • Support for SQL and Non-SQL Data Stores
    Simba 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
    Simba SDK 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 Simba SDK data connector 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
    Simba 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 Connector Samples/Template
    Simba SDK ODBC quickstart and ultralight connector templates are specially designed to provide you with sample code and sample data from which you can quickly build your custom ODBC connector.

Specifications

Stand-alone Data Connector and Server Platforms

  • All Simba SDK components support 32- and 64-bit versions of Windows, Linux, Solaris, AIX, and Mac OS X.

Client Platforms

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

Development Software

  • Windows: Microsoft Visual Studio 2015/2017/2019/2022.
  • UNIX: For all platforms, the native compiler is supported.
  • Linux: GNU Compiler environment.
  • Mac: Xcode Clang 10.x/11.x/12.x/13.x

BI Tool Support

  • Any ODBC-capable application, including Microsoft Office, MicroStrategy, Tableau, PowerBI, Sisense, QuikView and SAP Business Objects Crystal Reports, etc.

Documentation

User Guides, Release Notes and FAQs.

Learn More

Ready to buy? We're here to help!

If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be
happy to assist you.