Ready to get started?

Learn more about the CData ODBC Driver for Couchbase or download a free trial:

Download Now

Connect to and Query Couchbase Data in QlikView over ODBC

Create data visualizations with Couchbase data in QlikView.

The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. This article outlines simple steps to connect to Couchbase data and create data visualizations in QlikView.

Connect to Couchbase as an ODBC Data Source

If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

To connect using the Login method, set User, Password, and Server to the credentials for the account and the address of the server you want to connect to.

Populate a Chart with Couchbase Data

The steps below supply the results of an SQL query to a visualization in QlikView. In this article, you will create a bar chart with the query below:

SELECT Contact.FirstName, SUM(Account.TotalDue) FROM Contact, Account GROUP BY Contact.FirstName
  1. In the toolbar, click the Edit Script button and add the connection.
  2. On the Data tab, select ODBC in the Database menu and click Connect.
  3. Select the DSN in the resulting dialog. A command like the following is generated: ODBC CONNECT TO [My DSN];
  4. Click Select to build the query in the SELECT statement wizard. Or, you can enter the query directly into the script with the SQL command.
  5. Close the script editor and reload the document to execute the script.
  6. Click Tools -> Quick Chart Wizard. In the wizard, select the chart type. This example uses a bar chart.
  7. Select FirstName in the First Dimension menu.
  8. Click the summary function you want and select TotalDue in the menu.
  9. Finish the wizard to generate the chart.

 
 
Downloads