Connect

Introduction

Connect exists to help you access your data, analytics, model results and services in your external applications. With connect you can:

  • Build features into your frontend products like websites, games and apps.
  • Work with business intelligence tools for further analysis and reporting
  • Build bespoke dashboards using tools like Grafana
  • Consume into physical products and infrastructure like connected cars, machines, drones and buildings.

We will build out the features of connect to build more data-driven widgets and integrations to third-party apps and services.

Features

SDK

Connect provides code samples to help you get started quickly. They are preconfigured with certificates for your workspace and available in C#, Python and Shell.

You can customise our samples from Visualise where you can build a query using all the tools available, then click connect to give you pre-configured sample code for the exact data that you had in the visualise view. Copy and paste this code into your app or command line to view the data.

Query API

Our Query API helps you to build reports and analytic features from historical data in the Catalogue. You can analyse metadata and telemetry data programatically with C# and Python from your frontend. Use the Swagger docs and SDK to get started quickly.

PowerBI Integration

PowerBI is a powerful data visualisation tool which you can use to present analysis and model results to internal and external stakeholders.

As mentioned previously, we’re not building a data visualisation tool; instead we developed a code sample to help you get your data from Quix to PowerBI.

Use the PowerBI integration and our instructions to get started quickly.

How-to

Query data

From Connect; select Shell from the dropdown box; copy, paste and execute the code in your command line tool. You’ll receive the data from Quix.

Customise queries

Go to Visualise; select the streams, parameters, filters and aggregates you want to apply; navigate to the timeframe you want to access; click the ‘connect’ button; select Shell, you’ll be taken to the Connect page where you select C#, Python or PowerBI from the dropdown box; copy and paste the sample code to you app or PowerBI.

Connect to PowerBI

  1. Open Power BI
  2. In "Home" click "Get Data" and then find "Blank Query"
  3. On the left hand side, right click on "Query1"
  4. Click "Advanced Editor" in the drop-down
  5. In Advanced Editor clear whatever code is there by default
  6. Paste our sample code into the Advanced Editor
  7. Click "Done"
  8. If it asks "Specify how to connect" click on "Edit credentials"
  9. It should default to anonymous, but if not make sure anon is selected (rather than 'basic' or 'web api' etc.)
  10. Click Connect

Access Swagger

From Connect; select Swagger from the dropdown box; click the link to access our Swagger repo.