![]()
#Actual technologies odbc manager driverThe full release of the ODBC driver coming up will have a feature to present a renormalized view of your data as virtual tables representing different parts of your documents. For this reason, if you\’re going to issue direct N1QL queries, it would be advisable to UNNEST ahead of time. This is because the result structure is based on the first document seen. You may notice that this only has one column for address but a few documents have two entries in their address array. For example, if you SELECT * FROM beer-sample WHERE type=\’brewery\’, you will see several columns resulting from flattening in the driver: \”geo|accuracy\”, \”geo|lat\”, \”geo|lon\”, and \”address\”. If you don\’t unnest, the driver will attempt to do this for you when it receives the result. In the Beta version of the driver, you can issue N1QL queries using the UNNEST operation to get a result set that looks like what you want. As such, the ODBC driver does not have access to them either. Assuming the travel-sample bucket is installed and has the appropriate indexing configured, enter the following query:Īs Cihan has said, N1QL isn\’t able to query the type of views you\’re talking about (created through the admin console). Be aware that the more data you plan on returning, the longer it will take to execute. Querying Using a N1QL QueryĬlick the SQL button and enter a query of your choosing. You can choose the default and click Next or specify some sorting.Ĭhoose Return Data to Microsoft Excel and click Finished.Īll data based on the criteria entered will be pulled into the spreadsheet. #Actual technologies odbc manager how toThe next screen of the wizard will let you choose how to sort the data by default. If you want to return all rows, just leave the default and click Next. The next screen of the wizard will let you add any query logic. With the wizard started, first add the desired columns to your query, or all of them and click Next. Choose a default table for the datasource if testing the connection is successfulĪt this point you can proceed to following the query building wizard or click cancel to do things on your own.If Couchbase Server is running locally, use 127.0.0.1 otherwise enter the IP of your remotely running server.Name your connection something like Simba Couchbase.If your datasource hasn’t already been added, choose the option and you’ll be required to fill out four items. Assuming the travel-sample bucket is installed and has the appropriate indexing configured, enter the following query:ĬREATE PRIMARY INDEX def_primary ON ` travel - sample ` USING gsi Ĭreate a new Microsoft Excel spreadsheet and click From Other Sources from the Data tab. Querying Using a N1QL QueryĬlick the SQL View tab and enter a query of your choosing. You now have two options for querying data. When connected, you should see a list of buckets found on your Couchbase Server. If testing is successful, go ahead and click the Ok button to connect and start analyzing data. This is the same username and password used to connect to your Couchbase Server. Click the Test button and you’ll be prompted to enter a username and password. If for some reason the previously created driver entry doesn’t show up, go ahead and create it again. 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. #Actual technologies odbc manager softwareIf 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. #Actual technologies odbc manager for macStart 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. #Actual technologies odbc manager driversThese 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 |