Skip to content

Generic database content importer

Versio.io can import, historize and process generic database content.

Supported database management systems (DBMS)

The generic database content monitoring supports the following relational database management systems:

  • Oracle database
  • Microsoft SQL
  • MySQL
  • MariaDB
  • PostgreSQL

Configuration

You can find the configuration option in Versio.io at Environment settings > OneImporter > Configurations > Generic database content.

Here you can edit all existing configurations, create new configurations or delete existing configurations. Each configuration can import content from multiple databases of a single DBMS. To add a new configuration enter a Name and click Add to proceed to the configuration. To edit an existing configuration click the arrow on the left of your importer name to expand the configuration options.

The following configuration options are available:

Field Description Advice
Name Meaningful name Include database name/type
Active Option to activate and deactivate the configuration. Data is only imported if the configuration is activated.
Database type Select required DBMS type
Host or IP Host name or IP address of the DBMS
Port Listening port of the DBMS The default port is set automatically
Username User name for DBMS access
Password Password for DBMS access
Database name or SID Name or SID of the databases Only databases located in the above DBMS can be specified
SQL query SQL Statement to query specified database
ID field in SQL result ID field is how other instances refer to this instance Choose an unambiguous field
Entity name Name of the entity imported that instances are assigned to Determine standards about entity names before your first import
Executing OneImporter Select a Versio.io OneImporter to import the data based on the importer configuration. Requires installed OneImporter: Installation instruction
Schedule time (cron format) Determine the frequency of imports in CRON format Learn more about CRON format: https://en.wikipedia.org/wiki/Cron

Table: Generic database content configuration parameters

 

The following image is an example of a generic database content configuration:

Versio.io generic database content importer configuration Figure: Example of a Versio.io schema configuration

Example

The Versio.io OneImporter imports the generic database content based on a specific configuration and stores the different instances in entities defined by you. To view the imported instances in Versio.io, you can select 'Asset & Configuration Repository → Instance Viewer'. There you can select your specific instance and click it for a detailed view in the instance history viewer.

The following image is an example of imported generic database content:

Versio.io generic database content instance overview
Figure: Overview of Versio.io generic database content (left) and topology of related instances (right)