![]() When this is done, you’ll get a window that looks similar to what we’ve seen in the ODBC Manager software. The same can be accomplished by doing Data -> Get External Data -> New Database Query from the toolbar. In the above example, Couchbase Server would be running on your local machine.Ĭreate a new Microsoft Excel spreadsheet and click Database from the Data tab. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |