Add 'Test Connection' on Data Sources

[hennlo]

Affected Areas

DB, UI

Feature Description

To verify that the connection with the specified credentials to the data source system works as intended a 'Test Connection' button for the UI or a internal call could be implemented.

Use Case(s)

When creating data source adapters but also for existing adapters. This could also later on feed back some information and avoid accessing sources that might be currently offline or unreachable

Possible Solutions

Check when creating the connection Handler and do dummy executions on data source e.g. at PSQL SELECT 1

Possible Alternatives

No response