About Data Sources

To create applications in Operations Hub, you can fetch data from the following sources:
  • Data stored in Operations Hub: This data is created and stored in entities, which are database tables. To create data, you can:
    • Manually enter the data in an entity.
    • Import data using a Microsoft Excel spreadsheet.
    • Insert data into entities using insert queries, which you can create using Operations Hub.
    • Send data from an MQTT client to an M2M entity. In addition, you can also use pivot tables to send data dynamically.
    • Create an API that will work with the Operations Hub APIs to send data to an entity.
  • Data stored externally: This data is stored in an external database, such as a Historian server. You can use this data in an Operations Hub application. To do so:
    1. Create a data source to provide the details of the external database whose data you want to use.
    2. Create a REST or SQL query to specify the expected inputs and outputs of a REST endpoint (as defined in the REST API) .
    3. Run the query to fetch the data from the external database.
      Note: The data will still be stored only in the external database; it will not be stored in Operations Hub.