Connection configuration

Wire up your connection by following the following steps (detailed explanation below):

Choose database type
Connect to your database
Define datasets
Write the required queries

To establish a connection, navigate to Settings → Connection.

Step 1: Choose database type

In the Overview tab, you can change the type of database you want to connect to.

You can also export the current connection setup (including all the queries), or import connection settings from a JSON.

To get some guidance, you can start by uploading these test queries (written for Postgres databases):

1KB

database-connection-postgres.json

Open

Supported Databases

Step 2: Connect to your database

Before configuring a connection, ensure that you have configured all necessary credentials. The required values differ between database types.

After selecting the database type in the Overview tab, move to Connection to fill in the credentials.

Use "Test Connection" to make sure everything works. It should give a green checkmark (✅)

Step 3: Define datasets

Marple Insight has a "dataset-oriented" approach. Start by defining 1 or more dataset metadata keys that define a dataset uniquely. Each dataset will shown in the library as a separate entry that can be analysed.

A dataset can be for example one flight test, race data for 1 car, ...

In the Metadata tab, you can define all dataset metadata that is shown in Marpe.

Mark the dataset identifiers as "filter". Those values can later be used in the queries, e.g. as dataset.dataset_id.

Step 4: Queries

Next, within the Marple Insight application, you'll need to define a set of queries that allow Marple to interpret and retrieve your data.

There are required queries—such as those for datasets, signal lists, and time-series data—as well as optional queries, like segment-based queries.

Make sure to wire up all required queries to enable Marple Insight on your data.