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: edgeSuite versions 3.10.0 or higher will show all supported database connection types, regardless of whether the driver is installed in the /libs directory.
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.
When adding a connection, administrators are presented with a dialog listing adapter types. Select one of the Database adapters, and click “Next”:
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:
The following are the specific settings for MySQL, PostgreSQL, and jSONAR:
The following are the specific settings for H2:
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.
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.
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.
Refer to SQL Feed for information on how to pull data from a Database Connection.