Data Access

Everyware Cloud stores data published by connected devices into a data store back-end. As the data is received by Everyware Cloud, the platform automatically creates data registries to track the following information:

  • The topic to which the data was addressed
  • The device from which the data originated
  • The device's asset from which the data originated
  • The metric names that are contained into each message and, therefore, the names of the metric which received any values for a given topic, device or asset

It is important to emphasize that topics are hierarchical. Data published to a topic “state/city” is implicitly addressed to “city” and “state”. Everyware Cloud performs topic-level aggregations automatically for topics up to 5-levels deep.

Through its data registries, Everyware Cloud allows for simplified data browsing and data discovery. Received data can be browsed or queried from the Everyware Cloud Console. For the complete set of all possible query operations offered by the Everyware Cloud platform, please refer to the Everyware Cloud REST APIs documentation.

Using the platform data registries, the Everyware Cloud Console allows browsing and querying of your device data in the following ways:

  • Data by Topic is appropriate when you are not interested in the device that published the data but rather the topic to which that data was addressed. Typically, this is the case when you defined a topic namespace for your application and you leveraged the Everyware Cloud platform to aggregate your data at each topic level.
  • Data by Device is appropriate when you query your device data following the physical view, knowing the device that originally produced the data.
  • Data by Asset is appropriate when you query your device data following the physical view, knowing the device and asset that originally produced the data.

Data by Topic

The Data by Topic panel demonstrates the powerful flexibility of Everyware Cloud’s schema-less data storage. You are only limited by the schema that devices use when publishing.

To display collected data, select the topic or topic branch from the Available Topics list, select the data metrics to display from the Available Metrics list, and then click Query. The Console will fill the table with collected data as shown in the following screen capture.

1119

Data By Device

The Data by Device panel queries the data by originating device. By default, a device represents the gateway (and its MQTT connection) from which the data was originated. To view the data, select a device in the Available Devices list, click the checkboxes in the Available Metrics list for the metrics you want to display, and then click the Query button.

The Console will fill the table with collected data as shown in the following screen capture. Use the vertical scroll bar to view data within a page and the page navigation icons at the bottom of the screen to move between pages. The Export button saves data to Excel or CSV formats.

1119

Data By Asset

Devices can have assets attached to them. An Asset is a logical representation of a field device, described by a list of Channels. For example, an asset can be a Modbus PLC that is attached to an IoT gateway powered by Everyware Software Framework or Kura. A register in a PLC or a GATT Characteristic in a Bluetooth device are examples of Channels of an Asset. In this way, each Asset has multiple Channels for reading and writing data from/to an Industrial Device.

The Data by Asset panel queries the data by originating asset attached to a device. To view the data, select a device in the Available Devices list, then selects one of its Assets, and finally click the checkboxes in the Available Metrics list for the metrics you want to display, and then click the Query button.

The Console will fill the table with collected data as shown in the following screen capture. Use the vertical scroll bar to view data within a page and the page navigation icons at the bottom of the screen to move between pages. The Export button saves data to Excel or CSV formats.

1121