simba_sdk_icon

SimbaEngine X
ODBC & JDBC Driver Development Environment

Reduce time-to-market, risks, and development cost for your custom ODBC, ADO.NET, OLEDB, and JDBC drivers

Current Version 10.0.1

Simba Technologies uses SimbaEngine X SDK to build all of its drivers, and now you can leverage SimbaEngine X to develop your custom ODBC/JDBC driver for any SQL-enabled or NoSQL data source while reducing the cost, complexity, risks, and time to market compared to developing driver from scratch. SimbaEngine X increases developers productivity and allows you to build a custom driver in as little as five days.

SimbaEngine X SDK is de facto standard for ODBC, OLE DB, ADO.NET, and JDBC driver development. SimbaEngine X based drivers are trusted by the major Hadoop distributions, leading NoSQL data sources, and BI vendors, such as Alteryx®, Altiscale®, Cloudera®, Couchbase®, Databricks®, Datastax®, Google®, Hortonworks®, MapR®, Microsoft®, Oracle®, Qubole®, SAP®, Splunk®, Tableau®, and Teradata®.

Why Use SimbaEngine X for ODBC & JDBC Driver Development?

  1. Easy to Use: Develop a driver in just five days. Reduce time to market, development costs, and uncertainty by building your driver on a solid foundation.
  2. Proven: Simba partners like Cloudera, Microsoft, Teradata, SAP, Hortonworks, and MapR embed SimbaEngine-developed connectivity drivers in their own products.
  3. Flexible: Deploy your driver the way you want, as a client-side, client-server, or cloud solution.
  4. Ground-breaking: SimbaEngine X is the first in the industry to support ODBC 3.8 and JDBC 4.2.
  5. Extensible: Connect your applications (Excel, Tableau, or any reporting or analytics tool) to any data source, be it SQL-enabled, NoSQL, or proprietary.
  6. Certified for Tableau: The Simba Certified-for-Tableau Custom ODBC Driver Program provides Tableau interoperability validation for your SimbaEngine X-developed custom ODBC drivers.

What’s New in SimbaEngine X?

This release introduces many new features and improvements resulting in 3 compelling new benefits:

  1. The new Java SQL Engine allows the creation of a pure Java JDBC driver. It provides a streamlined development experience and better performance. Pure Java development stack also allows for easier deployment and maintenance.
  2. The new wire protocol has been significantly enhanced making it over twice as fast as the Postgres wire protocol and gives you the fastest performance available to showcase the power of your data source with reduced development effort.
  3. Build one and get four. With SimbaEngine X, you can build one data store interface implementation and get ODBC, JDBC, ADO.NET, and OLEDB drivers with no extra effort. SimbaEngine X gives you the fastest time to market and significantly reduces development and maintenance costs.

Other new features and improvements include:

  1. Exact Numeric Precision enhancements
  2. Support for data compression of retrieved data
  3. Sample driver improvements on Mac OS X
  4. Performance improvements to C++ SQL Engine
  5. JDBC 4.2 compliance
  6. Support for Xcode 7.2, Visual Studio 2015, and Windows 10
  7. SimbaClient and SimbaServer performance and configuration improvements

SimbaEngine X 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, 4.1 and 4.2
  • 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

  • C++ or Pure Java Options
  • 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

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 X supports a wide variety of implementations to meet your project and system requirements. The SimbaEngine X toolkit includes all the components you need to deploy your ODBC, JDBC, ADO.NET, or 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 X toolkit provides you with a complete set of components to quickly, easily, and cost-effectively implement a full-featured driver. Following the SimbaEngine X’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 X 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 X 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 X supports the ODBC 3.8 specification, as well as custom metadata and attributes for greater flexibility.
  • Unicode Support – SimbaEngine X 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 X natively 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 – SimbaEngine X 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 – 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 the 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, 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 – 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.80 are fully supported.
  • Maintainability & Extensibility – SimbaEngine X 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 X 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 X fully supports a native Java development environment, including pure Java SQL Engine. Choose to implement your JDBC driver in the environment that best suits you.
  • JDBC 4.0, 4.1 and 4.2 Support – SimbaEngine X supports the JDBC 4.0, 4.1 and 4.2 specifications, as well as custom metadata and attributes for greater flexibility.
  • JDBC Type 3 and Type 4 Support – SimbaEngine X can be used to develop both pure Java Type 3 or Type 4 data drivers.
  • Unicode Support – SimbaEngine X 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 X 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 X 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 X 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 X data driver 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 – SimbaEngine X supports Stored Procedures.
  • Scalar Functions – Support is provided for over 60 scalar and aggregate functions.
  • Maintainability & Extensibility – SimbaEngine X 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 SimbaEngine X and specific to the JDBC driver can be localized.
  • Data Driver Samples/Template – SimbaEngine X 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 X 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 X 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 X 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 X 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 SimbaEngine X and specific to the ADO.NET provider can be localized.
  • Data Driver Samples/Template – SimbaEngine X 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 X 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 X 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 X 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 X 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 X 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 X 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 X
ODBC & JDBC Driver Development Environment

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

Contact Sales for purchase information

Name

Lastname

Email*

Message*

Product Features

  • ODBC 3.8 support, including full asynchronous execution
  • JDBC 4.2, 4.1 and 4.0 support
  • ADO.NET support
  • OLE DB Support
  • Certified 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 languages: English, German, French, Spanish, Italian, Japanese, Simplified Chinese, Traditional Chinese, Korean, Dutch, Russian, Portuguese, Swedish

Product Specifications


SimbaEngine X supports the following platforms and tools:

Stand-alone Data Driver and Server Platforms

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

Client Platforms

  • SimbaClient for ODBC supports the 32 and 64-bit versions of Windows, UNIX, Linux, Mac OS X, AIX, HPUX, and 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 2013/2015
  • UNIX: For all platforms, the native compiler is supported.
  • Linux: GNU Compiler environment.
  • Mac: Xcode Clang 5.x/6.x/7.x

Desktop Tool Support

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

Get SimbaEngine X
ODBC & JDBC Driver Development Environment

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

Contact Sales for purchase information

Name

Lastname

Email*

Message*