Tetra SDC Connector v1

AGU SDC (Sm@rtLine Data Cockpit) captures measurements from sensors and analyzers and gives the ability to export them via REST API using the Smart Reports feature. Tetra Data Platform has a built-in integration that allows users to pull SDC measurements as JSON files into the Tetra Data Lake.

PRIOR TO SETTING UP THE SDC INTEGRATION ensure the ingestion pipeline has been created and enabled.

Pipeline Configuration

Create a new pipeline.

2270

Create new SDC Measurement RAW to IDS pipeline

The pipeline will be triggered by a RAW file appearing in the Tetra Data Lake where the source.type is sdc and the category is RAW.

The pipeline will use the SDC Measurement RAW to IDS protocol.

Setup desired notifications.

Provide a pipeline name. Best practice is to use the protocol as the pipeline name.

SDC Setup Requirements

SDC supported version is 2.8.9.2 or higher

SDC REST Service component should be installed

1271

ExportedMeasurements Smart Report (designed by AGU) must be enabled

This Smart-Report is available in the installation folder SmartReports on the SDC application server.

501

Smart-Reports are packed in one file and can be uploaded to SDC by admins or key users. This is available for download here: https://tetrascience.egnyte.com/dl/jhTuOcr9xP

Export Interface must be configured

To create the required export interface, the admin or key user must select the “Export management” menu and press the + button. The type of export interface must be “custom” and the event type must be “Measurement”. The user can then decide which division and which analyzer types should create interface events.

558

Verify Network Requirements and Setup

SDC integration requires network connection to the SDC API endpoint. Typically, you will need to open up the port used for connection on your firewall. To verify your SDC is set up properly for integration, please follow the steps below on the DataHub machine to make sure Tetra SDC Connector (running on the DataHub machine) can access your SDC instance.

Step 1: Verify network connection and authentication

curl --location --request GET 'https://your.sdc.net/SDC/Measurements' \
--header 'Authorization: Basic xxxxxxxxxx'

📘

cURL

To test network and API connection using cURL, you may follow
this guide

📘

Basic authentication

Basic authentication is a simple authentication scheme built into the HTTP protocol. The client sends HTTP requests with the Authorization header that contains the word Basic word followed by a space and a base64-encoded string username:password. For example, to authorize as demo:p@55w0rd the client would send

Authorization: Basic ZGVtbzpwQDU1dzByZA==

Step 2: Verify smart report is available

curl --location --request GET 'https://your.sdc.net/SDC/Smartreports' \
--header 'Authorization: Basic xxxxxxxxxx'

Confirm that "ExportedMeasurements" is available in the response

Step 3: Verify the Export Interface Id

The "ExportedMeasurements" is associated with an Export Interface Id, which is provided by your SDC admin. Running the following HTTP request should yield expected Exported Measurements, not an empty response.

curl --location --request POST 'https://your.sdc.net/SDC/Smartreports/ExportedMeasurements' \
--header 'Authorization: Basic xxxxxxxxxx' \
--header 'Content-Type: application/json' \
--data-raw '{
    "InterfaceId": "<your_interface_id>",
    "LastInterfaceResultId": "0"
}'

How to configure Tetra SDC Connector

Add SDC Integration configuration

  1. Click the "hamburger" button on the upper left corner and a sidebar will pop out on the left, click "SDC" under "Data Sources" menu

  2. Click "Add SDC integration"

  3. Enter SDC REST API details:

    • URL: REST API endpoint (without trailing slash)
    • Username
    • Password
    • Client ID: may be arbitrary value and will be used for OAuth authorization with SDC REST API
    • Client Secret: value used on SDC REST Service setup
    • Accept self-signed certificates: if your setup uses self-signed certificate make sure this is checked, otherwise Tetra Data Platform won't be able to access SDC REST API
  4. Click "Login" button to make sure login information is correct

  5. Click "Create" to save setup information.

Add a New Source

  1. Click "+ Add source" on created integration add source information.

  2. Provide source details:

    • Export Interface ID: id of Export Interface from SDC (e.g. 1). This number is accessible to SDC admins in: "Settings" -> "Export Management". Non-admins will have to contact their admins to identify this number.
    • Load historical data: when checked, measurements which were added before Exported Measurements report was configured, will be imported without associated Export Interface ID as historical records.
  3. Click "Validate" button to make sure your SDC setup is valid. If it fails, please make sure you have ExportedMeasurements Smart Report setup and configured.

  4. Move next to add name and description and click Next.

  5. Add any metadata and tags and click Finish.

Your SDC integration is configured.

If you selected Load historical data you will see files loading when you go to Search Files in TDP UI.

How to configure SDC Connector on DataHub

  1. Setup DataHub
  2. Click "+ Add Connector" button on created DataHub
  3. Select "SDC connector" from the list
  4. Enter connector name
  5. Enter SDC REST API connect information (see details above)
  6. Move forward to complete setup

Notes on SDC Connector

The SDC Connector was developed and tested using SDC version 2.8.9.2

Frequently Asked Questions

1. Why does "Import Reports" not show up as an option as depicted above?
The Admin needs to insure that the user has the right to import reports. You can check that through the following steps:

1872

Reports