1. Developing Applications with Oracle Internet of Things Cloud Service
  2. Integrate with External Services
  3. Integrate Oracle Business Intelligence Cloud Service with Oracle Internet of Things Cloud Service

Integrate Oracle Business Intelligence Cloud Service with Oracle Internet of Things Cloud Service

Use your existing Oracle Business Intelligence Cloud Service instance to analyze device message data. To perform the analysis, use this procedure to integrate your existing Oracle Business Intelligence Cloud Service with your Oracle Internet of Things Cloud Service instance.

These are the prerequisites for the successful completion of this procedure:

  • An active Oracle Business Intelligence Cloud Service instance.

  • An active Oracle Internet of Things Cloud Service instance.

  • An Oracle Internet of Things Cloud Service application.

  • A device model associated with the Oracle Internet of Things Cloud Service application. The device model determines what message format can be used in the data stream. See Assigning a Device Model to a Cloud Service.

  1. Log on to your Oracle Internet of Things Cloud Service instance.
  2. Click Menu Menu icon and click Applications.
  3. Click an application to integrate with your Oracle Business Intelligence Cloud Service instance.
  4. Create the integration:
    1. Click Integration.
    2. Click Create Integration if this is your first integration, or click Add if you have existing integrations.
    3. Select Business Intelligence Cloud Service.
    4. Complete these fields:

      • Name Enter a name for the integration.

      • Description (Optional) Enter an optional description for the integration.

      • URL: Enter the URL for the Oracle Internet of Things Cloud Service instance.

      • Identity Domain: Enter the identity domain for the Oracle Internet of Things Cloud Service instance.

      • Username: Enter the user name for the Oracle Internet of Things Cloud Service instance.

      • Password: Enter the password for the Oracle Internet of Things Cloud Service instance.

    5. (Optional) Click Verify Connectivity to test the connection between the Oracle Internet of Things Cloud Service instance and the target service or application.
      The connectivity test can include:

      • DNS Resolution Test: Checks whether the server name resolves to an IP address.

      • Connectivity Test: Checks whether the IP address is reachable.

      • IP/Port test: Checks whether you can talk to the target URL on the specified port.

      • SSL Verification Test: Checks whether you have a secured, or trusted, connection to the target. Applies only if the target is an SSL endpoint.

      • Authentication Test: Checks whether you can exchange messages with the target.

    6. Click Create.
  5. Select the integration you created in step 4 and then click Edit Edit icon.
  6. Define the data stream for the Oracle Internet of Things Cloud Service instance:
    1. Click Streams tab.
    2. Click Create a Stream.
    3. In the BICS Table Name field, enter the name of the Oracle Business Intelligence Cloud Service table that will hold the Oracle Internet of Things Cloud Service device data.
    4. Select a message format for the data stream in the Message Format list.
    5. Select the metadata types to add to the outgoing stream in the Annotations field. An annotation is the data type that you want to retrieve from the device message stream.
    6. (Optional) Click + to add more message formats.
    7. Click Save.
  7. Click Synchronize Now to synchronize the Oracle Business Intelligence Cloud Service and Oracle Internet of Things Cloud Service data.
  8. Select the integration you created in step 4 and then click Edit (Edit icon).
  9. Click the Synchronization tab.
  10. Select the Automatic Synchronization check box to enable automatic batch synchronization.
  11. Select a synchronization interval in the Synchronization Interval list.
    Some data streams may not get updated during the synchronization process. The synchronization operation may take some time to complete. A progress indicator indicates the synchronization status.
  12. Click the Messages tab to view data messages that are streaming from the devices that are online.
  13. Click Save to save your changes to the Oracle Business Intelligence Cloud Service integration.
  14. Log on to your Oracle Business Intelligence Cloud Service instance and confirm the table you created in step 6 is being populated with Oracle Internet of Things Cloud Service data.