Senseforce
This page guides you through the process of setting up the Senseforce source connector.
Sync overview
Prerequisites
- A Senseforce Dataset to export
- Your Senseforce
API Access Token
- Your Senseforce
Backend URL
- Your Senseforce
Dataset ID
Creating a Senseforce Dataset to Export
The Senseforce Airbyte connector allows to export custom datasets built bei Senseforce users. Follow these steps to configure a dataset which can be exported with the Airbyte connector:
- Create a new, empty dataset as documented here
- Add at least the following columns (these columns are Senseforce system columns and available for all of your custom data models/event schemas):
- Metadata -> Timestamp
- Metadata -> Thing
- Metadata -> Id
- Add any other column of your event schemas you want to export
- Enter a descriptive Name and a Description and save the dataset
- Note the ID of the dataset (the GUID at the end of the URL path of your dataset in your browser URL bar)
Tip: For most exports it is recommended to have the Timestamp column in first place. The Airbyte connector automatically orders in ascending direction. If the Timestamp column is not in the first position, incremental syncs might not work properly.
IMPORTANT: The Timestamp, Thing and Id column are mandatory for the Connector to work as intended. While it still works without eg. the "Id", functionality might be impaired if one of these 3 columns is missing. Make sure to not rename these columns - keep them at their default names.
Set up the Senseforce source connector
-
Log into your Airbyte Cloud or Airbyte Open Source account.
-
Click Sources and then click + New source.
-
On the Set up the source page, select Senseforce from the Source type dropdown.
-
Enter a name for your source.
-
For API Access Token, enter your Senseforce
API Access Token
. -
For Senseforce backend URL, enter your Senseforce
Backend URL
. -
For Dataset ID, enter your Senseforce
Dataset ID
.We recommend creating an api access token specifically for Airbyte to control which resources Airbyte can access. For good operations, we recommend to create a separate Airbyte User as well as a separate Senseforce Airbyte Group. Share the dataset with this group and grant Dataset Read, Event Schema Read and Machine Master Data Read permissions.
-
For The first day (in UTC) when to read data from, enter the day in YYYY-MM-DD format. The data added on and after this day will be replicated.
-
Click Set up source.