Couchbase Analytics & N1QL Reporting - AgenticBI Integration

AgenticBI enables data discovery, query, aggregation, visualization and reporting automation from Couchbase along with other unstructured and structured datasources.

  • Native Couchbase Analytics
  • Supports N1QL and Couchbase Analytics Service
  • Blend Couchbase Buckets, other NoSQL or Relational Data Sources
  • Natural Language BI on Couchbase
  • Embed Analytics into Your Couchbase Powered Data Applications
  • Monitor datasets for conditions you specify and automatically send notifications or push data to other systems when those conditions are met.

Overview

  1. Connect, extract and transform data from your Couchbase database, using one of the following options:

    a. Through our UI to connect directly.

  2. Visualize and Automate your Reporting instantly.

UI Based Approach

Connecting

  1. Log in to AgenticBI and select Queries from the left sidebar.
  2. Click on the New Datasource + button and select Couchbase from the list of datasources.
  3. After navigating to the New Datasource page, either use the pre-configured settings into AgenticBI's own demo Couchbase database or follow the prompts and configure the following details to set up connectivity to your own Couchbase database:

    a. Datasource Name: Enter a name for your datasource
    b. Couchbase Capella: Check if using Couchbase Capella (cloud)
    c. Host Name: Enter the host name to connect to
    d. Bucket Name: Enter the bucket name
    e. User: Enter the User ID to connect
    f. Bucket/User Password: Enter the password to connect to the bucket
    g. Scope: Scope name for N1QL queries (Required if using Couchbase Capella)
    h. Database Properties: Additional database connection properties. For example, ssl=true

  4. Click on the Test Connection to confirm successful connection to the Couchbase database, hit the Save button, and start Querying.

Couchbase Connect

Query

Set up Query using a visual builder or query editor

Visual Builder

After connecting to the Couchbase datasource, AgenticBI will pull out a list of collections along with field samples.

Step 1: After connecting to the Couchbase datasource, AgenticBI will pull out a list of buckets along with field samples. Using these buckets, you can automatically generate queries through our visual builder in a no-code environment by either dragging and dropping fields or making your selections through the drop-down.

Couchbase Data Discovery

Step 2: Define data execution strategy by using any of the following two options:

  • Direct Execution: Directly execute the Query on the original Datasource, without any storage in between. In this case, when a widget is displayed, it will fetch the data in real time from the underlying Datasource.

  • Non-Direct Execution: For non-direct queries, results will be stored in AgenticBI's Elastic Store. Benefits include- long-running queries, reduced load on your database, and more.

Non-direct execution can be put into action if you choose to run the Query once or at scheduled intervals. For more information, feel free to check out this documentation- Defining Data Execution Strategy

Couchbase Data Strategy

Step 3: Click on the Preview button to analyze the results of your Query and fine-tune the desired output, if required.

Couchbase Data Discovery

The result of your Query is called Dataset. After reviewing the results, name your dataset and then hit the Create & Run button.

Create and Run

Query Editor

A versatile text editor designed for editing code that comes with a number of language modes including Couchbase Query Language (CQL) and add-ons like Cloud9QL.

Create and Run

Step 1: Write your query using Couchbase N1QL (CQL) in the Query Editor. Optionally, apply Cloud9QL on top for additional transformations.

Step 2: Define data execution strategy by using any of the following two options:

  • Direct Execution: Directly execute the Query on the original Datasource, without any storage in between. In this case, when a widget is displayed, it will fetch the data in real time from the underlying Datasource.

  • Non-Direct Execution: For non-direct queries, results will be stored in AgenticBI's Elastic Store. Benefits include- long-running queries, reduced load on your database, and more.

Non-direct execution can be put into action if you choose to run the Query once or at scheduled intervals. For more information, feel free to check out this documentation- Defining Data Execution Strategy

Couchbase Data Strategy

Step 3: Click on the Preview button to analyze the results of your Query and fine-tune the desired output, if required.

Data Strategy MysqlDB