Historical data
The historical data are data which are stored in an MS SQL data base. All data is organized according to the AKS code. We prepared some tutorials/ explanations to help you connect to our data base.You can extract data with an ordinary SQL Query, which can be done in various programming environments. The Options are SQL, Visualizer, Python, Matlab, RStudio, Grafana.
Process
If you want to have any data related to the planing stage or historical, measured data you have to follow the following steps.
Download the data use statement, fill it out and send a scan it to ehub@empa.ch. We’ll acknowledge your mail and send you the necessary credentials for the private wikipedia and the sql database
Get familiar with the nomenclature of the hard ware on site. To find out about the most important available measurements the best graph is the Single Line
As soon as you have the credentials you can access the private wikipedia which includes the data sheets of the available hardware. Furthermore you can now access the historical data via a suitable client.
Available clients
R Studio
R is a powerful tool to analyse data. Attached the step by step description how to access the data base with rStudio and create some plots
R Test
R is a powerful tool to analyse data. Attached the step by step description how to access the data base with rStudio and create some plots
Grafana
Grafana is a open source, easy to use, tool to create interactive time series graphs. Attached the step by step description how to access the data base with grafana and how to create new dashbords and tables.
Visualizer
The visualizer is a handy tool to get a quick overview over the available data in the data base in a GUI. You can access the visualizer under the following URL. After you filled in the credentials you have several options. The turtorial video is here
REST API
To request historical data there is a REST API.
Matlab
Attached the step by step description to access the data base with Matlab. The data base can be accessed via an REST api from every where. The machine where this code runs can be anywhere. The minimal Sample time is around is 1 minute. It can be decreased for specific values if needed.
Python
Attached the step by step description to access the data base with python. The data base cane be accessed via an REST api from every where. The machine where this code runs can be anywhere. The minimal Sample time is around is 1 minute. It can be decreased for specific values if needed.
SQL
The historical data are stored on a SQL data base. One way to access the data is over the MS SQL. You can run this only locally on the platform provided. Attached a tutorial.