Overview of integrations and extensions of the aedifion.io cloud platform.
With aedifion's open source Excel Plugin, you can import data from aedifion.io using its HTTP API directly into your Excel sheet. You can query data from multiple datapoints over multiple projects and synchronize asynchronous CoV-based observations with adjustable sample rates and different interpolation methods, such as zero-order-hold (step interpolation). The retrieved data can be visualized in different types of automatically generated plots. The plugin is currently available for Windows and can be installed without admin rights.
Figure 1: Importing multiple timeseries from the aedifion.io HTTP API directly into an Excel sheet
Power BI is a Microsoft analytics service aiming to provide interactive visualizations with an interface simple enough for end users to create their own reports and dashboards. It can make use of multiple datasources, including csv files or direct HTTP requests to the aedifion API. Parameters can be added directly into the queries, making it easy to adjust the HTTP request, e.g., to change the datapoint id, samplerate or interval. The requested data can be parsed properly with a few steps that have to be defined once, typically including:
- Conversion to table
- Extraction of values
- Splitting column by delimiter
- Renaming columns
Once the query is applied, the parsing steps are applied automatically and the data can be utilized within many different visualizations.
The following section contains a tutorial on how to allow for direct data ingress from the aedifion API into the Power BI platform. Using this method, it is possible to input unlimited datapoints into Power BI using a single query.
First, one needs to attain the URL to the desired API endpoint by using the SwaggerUI.
Head over to the aedifion API user-interface using this link and log in via openid.
Navigate to the desired API endpoint, such as the one for:
Retrieving timeseries data for a single datapoint (
GET /v2/datapoint/timeseries) or retrieving timeseries data for multiple datapoints (
When activating the desired API endpoint, make sure to include all the parameters you would later want to turn into variables, such as start, end or max. Once initialized, the Request URL can be copied.
The request URL can then be inserted as a Web source in Power BI. Under the option "Advanced" the URL can also be provided with variables (so-called "parameters"). For this purpose, the URL must simply be divided into different parts and suitable parameters added.
The first time the query is executed, the login information is requested once.
Now the query has been created, can be easily manipulated using variables.
Our Telegram Chatbot receives real-time alerts from the aedifion.io platform and sends them to private or group chats. Typical use cases are, notifying about unwanted or even dangerous system conditions or detecting unscheduled shut-downs and outages. To facilitate a quick assessment and response to potential emergency conditions, the chatbot offers further interactive features that, e.g., allow quickly plotting critical datapoints and querying basic statistics directly from within the chat. Integration with other messengers such as Slack, or Teams is available on request.
Figure 2: Plotting a threshold alarm on CO2 concentration within a Telegram chat
Together with SCASA, aedifion offers high resolution 3D Visualizations with centimeter accuracy of your offices, installation rooms, or factory floor. aedifion augments 3D Visualizations with live data from the aedifion.io platform and even integrates controls. With this product, you can take virtual tours of your local site, e.g., to monitor and control components or determine a component's build to order a replacement -- with a browser from anywhere just as like being on site. By searching for a device with tag search you literally fly to the selected device.
Figure 3: Taking a virtual tour through the ERC's installations room
We have built skills for Amazon's Alexa to interact with the HTTP API of the aedifion.io platform allowing you to query and control your surroundings using natural language. E.g., you may turn down the heating in your office with a simple dialogue.
Figure 4: Ask Alexa to turn down the heating
On demand, aedifion provides a separate instance of the Grafana visualization environment for each project. Grafana allows you to easily build your own dashboards on your project's data dragging-and-dropping from a wide range of plots, charts, and widgets.
Figure 5: Example of a custom Grafana dashboard for monitoring occupancy and comfort in a meeting room
The aedifion.io platforms integrates with multiple cloud services for data ingress and egress. You can, e.g., ingest data from devices connected to Cumulocity, run analytics on it on the aedifion.io platform, and export data and results to your AWS S3 Bucket.
Third party data¶
We integrate different free third-party data sources with the aedifion.io platform that allow augmenting your building's data with, e.g., weather data.
We integrate localized weather data from the DarkSky weather service. Weather data is accessible and visualizable on the platform like any other datapoint on the platform. It includes measured data as well as predictions with different horizons of several meteorological conditions such as temperature or dew point.
aedifion.io is able to connect to customers' Microsoft Exchange servers. A typical use case is to take information on resources to find better control decisions, e.g. such as bookings of seminar rooms to control their HVAC systems.