Skip to content

Data integration

Available Datatbases

We Provide two managed and hosted databases in separate VMs to handle a high amount of traffic. If you need another database, please contact us

These databases are no systems for production or high volume data. Please use them only for the data necessary for your dashboards.

The database management systems described here, are only reachable from the Virtual Fort Knox or Fraunhofer IPT network. If you need access to the VFK network, we can create a VPN access for you (For WZL: you will also need the Aruba client from your IT Department)

MongoDB (No-SQL, preferred)

Path: ipt-210-db-mongo1.cpi002.svc.fortknox.local

Please keep in mind that you have to be connected with the IPT network (Physically or via VPN) to access this database. Deployed dashboard will automatically have access.

Example

See here: https://docs.mongodb.com/ecosystem/drivers/csharp/

What is MongoDB?

MongoDB is a No-Sql-Database, which means that it is not organized like traditional SQL databases in organized tables, but in so-called documents which are described by BSON (JSON-like binary encoded format for better performance). There is no predefined structure and no complex database schemas have to be created before starting to collect data.

A typical MongoDB instance consists of the following types of elements:

  • Databases: Typical each dashboard has a single database for itself. It gets automatically generated during the creation process by the DashboardGenerator. It should at least contain a single collection.
  • Collections: A database can have multiple collections, each with a different stored type of document. The objects in a collection are called documents and have a similar structure to each other. MongoDB automatically creates an index if none is defined by the developer. It is typically denoted as _id.
  • Documents: A document contains the JSON-like encoded data structure filled with one or multiple data fields.
  • Fields: Each field contains a single data value.

See here for official docs.

Tags: database, data storage, mongodb

MongoDB Compass

Compass is a lightweight tool to explore your existing collections.

See here for downloads and documentation.

Please make sure to use the Community Edition, which is free to use, while the standard version comes at costs!

MariaDB (SQL)

Path: ipt-210-db-sql1.cpi002.svc.fortknox.local

Please keep in mind that you have to be connected with the IPT network (Physically or via VPN) to access this database. Deployed dashboard will automatically have access.

See here for official docs.

Example

See here: https://devandy.de/c-und-mysql-mariadb/

InfluxDb (Time series)

Path: ipt-210-db-influx1.cpi002.svc.fortknox.local

Please keep in mind that you have to be connected with the IPT network (Physically or via VPN) to access this database. Deployed dashboard will automatically have access.

See here for official docs.

Example

See here: https://github.com/influxdata/influxdb-csharp

Tips and Recommendations

  • Avoid complexity: Keep your data simple, such that you do not need extensive processing of the data in the databases
  • Reduce volume: Keep the volume tight to what generates benefit for the users and store only relevant data
  • Replay first: Make sure, that at every time, users can see something interesting when interacting with your data. You can use replays of real data processes for example