![](<https://www.versio.io/img/icons/database.svg>)

# 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 Server
- 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 the specified database |  |
| **ID field in SQL result** | The ID field is how other instances refer to this instance | Choose an unambiguous field |
| **Entity name** | Name of the entity that imported 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 an installed OneImporter: [Installation instructions](<https://docs.versio.io/setup-one-importer/index.md>) |
| **Schedule time (cron format)** | Determine the frequency of imports in CRON format | Learn more about CRON format: [https://en.wikipedia.org/wiki/Cron](<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](<https://docs.versio.io/img/importer/generic-database-content/generic-database-content-configuration.png>) *Figure: Example of a Versio.io generic database content 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 &amp; 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](<https://docs.versio.io/img/importer/generic-database-content/generic-database-content-instance.png>)  
*Figure: Overview of a Versio.io generic database content instance (left) and topology of related instances (right)*
