Skip to content

Integrations

Overview of integrations and extensions of the aedifion.io cloud platform.

Excel

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.

excel-plugin
Figure 1: Importing multiple timeseries from the aedifion.io HTTP API directly into an Excel sheet

Power BI

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.

power-bi-swaggerui-login

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 (GET /v2/project/{project_id}/timeseries).

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.

power-bi-request-url

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.

power-bi-websource

The first time the query is executed, the login information is requested once.

power-bi-login

Now the query has been created, can be easily manipulated using variables.

Chatbots

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.

Learn more? Start a conversation with @aedifion_bot or go to our tutorial on real-time alarms to explore its features.

chatbot-1
chatbot-2
Figure 2: Plotting a threshold alarm on CO2 concentration within a Telegram chat

3D HMI

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.

Learn more? Experience the video of a 3D visualization or request a personal demo.

3d-hmi
Figure 3: Taking a virtual tour through the ERC's installations room

Alexa

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.

Learn more? Watch our demo video or request a personal demo.

alexa
Figure 4: Ask Alexa to turn down the heating

Grafana

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.

grafana
Figure 5: Example of a custom Grafana dashboard for monitoring occupancy and comfort in a meeting room

Cloud services

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.

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.

Learn more? Explore the current weather conditions at the aedifion office or check out the integration specifications.

Microsoft Exchange

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.


Last update: 2020-11-25