SQL Engine just got even better in SimbaEngine X SDK, v10.1.1

We believe in continuously investing in our SimbaEngine SDK software, to provide benefit for our valued customers.  In our latest release, SimbaEngine X SDK, v 10.1.1, we have focused on improvements to our Simba SQL Engine. The Simba SQL Engine is a high-performance, standard-compliant SQL parser and execution engine.  We designed it to allow our Read the full article

ODBC and JDBC Driver development gets easier with SimbaEngine X SDK v10.1

ODBC and JDBC Driver development gets easier with SimbaEngine SDK v10.1, the next minor release of our ODBC and JDBC driver development environment.  This SDK minor release contains several features designed to make life easier for developers who use our SDK to build drivers.  In addition, there are security, quality, and performance improvements. INI configuration file on Windows Read the full article

Benefits of Java SQL Engine in SimbaEngine X

Today we have released SimbaEngine SDK X, v 10.0.6, the next minor release of the SimbaEngine X SDK, containing the new Java SQL Engine. The Simba SQL Engine is a high-performance, standard-compliant SQL parser and execution engine.  It is designed to allow our customers to build drivers for data sources that are not fully SQL Read the full article

Performance Improvements in SimbaEngine X SDK, v.10.0.5

In SimbaEngine X, v.10.0.5, we are pleased to announce a significant performance optimization in our support for equijoins, the most commonly used means of aggregating data from two different tables both in SQL and NoSQL data sources. The SQL Engine feature in SimbaEngine SDK is used to convert standard SQL to your data source’s native Read the full article

Simba Joins the Magnitude Software Family

Big news today! I’m happy to announce that Simba Technologies is now the newest member of the growing and global Magnitude Software. We join a leading provider of enterprise information management (EIM) software and bring our standards-based relational and multi-dimensional data connectivity solutions with us. With the joint possibilities on the horizon, it’s a truly Read the full article

ODBC Escape Sequence Parser in SimbaEngine SDK

ODBC and JDBC specifications define escape sequences to standardize syntax for the data source-specific features, such as timestamps, joins, LIKE predicates, scalar functions and procedure calls. Escape sequences simplify the data consumer application logic by allowing them to use the same syntax for accessing different data sources which may not fully support the SQL standard. Read the full article

Fine-Tune your Custom ODBC Driver with Tableau TDC File

Tableau has an experimental feature that allows customers to fine-tune parts of their ODBC data connection, significantly improving performance during the execution of Tableau’s complex SQL statements. For example, customers can define the SQL statements in which a schema identifier can be used, or the level at which their data source conforms to the SQL Read the full article

SQL and N1QL in Harmony: Collaborative Query Execution in Simba Couchbase Drivers

Structured Query Language (SQL) was originally designed as an intuitive query language for relational data stores. NoSQL, relatively nascent in comparison, still requires compatibility with SQL as many BI tools and applications understand it. Couchbase supports its own query language, N1QL, which extends SQL for querying JSON documents stored in Couchbase Server. The Simba Couchbase Read the full article

Usability and Performance Advances in Couchbase Server 4.5

This week Couchbase launched the latest version of Couchbase Server, a distributed, document-oriented NoSQL database with an emphasis on performance, scalability and availability. Version 4.5 brings a number of significant advances to querying, performance tuning, and manageability. As a technology partner, Team Simba has been working with beta & GA candidate build of the server, and we are very Read the full article

Introducing SimbaEngine X: ODBC and JDBC driver development environment

The Simba Engineering team has been hard at work on the new and vastly improved SimbaEngine X —the engine that powers all Simba’s ODBC and JDBC drivers, and numerous drivers built by our partners. SimbaEngine X is the most robust, feature-rich, and easy-to-use ODBC & JDBC driver development environment that has been validated and endorsed Read the full article

Connecting QlikView to an Amazon Redshift cluster

With the introduction of the Amazon Redshift service, data analysts get access to a fully managed petabyte-scale data warehouse service without the headaches of its provisioning and administration. In this blog post and accompanying video, I will walk you through the simple steps to connect QlikView Desktop to Amazon Redshift using the Simba ODBC driver for Read the full article

Exploring MongoDB data in Qlik Sense using Simba ODBC Driver

Simba’s MongoDB ODBC Driver makes it easy to explore your MongoDB data in Qlik Sense.  This is a simple 3 step process: install, configure, explore! Follow the steps below or watch the video walk-through. 1. Install To get started: Set up and deploy a MongoDB instance Get an evaluation version of the Simba MongoDB driver Read the full article

The Second Annual Simba Partner Summit

We have just wrapped up our second annual Simba Partner Summit in San Jose. The event brought together industry leaders from Business Intelligence, data storage, processing, and SaaS Line of Business applications. The audience included our partners from Aerospike, Alteryx, Amazon, AtScale, Couchbase, DataStax, Dremio, Hortonworks, Informatica, Magnitude Software, Microsoft, Nielsen, Qlik, Salesforce, SAP, Tableau Read the full article

Customizing MongoDB Schemas with the New Simba ODBC Driver for MongoDB

In a previous post, I discussed the automatic schema generation capabilities of Simba’s new MongoDB driver. Most of the time this is perfectly adequate but there are some circumstances in which you may wish to provide the schema to the driver rather than having it generate a schema on the fly. This post will describe Read the full article

Why Leading BI Vendors Choose Simba ODBC Connectivity

This week’s unveiling of the latest MicroStrategy Analytics application reminds me again, how much did the landscape of analytical applications has changed. Just five years ago, not many analysts heard about that new “Hadoop thing”, and even less would think that a large and ever-growing share of their data would be stored in non-relational data Read the full article

Schema Generation with the New Simba ODBC Driver for MongoDB

A lot has changed in MongoDB since the last major release of the Simba MongoDB ODBC and JDBC drivers. Performance is a major focus area for the new release of Simba driver. Extensive query performance improvements have been realized through the use of the MongoDB Aggregation Framework and write performance has also significantly improved using Read the full article

SAP Data Services and the Salesforce SSL/TLS upgrade

Soon, Salesforce will be changing the versions of SSL/TLS connections which will be supported.  Connections at or below TLS 1.0 will not be supported.  For details on the Salesforce upgrade, including roll-out timeline and much more information, please see their Knowledge Article 000221207. To make sure that your Simba Salesforce Adapter will continue to connect Read the full article

Optimization of ODBC Data Retrieval with the SimbaEngine SDK

ODBC driver performance is an important concern, particularly when you’re using ODBC connectivity with popular BI tools such as Tableau. The SimbaEngine SDK has many ways to optimize data retrieval performance, and with version 9.5 of the SDK we added another internal API to further optimize cell retrieval from your data-store. To see how the new API Read the full article

ODBC Troubleshooting: How to Enable Driver-manager Tracing

Enabling tracing at the driver-manager level is a useful way to troubleshoot ODBC driver issues. In this article, I’ll explain how to enable tracing for each of the driver managers to help in ODBC troubleshooting tasks. You can choose from several driver managers, depending on the platform that you’re using. Jump to unixODBC Driver Manager Read the full article