Example
This example Application demonstrates how to read telemetry data from a table in an Azure Data Explorer instance using the TSC Azure Data Explorer Connector.
You can download the files here to try it out for yourself - adjusting the steps to use your own Azure credentials.
Refer to configuration to understand all configuration options of this Connector.
Step 1: Add the Connection
From the Properties blade of the Time Series Chart, select the Data Source tab.
Click the plus icon next to Data Source
Click the plus icon next to Connection.
Select the TSC Azure Data Explorer Connector
Enter a name for the connection. In this case, set the name to "TSC ADX Connection".
Step 2: Configure Server
Enter the authentication details: the Cluster Url, Tenant Id, Client Id, and Secret Key. In this case, tick to use variables.
Step 3: Configure Database
Select the database, table, primary key, and columns to return. In this case:
Database: showCase
Table: PumpTelemetryData table
Primary key: PumpId
Columns: ReadingNo, PumpId, Timestamp, MotorCurrent and Temperature
Step 4: Configure Timeseries Settings
Tick to indicate we're using timeseries data and select the timestamp column. In this case, select Timestamp.
Click Save.
Step 5: Use the Connection
Use the Connection that was just created to complete entering the new Data Source. In this case, set the name to "Pump Data" and the entity to "PumpTelemetryData".
Save the Data Source.
Note: the primary key is auto-populated once the entity is selected.
Step 6: Use the Data Source
Select the Data Source we just added, Data's Timestamp expression and default selection.
In this case, "Pump Data" for Data Source, "Timestamp" for Timestamp Expression, and tick MotorCurrent and Temperature.
Save the Application, click Launch and view the chart.
Step 7: Results
Observe that the MotorCurrent and Temperature are returned from the Azure Data Explorer database for the selected period.
Files
See the Import, Export, and Clone - XMPro article for steps to import an Application.
Last updated
