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

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

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. Windows This article does a Read the full article

Getting Started with the Simba Couchbase ODBC Driver

This guest post is by Tim Wong of Simba Technologies partner Couchbase. ODBC has been around since the early 1990’s as a standard API to access various data sources, traditionally against structured data sources like relational databases.  SIMBA Technologies recently released an ODBC Driver for Couchbase; this has opened up Couchbase to a number of third Read the full article

Simba Couchbase ODBC Driver & Couchbase Server 4.1

Simba computer scientist Mike Howard authored this blog post on N1QL data manipulation and ODBC connectivity for Simba Technologies partner Couchbase. N1QL DML N1QL data manipulation support makes it easy to insert, update, and delete JSON data, without the overhead of having to read the document first. These N1QL statements can perform an operation across an entire Read the full article

How to Implement Custom SQL Scalar Functions in an ODBC Driver

The SimbaEngine SDK™ allows you to build a custom ODBC driver with which you can connect your data source to any ODBC application. The SQLEngine within the SimbaEngine SDK is flexiblie, and allows you to implement your own custom scalar and aggregate functions for your data source. In many new data sources, new functionality is Read the full article

How to Setup Couchbase as a Linked Server in Microsoft SQL Server

Couchbase Server is a fast and scalable NoSQL solution. It can reduce the cost and complexity of building technology stack that scales from a mobile device to a data center supporting millions of users. But unless you are a startup building a technology stack from scratch, implementing Couchbase will require integration with existing infrastructure. It Read the full article

Making Data Work at Strata + Hadoop World NYC 2015

This year’s Strata + Hadoop World in New York City was all about “Making Data Work.” The key word: “Work,” which epitomized Strata 2015’s pronounced “business-y” tone. Perhaps it has something to do with location (New York compared to say, “perhaps-slightly-more-distanced-from-enterprise-reality” locales like Silicon Valley or Las Vegas), but the focus more likely represents a Read the full article

Simba continues to lead with ODBC and JDBC for even more Big Data and NoSQL data sources

I am excited to be at the Strata Hadoop World conference in New York this week. Today, Simba announced ODBC and JDBC drivers for products like Microsoft SQL Server, Amazon redshift, and Amazon DynamoDB. Although we officially announced these drivers today, some of them, like the ODBC Driver for Microsoft SQL Server, have already been Read the full article

Multidimensional data analytics with Teradata OLAP

In today’s data driven world, analyzing data is key to success.  Analyzing data across multiple dimensions has always been an important concept and one of the major tools to do this has always been Microsoft Excel Pivot Tables.  To support multidimensional data analytics with pivot tables requires the ability to model and aggregate data.  Traditional Read the full article