SimbaEngine X increases developer productivity and allows you to build a custom ODBC driver in as few as five days.

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

The SimbaEngine X SDK provides:

  • Speed of development. Develop a driver proof-of-concept in just five days.
  • Flexibility. Deploy your driver as a client-side, client-server or cloud solution.
  • Extensibility. Connect your applications to any data source, be it SQL, NoSQL or proprietary.
  • Proven. Partners like Cloudera, Microsoft, Teradata, SAP, Hortonworks and MapR embed SimbaEngine-developed drivers in their own products.
  • Leading standards support. SimbaEngine X was the first in the industry to support ODBC 3.8 and JBDC 4.2, and as the developers of ODBC are on top of new standards.

How It Works

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

Technology

Data Source type

Deployment Model


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

What’s New In SimbaEngine X SDK

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.

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.

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:

  • Exact Numeric Precision enhancements
  • Support for data compression of retrieved data
  • Sample driver improvements on Mac OS X
  • Performance improvements to C++ SQL Engine
  • JDBC 4.2 compliance
  • Support for Xcode 7.2, Visual Studio 2015, and Windows 10
  • SimbaClient and SimbaServer performance and configuration improvements
  • Improved Makefiles
  • Max OS X Installer

Features

Best-in-Class Standards Support

  • 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
  • Kerberos support

Flexible and Extensible

  • 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
  • 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 driver 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 3.8 Support – SimbaEngine X supports the ODBC 3.8 specification, plus 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 behaviors 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, plus 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.

Specifications

Stand-alone Data Driver and Server Platforms

  • All SimbaEngine X components support 32- and 64-bit versions of Windows, Linux, Solaris, AIX, HPUX, and 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 SDK

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

Download Now 30 Days Free Trial

Questions? Ready to Buy?
Let's talk.

We'll get back to you within the next business day.

Evaluation and Sales Support
If you are evaluating our drivers or our SimbaEngine X SDK, our Sales Engineers would be happy to assist you. If you are ready to buy or you require licensing information, please complete the form provided, or contact us by email or phone:
+1-604-633-0008 x2 or connectivity@magnitude.com

Customer Technical Support

If you are a customer, please use our Magnitude Customer Support Portal