Forum Stats

  • 3,740,609 Users
  • 2,248,281 Discussions
  • 7,861,346 Comments

Discussions

Making Business Sense of Device Data

Amit Gokhru-Oracle
Amit Gokhru-Oracle Member Posts: 5
edited Jul 13, 2016 4:37AM in Developer Solutions

Introduction

Smart devices continuously sending data every second to your Internet of Things Infrastructure and you are as a business user not able to find out any useful insight from this enormous amount of data. Are you also trapped in this?

Internet of Things is in vogue these days but just capturing the data is not enough if your IOT Infrastructure does not enable you to analyze the data and take business decision. To enable business user act rationally, lot needs to be done on the raw data which is collected from your smart devices and convert them into useful business information. In this blog post, we will see how Oracle Internet of Things Cloud Service collect the data from smart devices and convert them into business information by leveraging Oracle Business Intelligence Cloud Service and enable business users to act pragmatically.


Oracle Internet of Things Cloud Service

Typical Oracle IOT deployment consist of IOT enabled Devices, IT Cloud Service and business applications.

im-1.jpg

Three core elements of Oracle Internet of Things Cloud Services which glue all different component together are –

  1. Connect – reliable, secure messaging with device
  2. Analyze – incoming data stream at real time and Visualize data with Big Data & BI Cloud Services
  3. Integrate – IOT data with enterprise applications

For more details –

https://cloud.oracle.com/en_US/_downloads/eBook_IoT_File/Oracle_Internet_of_Things_ebook.pdf

Technical Architecture


To implement our use-case, our IOT infrastructure connect and push data to Business Intelligence Cloud Service thru Integration capabilities provided out of box in Oracle Internet of Things Cloud Service.


Technical Architecture for the same will look like this -


im-2.jpg

Interaction between components is as below –

  1. Devices are connected either directly or thru gateway device to Oracle Internet of Things Cloud Service and continuously sends data over internet.
  2. Oracle Internet of Things Cloud Service capture the device data and provide real time analysis.
  3. Oracle Internet of Things connect to Oracle Business Intelligence Cloud Service and send device data to enabled BICS do the historical data analysis and present business user with key information about the device health and required action to take.

Components Involved and Interaction

In order to work with this, you will need account for following

  1. Oracle Internet of Things Cloud Service
  2. Oracle Business Intelligence Cloud Service
  3. Smart Device

Let's Do It

Let’s first understand steps required to implement the use-case –

im-3.jpg

Creating IOT Application

1. Open IOT Cloud Service instance and login,

2. In the Dashboard, select the Application tab at the top of the screen

im-4.jpg

3. Click Create Application

im-5.jpg

4. Enter details for Name and description

im-6.jpg

5. This will create the application with the given name and will get displayed on the Application Dashboard.

im-7.jpg

This completes the IOT application creation in Oracle Internet of Things Cloud Service.


Associating Device Model

1. Open the Application Dashboard by clicking “Application” at the top and then click on the application created in the last step

im-8.jpg

2. Click on the Device Model available in the left pane and then “Choose Device Model”

im-9.jpg

3. Select “HVAC Device Model” and Click Done.

im-10.jpg

At this stage, our Application is associated with Device Model which identify the type of devices associated with this Application.


Capturing Data Stream

In order to enable real time analysis, after associating Device Model with the Application, we need to associate a Data Stream with the application. Here are steps –

1. Click on “Data and Exploration” in the left pane and then “Exploration”

im-11.jpg

2. Create new Exploration Source and bind it to required data model. In our case, bind it with the “HVAC device Model”. Add Metadata for additional device data which you want to add to the stream of data.

im-12.jpg

Once Exploration Source is created, create the Exploration

1. Click “Add”

im-13.jpg

2. Add required Details and Select previously create “Exploration Source”

im-14.jpg

3. Click Confirm.

Now we have our IOT Application associated with Device Model and Exploration. Exploration can be used to analyze the data at real time.


Create Integration with Business Intelligence Cloud Service

For historical data analysis, integrate the IOT Application with Business Intelligence Cloud Service, using below steps –

1. From the Application, Click on “Integration” available in left pane

im-15.jpg

2.Click “+” sign and then choose “Business Intelligence Cloud Service”

im-16.jpg

3. Enter Details for BICS and click Create

im-17.jpg

     URL – URL for the BICS Instance (https://server-domain.analytics.us2.oraclecloud.com)

     Identity Domain – BICS Identity Domain

     Username – BICS user

     Password – Password for the BICS user

4. Newly create integration will look like this, please note that this is not yet associated with any data stream

im-18.jpg

5. Select and Edit this Integration to add data stream by providing details for BICS Table Name, Message Format and Annotations

im-19.jpg

6. Once done, you will see Integration is fully configured and marked green

im-20.jpg

At this point we have our IOT application configured to listen to HVAC device, collect the data stream show real time analysis and forward it to BICS for historical analysis.


Register Device with IOT Cloud Service

Each device with communicate with Oracle IOT cloud Service must be registered and activated before any data messages can be transmitted. To register a device with IoT –

1. From the top menu, click on Devices tab

im-21.jpg

2. Click Registration on the left hand pane

im-22.jpg

3.On the Device Registration screen, click Register Single Device.

im-23.jpg

4. Enter details and click Register

im-24.jpg

5. Please make a note of Device ID and Shared Secret which you will need later to activate the device. Click Finish

im-25.jpg

The Device is now registered with Oracle IOT Cloud Service. With the Device ID and Shared Secret, you can activate the device. Once activated, device can communicate with the IoT Cloud Service and send data to IoT Cloud Service.


Moving Data to BICS

Once you have the Integration set-up in your IOT application with BICS, moving data to BICS is simple.

1. Go to your Integration and click on “Sync Now” button

im-26.jpg

This will sync data in given table name (while configuring stream in the BICS Integration) in BICS database


Analyzing Data in BICS

Once you sync data from IOTCS to BICS, you can see the data in BICS and analyze it to provide useful information to the business user. For the sake if simplicity, I am going to show max value of some attribute for each device.

To view data in BICS

1. Login to the BICS Analytics App and click on Modeler

im-27.jpg

2. In the Database pane, you will find the table named “HVAC_MESSAGES” which was given when configuring the stream with the BICS Integration.

im-28.jpg

3. Click “Lock and Edit” at the right to edit the model.


4. Click on the “HVAC_MESSGES” table and then click “Add to Model”. Select “Add as Fact and Dimension Tables”

im-29.jpg

5. Give names to Fact and Dimension Table and click “Add”

im-30.jpg

6. Click on “Analyses” on the Top menu

im-31.jpg

7. Click on Create Analysis on right and select the Model. This will open a new window to analyze the data. In the “Criteria” tab, select the data

im-32.jpg

8. Click on the gear icon on the OUTPUTTEMP field and Edit the Column Formula as MAX(“IOT_HVAC_FACT”,”OUTPUTEMP”) for maximum temperature of the given device.

im-33.jpg

9. Click on the “Result” tab to see the tabular data –

im-34.jpg

10.  Create Vertical Bar Graph to represent the above data

im-35.jpg

11. Graphical representation of the data will come as


im-36.jpg

12. Save the Analysis by clicking “Save” Icon at right and saving in the Shared Folder

im-37.jpg

Providing analysis to Business User

Reports can be provided to business users by creating Dashboard and including required data into them. To create Dashboard to display IOT data –

1. Click on “DashBoards” in BICS Analytics App

im-38.jpg

2. Click on Create Dashboard button on the right and provide details

im-39.jpg

3. Dashboard Editor will open and you can add the previously created analysis by finding it in “Catalog” and dragging it in main frame

im-40.jpg

4. Click Save Icon to save the Dashboard.

5. This Dashboard can be shared and viewed to view the information about HVAC devices which is collected from IOTCS

im-41.jpg

Conclusion

Analysis of data collected from your smart devices and its availability to business users is critical aspect out of any Internet of Things Deployment and Oracle Cloud PaaS Services work together to maximize your investment in this area. Real time and historical analysis of data comes out of the box with Oracle’s Internet of Things Cloud Service, enable users to take critical and timely business decisions.

To learn more about Oracle Internet of Things Cloud Services visit –

https://cloud.oracle.com/iot

** The views expressed in this post are my own and do not necessarily reflect the views of Oracle. ** 

Tagged:
Sign In or Register to comment.