Use TDengine* Database with Intel® Edge Insights for Industrial

Published: 05/05/2022  

Last Updated: 05/05/2022

Overview

Run time-series data collection, storage, and visualization pipeline with Edge Insights for Industrial (EII), Telegraf*, TDengine, and Grafana*.  

Follow the steps in Get Started to run the use case.

Icon for Industrial use case

  • Time to Complete: 20 minutes
  • Programming Language: SQL*

Target System Requirements

Minimum System Requirements:   

  • 6th generation and up Intel® Core™ processors.   
  • 6th generation and up Intel® Xeon® processors. 
  • At least 4 GB RAM.  
  • At least 20 GB hard drive.  
  • An Internet connection.  
  • Ubuntu* 18.04 / Ubuntu 20.04

How It Works 

Run time-series data collection, storage, and visualization pipeline with Edge Insights for Industrial.  

Collect data from MQTT compatible devices through Telegraf, store it in TDengine, and visualize it with Grafana.  

TDengine is an open-source big data platform designed and optimized for Internet of Things (IoT), Connected Vehicles, and Industrial IoT.

Architecture diagram for TDengine for EII
Figure 1: Architecture Diagram

Get Started 

Step 1: Download Docker* Compose Files and Configuration Files from eii-tdengine-connector Repo 

Git clone: https://github.com/taosdata/eii-tdengine-connector.git

Step 2: Run EII Provision

cd eii-tdengine-connector/eii-stack/provision 
sudo -E ./provision.sh ../docker-compose.yml

Step 3: Download Containers

cd eii-tdengine-connector/eii-stack 
docker-compose pull

Step 4: Start Containers 

Run the following command:

docker-compose up -d

Use docker-compose ps command to check if all containers were created properly. 

docker-compose ps

The following 6 containers should be ready:  

  • emb_publisher 
  • Ia_etcd_ui 
  • Ia_grafana 
  • Ia_tdengineconnector 
  • Ia_telegraf 
  • Ia_zmq_broker

Step 5: Check Grafana Dashboard

  1. Open http://localhost:3000 in browser to check Grafana. The default username is admin and password admin
    A screen showing the Grafana welcome page with username and password filled in.
    Figure 1: Grafana Login

     

  2. After login, import Grafana dashboard.json from eii-tdengine-connector/eii-stack/grafana/dashboard
    Screen showing the Welcome to Grafana Dashboard. In the left bar, there is a + sign where Create is highlighted and Import is one of the options below it.
    Figure 2: Select Import
    Screen showing the Import Dashboard where user can provide a name and folder location.
    Figure 3: Import Dashboard

     

  3. A few minutes after importing the dashboard, you should see something the EII TDengine Demo showing temperature, humidity, pressure, and voltage graphs. 
    Screenshot of Grafana Web UI showing temperature, humidity, pressure and voltage graphs.
    Figure 4: Dashboard of EII TDEngine Demo

Summary and Next Steps 

With this use case, you set up a pipeline of collecting, storing and visualizing time-series data.

As a next step, try building your own time-series data pipeline with EII.


Learn More 

To continue learning, see the following guides and software resources: 


Support Forum 

If you're unable to resolve your issues, contact the Support Forum.  

 

Product and Performance Information

1

Performance varies by use, configuration and other factors. Learn more at www.Intel.com/PerformanceIndex.