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

Introducing… Vora.

We just passed Labour Day so it’s back to the grind for everyone. And what better way to start September than with a new SQL-on-Hadoop engine. It’s Vora, courtesy of SAP. There’s already some detail available though my contacts at SAP have been more terse to date. http://www.bluefinsolutions.com/blogs/john-appleby/september-2015/the-sap-hana-vora-faq http://go.sap.com/docs/download/2015/08/f63628c9-3c7c-0010-82c7-eda71af511fa.pdf It was built by the same team Read the full article

Couchbase ODBC and JDBC Connectivity Solutions – RC now available

Today, Couchbase announced the release of Couchbase Server 4.0 Release Candidate. In conjunction with this release, Simba and Couchbase are happy to announce the availability of Release Candidates for the ODBC and JDBC connectivity solutions. Cihan, Director of Product Management at Couchbase, talked about how Couchbase’s query language N1QL essentially adds both the SQL and Read the full article

Remote Data Access on Mobile Devices: Overview; Best Practices

Remote data access on mobile devices presents developers and users with a number of unique challenges not found in server or desktop environments. Unreliable network connections, battery life optimization, and security implications are the major factors that need to be considered by developers and end users. This post gives a brief overview of these issues and offers some best practices.

What Today’s SAP Analytics-Simba Announcement Means: Seamless ODBC Connectivity Paired with Powerful BI

Today, Simba announced that its connectivity platform has been licensed by SAP for use with SAP’s Analytics suite. The agreement is comprehensive–On the analytics side, the deal covers SAP’s entire Analytics Division line of products. Quoting today’s press release: Through this agreement, Simba extends unlimited licensing of the drivers to groups within SAP in support Read the full article

Setting up a Virtual Private Cloud on AWS: Our experience

35 days. As part of benchmarking our ResultSet compression protocol, we wanted to set up our own private network on AWS. 35 days. That’s the number of working days it took for us to get a working virtual private cloud (VPC) on AWS. Why so long you ask? Great question! This post will describe some Read the full article

New Case Study: Why Couchbase Chose Simba ODBC and JDBC Drivers for Couchbase Server

Simba ODBC, JDBC Connectivity Makes it Easy to Connect Any Data Source to Leading NoSQL Database Couchbase delivers Couchbase Server, the high-performance, open-source NoSQL distributed database. Developers around the world use Couchbase to build enterprise web, mobile, and IoT applications that support massive data volumes in real time. Couchbase is also the developer of N1QL, Read the full article

Guest Post: Connecting to Salesforce Data Through SAP BusinessObjects with an ODBC Driver

Mitesh Shah is a senior Business Intelligence consultant for Decision First Technologies, a BI consulting firm and SAP gold partner. Shah recently evaluated ODBC connectors for Salesforce data access via SAP BusinessObjects from different ODBC driver vendors. His assessments are candid and thorough. In the end, he endorsed the native ODBC driver that comes with SAP BusinessObjects, an Read the full article

ODBC Driver Testing and Validation for Tableau BI

In order to build engaging visual analytics that help people understand their data, Tableau BI software relies on an ODBC driver to provide a broad set of capabilities. Simba ODBC drivers have been bundled and shipped with Tableau BI software since Tableau version 8.2. Simba engineers know that seamless connectivity is key to an efficient Read the full article