Skip to main content

ETL Converter

tip

During the device system integration process, IoT data formats are often diverse and may not conform to the system's standard data format. The ETL Converter serves a critical role in ensuring compatibility by precisely defining the mapping relationship between single device data objects and the system's required data format. For instance, it maps device identifiers such as DevEUI and device point objects like points to the system rules, enabling seamless device integration.

Accessing the Converter​

Navigate to the System Settings menu and click the ETL Converter button to enter the converter configuration module, as shown below.

tip

The system supports two types of configurations:

  • Single Object Converter: Default option.
  • Function Configuration.

Image

Converter List​

tip

The system allows querying converters by name or device type.

Enter the desired converter name in the search bar and press Enter to refresh the list, as shown below. Image

Adding a Converter for IoT Devices​

Image Click the “+” button at the bottom of the page to enter the add converter page, as shown below. Image

warning

IoT devices support two formats for single object converter configurations:

  1. Point Combination: Combines device point data.
  2. Point Flat Configuration: Flattens device point data.

Device Point Data Combination Configuration​

tip

Device point data combination point [JSON format example: {devEUI:XXX, object:{point1:xxx, point2:xxx}}]

  1. Configure the converter name.
  2. Set the Type to IoT.
  3. Paste the device's reported JSON in the Payload field.
  4. Set Single Object to False.
  5. In the dropdown, select the Device ID and Device Points Object from the JSON keys.
  6. Click Save to complete the configuration.

Image

Device Point Data Flat Configuration​

tip

Device point data flat point [JSON format example: [{id:xxx,value:xxx},{id:xxx,value:xxx},...]]

  1. Configure the converter name.
  2. Set the Type to IoT.
  3. Paste the device's reported JSON in the Payload field.
  4. Set Single Object to True.
  5. Select the appropriate Device ID, Date Key, Device Name Key, and Device Location Key from the JSON keys.
  6. Any unconfigured data will default to the device points as per the system settings.
  7. Click Save to complete the configuration.

Image

Adding a Converter for Non-IoT Devices​

tip

For non-IoT devices, you only need to specify the pointID and point values during integration. Additional device information can be completed later in the device registration section.
Note: The Payload must be an array, allowing multiple devices' points to be reported in a single request.

  1. Configure the converter name.
  2. Set the Type to Non IoT.
  3. Paste the device's reported JSON in the Payload field.
  4. Select the appropriate Device ID, Date Key, Device Name Key, and Device Location Key from the JSON keys.
  5. Click Save to complete the configuration.

Image