This page provides details for configuring Database Adapters in edgeCore. There are slight differences in configuration between the various types of Database Adapters – those differences are specified in the details below.
Databases that require a driver will not be available when configuring new connections until the driver has been installed. Refer to Installing Database (JDBC) Drivers for more information. Note: edgeCore versions 3.10.0 or higher will show all supported database connection types, regardless of whether the driver is installed in the
|MySQL / MariaDB|
The first step in configuring a new Database Adapter is to create a new Pipeline Connection. Enter the Pipeline view and click
+ to create a new Pipeline Connection.
Adding a Database Connection
When adding a connection, administrators are presented with a dialog listing adapter types. Select one of the Database adapters, and click “Next”:
Step 1: Connection Details
The Database connection wizard will vary based on the type of database selected. The example below shows H2.
The following are the basic options for all Database Connections:
|Connection Name||Display name of the Connection.||Yes||Wiretap Metadata|
|Description||This is where the administrator can enter notes for the connection.||No|
|Enabled||If yes, this Connection will count against the license limit.||No|
|Credentials||Username/Password to be used for authorization to access this connection.||No||johndoe
The following are the specific settings for MySQL, PostgreSQL, and jSONAR:
|Database Name||Name of the database to be accessed.||Yes||wiretap_metadata|
|Host/IP||IP address or hostname of database server to be accessed.||Yes||wiretap01|
|Port||Port of database server to be accessed.||Yes||3306|
The following are the specific settings for H2:
|JDBC URL||JDBC style URL of the H2 database to be accessed.||Yes||jdbc:h2:~/test|
Failover is an optional setting that enables multiple endpoints to be configured for a connection. When the primary connection goes down, edgeCore will “failover” to the next configured endpoint.
|Failover is enabled for this connection, and the next step will allow multiple endpoints to be configured.||Failover is disabled for this connection, and the next step will allow a single endpoint.|
Once the proper settings have been specified, click “Next”.
Step 2: Endpoints
If failover is disabled, then properties for a single endpoint will be displayed:
If failover is enabled, then a list of endpoints will be available:
Information for each endpoint can be modified using the edit button:
Setting the “Enable” property to “No” will result in that endpoint being ignored during failover.
Step 3: Test Connection
Edge will attempt to establish a test connection with the database server.
If the test connection is successful, a green validation message will appear.
If the test connection is unsuccessful, a red validation message will appear. Click the “more info” link to get additional information on why edgeCore was unable to connect to the configured source.