Oracle Internet of Things Cloud Service collect data stream from connected device and enable business users with wealth of information at real time to take key strategic decisions. To further maximize the value of bytes collected from remote devices, device data can be filtered, processed and merged with other existing and available enterprise information, analyzed and presented as useful reports to help business users.


As database acts as repository for any enterprise’s information, following presents primary motivators for integration between IOTCS and Database Cloud Service –

  1. Moving device data from IOTCS to DBCS for historical data analysis.
  2. Enable enterprise applications to enrich existing enterprise data and features by leveraging device data.
  3. Maximize the value of data from IOTCS by analyzing it with existing enterprise data.


Although this pattern can be applied and implemented to solve multiple business scenarios, few are listed below –


1. Surveillance Device Monitoring in Smart City – Alerts are generated when malfunctioning in the camera installed in various part of the city is detected. IOTCS capture this data, filter them to find valuable events, enriches them with the location of the device and stream it out to enterprise database. Enterprise application uses the device data with other enterprise data to analyze and display various metrics like how many time in last year this camera went off, what is the make and model of this camera, technician who repaired it last and when, maintenance and operational cost etc.


2. Fleet Monitoring and Alert Management for School Vehicle - Location Monitoring device installed in the vehicle send location data to IOTCS which will send it to enterprise database used by school management application. On receiving the data, enterprise application identity students who will be picked-up/dropped at the next stop and send their parent a mobile alert. Location data from IOTCS in enterprise database can also act as location archive for proof of historical events like child arrive at school on date D at time T.


3. Manufacturing device Monitoring – IOTCS will collect data from manufacturing device, filter/clean data for relevant information and enrich them with other contextual information before sending it to enterprise assets database. Enterprise application uses the device data with other assets information to present metrics like how old is the device, comparison with benchmarks, availability of similar device, supplier information, automated ordering of new device etc.

4. Smart Home Solution – Smart Container sends alert for refill to IOTCS to be streamed out to customer database holding customer settings for the smart container. Enterprise application combine data received from IOTCS and existing data in the database to identity commodity associated, customer preference for order, vendor information to which order is places etc and places a order automatically.


Technical Architecture



Key Cloud Services Involved


  1. Internet of Things Cloud Services – Oracle’s platform for Internet of Things offered as cloud services, connect, collect, analyze and forward device data.
  2. Java Cloud Service – SAAS Extension – J2EE container in Oracle Cloud used to host J2EE applications.
  3. Database Cloud Services – Database in Oracle Cloud to save enterprise data.


Key components


  1. Devices – Physical devices with sensors collecting specific attributes and sending them to Oracle’s Internet of Things Cloud Services.
  2. IOT Cloud Service – IOTCS will collect, filter and forward data to enterprise application.
  3. Enterprise Application – Deployed on JCS-SX, enterprise application expose rest-endpoint which will be used by IOTCS to push data to this application for processing. It processes and saves data to the enterprise database. Enterprise Application can use the saved device data for multiple modules like historical reporting and analysis.
  4. Database Cloud Service – Act as enterprise database.


System Interactions

  1. Device sends data to IOT Cloud Service.
  2. IOT Cloud Service capture the stream of data, filter/clean the data, enrich the data with contextual information made available at device registration and pushes data to REST Endpoint deployed on JCS-SX.
  3. REST Endpoint process the data and call DBCS REST Endpoint to store data along with other enterprise data into the Database Cloud service.
  4. Enterprise Application deployed in JCS-SX fetches data from DBCS to create various metrics and reports for business users



Oracle’s Internet of Things Cloud Service provides integration options that can be leveraged to maximize the value of your device data and to provide useful insight of your IOT deployment.

To know more about Oracle Internet of Things Cloud Service, visit


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