simba_sdk_icon

SimbaEngine SDK

Modular SQL Engine SDK for NoSQL and Relational data sources with ODBC, JDBC, ADO.NET and OLE DB compliant interfaces

Current Version 9.5.8

The 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 4.0, ADO.NET, native Unicode capability, and the industry’s widest support for 32-bit and 64-bit platforms (including OS X).

Why Use SimbaEngine SDK?

  • Easy to Use: Develop a driver in just five days.
  • Flexible: Deploy your driver the way you want, as a client-side, client-server, or cloud solution.
  • Proven: Simba partners like Cloudera, Microsoft, Teradata, SAP, Hortonworks, and MapR embed SimbaEngine-developed connectivity drivers in their own products.
  • 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.

SimbaEngine SDK Overview


  • Tableau

  • Excel

  • SAP Lumira

  • Power BI

  • Microstrategy

  • Other BI Tools

Simba connects you to any Business Intelligence Tool

ODBC

ODBC

  • ODBC 3.8
  • Full asynchronous support
  • Extensible SQL
  • C and CustomData Types
  • Big data drivers built using ODBC
JDBC

JDBC

  • JDBC 4.0 and 4.1
  • Savepoints Support
  • Batch Streaming Support
OLE DB

OLE DB

  • Supports OLE DB natively without bridges
ADO.NET

ADO.NET

  • .NET 3.5 with DDEX extensions for Visual Studio/MSAS/RS
  • Cartidge
  • Custom Data Types and Custom Schemas
Communication Layer

Communication Layer

  • High Perfomance Wire Protocol
  • SSL Encryption Support
  • Any Platform and Bitness Connects to Any Platform and Bitness
  • High Availability and Reliability

Deployment Options

  • Single Tier / Client / Monolothic
  • Multi Tier Cloud / Hosted / Client Server
Simba SQL Engine

Simba SQL Engine

  • SQL-92 with extensions
  • Custom scalar, aggregate functions
  • Joins
  • Subqueries
  • DISTINCT, ORDER BY, GROUP BY, HAVING, Etc
  • Collaborative Query Execution
Data Source Interface

Data Store Interface

  • Single Absctaction Layer Between Customer and Simba Layers
  • Available in C++, Java and C#
  • Object-Oriented Design
  • Easy to Extend or Customize
  • Well Documented and Easy to Understand
SQL
NoSQL
Big Data
Cloud Data

Any Data Source

  • Realtional - RDBMS
  • SQL Capable
  • NoSQL or Non-SQL capable
  • REST, Web service
  • Document
  • Object Based
  • Key Value
  • Graph
  • Big Data - Haddop

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.

Usage Scenarios

Technology
Data Source type
Deployment Model

Use your own protocol

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

SimbaEngine’s SDK supports a wide variety of implementations to meet your project and system requirements. The SimbaEngine toolkit includes all the components you need to deploy your ODBC|JDBC|ADO.NET|OLE DB driver as a single tier, two-tier or three-tier standards-based solution in as little as a few days. Key Features The SimbaEngine toolkit provides you with a complete set of components to quickly, easily and cost-effectively implement a full-featured driver. Following the SimbaEngine SDK’s comprehensive documentation, you can choose to add an array of pre-defined functionality to easily deploy a fully-optimized driver ideally suited to your data connectivity requirements.


  • Tableau

  • Excel

  • Spotfire

  • Power BI

  • Microstrategy

  • Other BI Tools

  • Open Office

  • SAP Lumira

  • Pentaho ETL

  • Talend ETL

  • Your Java Applciation

  • SQL Server Analysis Services

  • Integration and Reporting Services

  • Other Services

  • Excel

  • Access

  • SQL Server Analysis Services

  • Other Tools

Simba connects you to any Business Intelligence Tool

ODBC Interface
Simba Client
Simba Wire Protocol
Simba Server
Simba SQL Engine
Data Store Interface
Your customized code connecting your data store
to the SimbaEngine API, Implement in C++, Java or
C# in as few as 5 days
  • 'Big Data' data source
  • Propietary data source
  • ISAM data source
  • Flat Files data source
  • Object Oriented data source
  • XML data source
  • Unstructed data source
  • Cloud data source
  • Other data source


SimbaEngine SDK supports the latest data standard advancements to ensure the utmost interoperability with ODBC, JDBC, ADO.NET and OLE DB standard-based products in the marketplace.

ODBC

JDBC

ADO.NET

OLE DB

  • 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.
  • 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.
  • 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.
  • 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.

Get SimbaEngine SDK

Build a driver for: ODBC | JDBC | ADO.NET | OLE DB

Contact Sales for purchase information

Name

Lastname

Email*

Message*

Certification for Tableau - Custom ODBC Driver - Simba Technologies
Webinar: How to build an ODBC driver in just 5 days

Product Features

  • ODBC 3.8 support, including full asynchronous execution
  • JDBC 4.1 and 4.0 support
  • ADO.NET support
  • OLE DB Support
  • Tableau Integration
  • Bulk C++ API for extremely fast data retrieval
  • Fully flexible collation support: Filter and sort string data in any order that your data store supports
  • Auto Configuration of Driver Managers: Save your customers’ setup time for different 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
  • Full custom scalar function support: If a scalar function is not supported by default, then easily implement
  • Ability to fully rebrand Simba Clients
  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)
  • Support for dynamic schema
  • Full Unicode support for data, metadata and API parameters
  • 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, Mac OS X, AIX, HPUX, Solaris
  • SimbaClient for JDBC supports all client operating systems running a Java Virtual Machine (JVM) 1.6 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: Xcode Clang 5.x/6.x

Desktop Tool Support

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

Get SimbaEngine SDK

Build a driver for: ODBC | JDBC | ADO.NET | OLE DB

Contact Sales for purchase information

Name

Lastname

Email*

Message*