The Database (Measurement) Connector retrieves data from relational databases using configurable SQL queries and transfers the results to the platform for processing. It runs as a Windows service and includes a web-based interface for configuring queries, scheduling jobs, and monitoring activity.

Supported database systems include Oracle, SQL Server, and Athena. A compatible JDBC driver for the target database must be supplied during installation.

​

The interface is accessed via a web browser. It displays the current system time and time zone used by the connector, which may differ from the local time of the machine running the browser.

​

The Event Log records connector activity and system events. Each entry shows the job or event description, execution result, a summary message, timestamp, and duration. Events are colour-coded by status. Selecting an entry shows additional detail and any error messages. Older entries are removed automatically after a retention period.

​

Base Queries define the SQL statements executed against the source database. Each Base Query has a name and a query text. Query text may include typed parameters (Integer, Float, String, or DateTime) that are substituted at execution time. Certain date parameters can be auto-populated during execution, such as current date or previous execution time.

​

Queries are built from Base Queries and define the specific parameter values used for each data extraction. The same Base Query can be reused across multiple Queries with different parameter values. Queries can be previewed before scheduling — a preview executes the query and generates a downloadable spreadsheet of results without submitting data to the platform.

The connector validates that all required parameters are present before a query can be saved. If the parameters defined in a Base Query change, the Query parameters can be refreshed to stay in sync.

​

Scheduled Jobs define when queries run automatically. Each job specifies a name, the query to run, a start date, an optional end date, a repeat interval, and an active/inactive toggle. When a job runs, the connector executes the query, generates a results file, and submits it to the platform.

Jobs can be executed manually at any time without affecting the schedule. Missed jobs can be rerun for a specific date range — date parameters in the query are adjusted automatically to match the original execution time.

If the connector service restarts, scheduled jobs recalculate their next execution time. Jobs scheduled during downtime do not run automatically and must be triggered manually if the data is needed.

​

The Database (Measurement) Connector requires a JDBC credentials file (database-jdbc-credentials.properties) to authenticate with the source database. All four properties are required.

After preparing the file, upload it via the Manage Credentials screen in the connector interface. Changes take effect immediately.