Official | HULFT IoT EdgeStreaming Adapter Reference First Edition: July 1, 2021
Insert
This operation writes input data to InfluxDB tables.
You can display the insert operation screen by displaying the script canvas on the Designer screen, clicking the following items in the following order, and then dragging and dropping the component icon onto the script canvas:
-
Tool palette > Database > InfluxDB > Insert
Figure 6.1 Insert operation screen
(1) Field list
This is a list of the fields to configure for the insert operation.
|
Field Name |
Initial Value |
Setting Value |
Omission |
Notes |
|
|---|---|---|---|---|---|
|
Name |
|
Single-byte alphanumeric characters and certain symbols (*1) |
- |
A value that begins with a single-byte alphabetic character |
|
|
Input data |
(No input data) |
Name of the input data component |
- |
Select from list (*2) |
|
|
Required settings |
|||||
|
|
Destination |
|
|
- |
|
|
Measurement |
|
|
- |
|
|
|
Schema definition |
|
|
- |
|
|
|
Write settings |
|||||
|
|
Number of batches |
1 |
From 1 to 2147483646 |
- |
Set as integer |
|
Retry settings |
|||||
|
|
Number of retries |
15 |
From 0 to 9999 |
- |
Set as integer |
|
Number of buffering items |
86400 |
From 0 to 1073741824 |
- |
|
|
|
Buffer type |
Memory buffer |
|
✓ |
Select from list |
|
|
Comment |
|||||
|
|
Comment |
|
Characters |
✓ |
|
|
✓ |
: |
Possible to omit |
|
- |
: |
Impossible to omit |
|
*1 |
: |
Only "_" (underscore) can be specified. |
|
*2 |
: |
When component icons for input or conversion are placed on the script canvas, the options are displayed in the list. |
(2) Description of each field
This section explains each of the fields to configure for the insert operation.
After changing these settings, click Finish to save the settings.
Click Cancel to discard the changes.
- Name
-
Name of the insert operation component
Single-byte alphanumeric characters and "_" (underscore) can be used.
Use a value that begins with a single-byte alphabetic character.
- Input data
-
Selection of the component name of the input data for the insert operation
From the input data component names displayed in the list, select the component name for the insert operation.
Required settings
- Destination
-
InfluxDB destination
Select the InfluxDB destination for the insert operation.
When you click Add, the InfluxDB connection settings screen appears.
For details on the InfluxDB connection settings screen, refer to InfluxDB connection settings.
When you click Edit list..., the editing screen for the resource list appears.
For details on the editing screen for the resource list, refer to Edit resource list.
- Measurement
-
InfluxDB measurement
Set the InfluxDB measurement for the insert operation.
You can retrieve a list of measurements from the InfluxDB specified for Destination by clicking Get measurement list.
- Schema definition
-
Schema definition
Configure the schema of the InfluxDB that is set as the destination.
You can get the schema definition from Measurement of the InfluxDB specified for Destination by clicking Get tag key and field key.
Click Up or Down to move the selection.
Click Add or Delete to add or delete a Tag or Key.
Write settings
- Number of batches
-
Number of batches
Specify a number from "0" through "2147483646" for the number of batches to write to the database.
Retry settings
- Number of retries
-
Number of retries when trying to connect to the database
Specify a number from "0" through "9999" for the number of retries when trying to connect to the database.
- Number of buffering items
-
Number of buffering items when writing to the database
Specify a number from "0" through "1073741824" for the number of buffering items when writing to the database.
- Buffer type
-
Buffer type
Select from the following buffering types:
-
Memory buffer
-
Comment
- Comment
-
Comment regarding the insert operation
You can enter a comment.
Official | HULFT IoT EdgeStreaming Adapter Reference First Edition: July 1, 2021