Skip to content
  • There are no suggestions because the search field is empty.

Tutorial: Starter Solution

This tutorial provides a simple solution that can be used to get started with Intelligence Hub.

What Does This Tutorial Cover?

If you are new to Intelligence Hub this tutorial may help you to get started.  It is a simple solution that can be easily understood and reverse engineered to learn the basics of Intelligence Hub configuration objects.  This article covers the following.

  • Solution Overview
  • Solution Configuration
  • Tutorial Summary

Solution Overview

This simple Intelligence Hub industrial DataOps solution pertains to motors.  The solution combines maintenance order information obtained from SQL Server with motor process information obtained from KEPServerEX, an OPC UA server.  The data is combined into a single payload that is published using the Intelligence Hub MQTT broker.  The data could be used to create a real-time dashboard displaying maintenance information for example.  The following diagram summarizes the solution.

The following video provides an overview of the solution.


Solution Configuration

The SQL Server and KEPServerEX data sources for the solution have been made available by HighByte.  Therefore, if the Intelligence Hub deployment has access to the internet and the respective ports are open it is possible to build a solution that uses the data sources below.  The configuration information is provided below.

OPC UA Settings
Host: 52.10.6.4
Port: 49320

SQL Server Settings
Host: 52.10.6.4
Port: 1433
Database: serviceinfo
Username: highbyte
Password: password
SELECT * FROM [dbo].[lastservice] WHERE [dbo].[lastservice].[machineid] = 'motor001'

MQTT Settings
Host: 0.0.0.0
Port: 1885

Model Attributes
motorId
site
area
line
amps
speed
vibration
error
lastServiceDate
notes

Asset Hierarchy
Portland
Area-1
Line-1
Assets
Motors
Motor001

Dynamic Topic Path for Pipeline
///assets/motors/

The following video walks through the process of configuring the solution.

 

The completed solution can be imported into an Intelligence Hub solution using the project file provided here. 

Project File



Tutorial Summary

This tutorial provides a simple solution that can be used to get started with Intelligence Hub.  The Intelligence Hub Tutorials or Reference Solutions might be an appropriate next step.