InfluxDB V2 Analytics & Time Series Reporting - AgenticBI Integration

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

Overview

  1. Connect, extract, and transform data from your InfluxDB V2, 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 New Datasource + button and select InfluxDB V2 from the list of datasources.
  3. After navigating to the New Datasource page, either use the pre-configured settings for AgenticBI's own demo InfluxDB V2 database or follow the prompts and configure the following details to set up connectivity to your own InfluxDB V2 database:

    a. Datasource Name: Enter a name for your datasource
    b. URL: Enter the URL to connect to the InfluxDBV2 instance
    c. API Key: Enter API Key to connect to InfluxDBV2 instance
    d. Org ID: Enter the unique identifier to identify the organization when making API calls and to control access to resources within the organization.
    e. Default Bucket: Enter the name of the bucket that a particular measurement belongs to
    f. Internal Datasource: Checking this option enables you to define datasource configurations here that are automatically synced with your agent.

  4. Click on the Save button and start Querying.

 InfluxDB Connect

Query

Step 1: Query using a visual builder or query editor

Visual Builder: After connecting to the InfluxDB V2 datasource, AgenticBI will pull out a list of tables along with field samples. Using these tables, 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.

 InfluxDB Connect

Tip: You can also write queries directly in the Query Editor, a versatile text editor that offers more advanced editing functionalities like InfluxDB2 Query support for multiple language modes, Cloud9QL, and more.

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.

 InfluxDB Connect

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

 InfluxDB Connect

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

 InfluxDB Connect