SimbaEngine ODBC SDK 7.6

Use these quicklinks, or simply scroll down

How do I build an ODBC Driver using SimbaEngine SDK?

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

How long will it take to build my ODBC Driver?

What ODBC level does SimbaEngine SDK support?

What SQL conformance level does SimbaEngine SDK support?

Does the SQL Engine SDK include an optimizer?

Does SimbaEngine SDK provide support for dynamic schemas and metadata?

Is SimbaEngine SDK client-server enabled?

What about my future connectivity requirements?

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

What is the cost of ownership?

How can I evaluate SimbaEngine SDK?

How can I obtain more information about SimbaEngine SDK?

How do I build an ODBC Driver using SimbaEngine SDK?

You can build an ODBC Driver using SimbaEngine SDK in 10 easy steps. Use our Quickstart driver and Quickstart guide to accelerate the development process according to the requirements of your data store, testing intermittently with our QuickTest tool. You can build a prototype read-only ODBC Driver in four steps. Add write functionality to your ODBC Driver in just two more steps. Then prepare your ODBC Driver for distribution and, if you want, add advanced functionality if necessary.

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

Once you have completed development of an ODBC Driver using SimbaEngine SDK, simply use the following additional components with the ODBC Driver to create either a JDBC Driver, OLE DB Driver, or an ADO.NET Data Provider:

• Create a JDBC Driver by simply employing our JDBC Client with SimbaServer.
• Create an OLE DB Driver by employing an OLE DB / ODBC Bridge.
• Create an ADO.NET Data Provider by employing an ODBC.NET Data Provider from Microsoft.

How long will it take to build my ODBC Driver?

Our ODBC SDK enables our customers to develop a proof-of-concept, read-only ODBC Driver in less than a week, and a complete, fully-optimized read-write ODBC Driver with push-down functionality within three to six months. Building a high-performance, commercial quality ODBC connectivity solution is done quickly and easily using our comprehensive SDK, which includes:

• A fully-operational sample code-based driver to quickly and efficiently learn how to code an ODBC Driver;
• A Simba "Quickstart" template to quickly and easily connect SimbaEngine SDK to your non-SQL data source, 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;
• Simba's comprehensive test tools and procedures;
• Ready to use client-to-server networking components, available to quickly and easily extend your solution.

What ODBC level does SimbaEngine SDK support?

SimbaEngine SDK fully supports the ODBC 2.5 specification.

What SQL conformance level does SimbaEngine SDK provide?

ODBC Version 2.5 provides 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 the Minimum SQL grammar, as well as many Core and Extended grammars.

Does the SQL Engine include an optimizer?

SimbaEngine SDK includes a cost-based SQL Query optimizer.

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 ODBC SDK 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, Simba's network transport layer and a server component. The components are combined with the ODBC Driver you develop using our SDK; no network gateway or client-side Windows 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 optimal performance for data access over the LAN, WAN, or Internet. Most importantly, SimbaEngine SDK C/S provides strong performance through ODBC call optimizations, caching, blocking and aggressive data compression to maximize throughput and minimize network traffic.

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, OLE DB Driver, or an ADO.NET Data Provider in the future. Our SimbaEngine SDK is a complete ODBC SDK for building an ODBC Driver to provide both ODBC and JDBC, as well as 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 Push down functionality.

SimbaEngine SDK's unique Push down functionality takes full advantage of your database's special processing capabilities and strengths by cooperatively enabling your database to execute certain types of queries directly. The resulting ODBC solution will exhibit high performance in application-critical areas. Push down Joins improve optimization, if data is structured in such a way that it is quicker to join tables using your proprietary DBMS. If your database is located on a different server, you can also use this feature to reduce the amount of network traffic by performing the join on the server. Push down Filters increase performance given the right data source; entire tables do not have to be carried over the network for SimbaEngine SDK to perform comparisons. Push down Extensible Predicates allow support for non-ODBC predicates, and allows SimbaEngine SDK to push down this predicate to the DBMS. Push down Stored Procedures allow users to take advantage of DBMS functionality not supported through ODBC and the SQL language.

What is the cost of ownership?

After your ODBC Driver, OLE DB Driver, JDBC Driver, or ADO.NET Data Provider is complete, SimbaEngine SDK continues to save you development time. When you build a driver using SimbaEngine SDK, you don't have the headache of rewriting your driver every time the ODBC specification changes. We provide our customers with updates that add functionality to your driver. We provide the upgrade path to new versions of the ODBC specification, as well as to new technologies, such as JDBC, OLE DB, XML data streaming and ADO.NET.

How can I evaluate SimbaEngine SDK?

The only true way to 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.

How can I obtain more information about SimbaEngine SDK?

For more information about SimbaEngine SDK, contact us.