Forum Stats

  • 3,837,096 Users
  • 2,262,225 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


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.


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 –

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 -


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 –


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


3. Click Create Application


4. Enter details for Name and description


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


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


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


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


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”


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.


Once Exploration Source is created, create the Exploration

1. Click “Add”


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


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


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


3. Enter Details for BICS and click Create


     URL – URL for the BICS Instance (

     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


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


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


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


2. Click Registration on the left hand pane


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


4. Enter details and click Register


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


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


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


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


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”


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


6. Click on “Analyses” on the Top menu


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


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.


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


10.  Create Vertical Bar Graph to represent the above data


11. Graphical representation of the data will come as


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


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


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


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


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



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 –

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