InfluxDB Analytics & Time Series Reporting - AgenticBI Integration

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

Overview

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

    a. Datasource Name: Enter a name for your datasource
    b. Host Name: Enter the host name to connect to
    c. Database Name: Enter the name of the database
    d. User ID: Enter the User ID to connect
    e. Password: Enter the password to connect to the bucket

  4. Click on Save button and start Querying.

 InfluxDB Connect

Query

Set up Query using a visual builder or query editor

Visual Builder

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

Step 1: After connecting to the InfluxDB 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.

Query InfluxDB

Tip: You can also write queries directly in the Query Editor, a versatile text editor that offers more advanced editing functionalities like Influx Query Language (InfluxQL), 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

Data Strategy InfluxDB

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

Preview Results

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 Influx Query Language (IQL) and add-ons like Cloud9QL.

Create and Run

Step 1: Write your query using Influx Query Language (IQL) 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

Data Strategy InfluxDB

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