Of course, the host should match the actual host that your Couchbase Server resides on. With Couchbase Server running, from the Mac Terminal, run the following command: Creating Bucket Indicesīefore we connect to Couchbase Server via Excel, we must first create bucket indices to allow for running N1QL queries. ODBC Manager for Mac will detect the installed driver and allow you to configure what server and port to connect to via Microsoft Excel. If you’re using a recent version of Mac OS, you’ll need to download another piece of software to configure the just-installed driver. In this article, we’ll be using version 1. Start by downloading and installing the latest Simba ODBC driver DMG file for Mac OS. How exactly do you use these drivers? We’re going to look specifically at how to query data using the ODBC driver with Microsoft Excel for Mac and Windows. These drivers make it possible for data analysts using tools like Microsoft Excel and Tableau to quickly access data on Couchbase Server.
Last year we announced that Simba Technologies was buiding these ODBC and JDBC drivers for use with Couchbase. About a month ago, Simba Technologies announced that it had released developer previews of the ODBC and JDBC drivers.