Configuring and Managing External Reports Databases

Overview

Micro Edge 6.1 enables the admin to specify an external database where Reports information can be sent. This option enables significantly more Reports details to be retained, exceeding Micro Edge's local database capacity. It can also offer redundancy across multiple servers.

Configuring external databases

These options are located in Settings > System > Database.

Managing connected databases

The table lists all connected databases and provides details about each:

Reset to defaults returns all Database settings to their factory defaults:

• deletes any custom database connections
• sets Micro Edge's local database to the default and enables it

Refresh connections refreshes each database's connection. This is useful if a database connection has gone offline and been restored to service.

Export CSV will export the databases table to a CSV file.

Refresh updates the status of the table. This is useful to verify changes to database connections such as online/offline status or a change of server hostname/IP.

Editing & removing databases

Hovering over or selecting a database will expose two icons at the right-hand side:

• click the pencil icon to edit the connection
• click the trash can icon to delete the connection

Adding a new database connection

1. Click Add Database to begin
2. Add a Name for this connection. This does not need to match the Database Name attribute; think of it as a "friendly name" for the connection.
3. Add a Description
4. Connection Enabled determines whether the connection is online when it is created. This can be disabled for databases you're not ready to connect yet.
5. Default Connection determines if the new database will be the default. When enabling this checkbox, you will be prompted to confirm that you intend to replace the local database with your specified one. This option is unique: only a single database can be the default.
6. Fill in the Database Configuration fields:
   

   Database Type	The format of the database: sqlite, mysql, or postgres
   Database Name	The filename & path of the database
   Database Port	The port used to connect to the database
   Database Server	The hostname or IP address of the server which hosts the database
   Database Username	A username provided when connecting to the database
   Database Password	A password provided when connecting to the database

    

7. Click Add.
8. When you're done adding databases, click Save to commit the changes.

Configuring a Micro Edge Template with External Database Connections

ETM Dashboard enables the admin to create a Micro Edge Template which can be applied to multiple Micro Edge deployments. This option is found in the Create New dialogue under Global > Database. 

For more information on creating and applying Templates, please see Managing Micro Edge Policies in ETM Dashboard: Templates