1. Developing Applications with Oracle Internet of Things Cloud Service
  2. Develop Analytics in IoT Cloud Service
  3. Use Links to Integrate Data Sources
  4. Use Links to Access Oracle Cloud Infrastructure Object Storage Classic

Use Links to Access Oracle Cloud Infrastructure Object Storage Classic

Use links to access Oracle Cloud Infrastructure Object Storage Classic. Use Oracle Cloud Infrastructure Object Storage Classic links to upload files with data that you can use in your analytics, typically data from on premises systems.

Before configuring a link to read or write to Oracle Cloud Infrastructure Object Storage Classic you need the following items:

  • AnOracle Cloud Infrastructure Object Storage Classic instance with a container. You need the URL to your Oracle Cloud Infrastructure Object Storage Classic instance, the connection token, a user name, and a password.

  • The name of the container you create in Oracle Cloud Infrastructure Object Storage Classic must:

    • Start with an alphanumeric character.

    • Contain only alphanumeric characters and dashes followed and preceded by alphanumeric characters (consecutive dashes aren’t allowed).

    • Be between 3 and 63 characters long.

  • An analytics object to store the data that you read or write to Oracle Cloud Infrastructure Object Storage Classic.

  1. Go to your IoT application, select Analytics, and then select Links.
  2. Create the link:
    1. If this is your first link, click Create Link. Otherwise, click Add next to the Search field.
    2. Enter a name to identify your link.
      The name must only contain alphanumeric characters and must not contain spaces.
    3. (Optional) Enter a brief description.
    4. Click Create.
  3. From the Type list, select Oracle Storage Cloud Service.
    The properties below the Type list change.
  4. From the Analytics Object list, select an analytics object to used to provide the result of your query.
  5. From the Key list, select a key.
    The list of primary keys corresponds to the fields in the analytics object that you selected before.

    When you create new records from the analytics processor or the application’s REST API, the primary key field is automatically generated.

    You can use the primary key in the following situations:

    • In the analytics processor’s code, use this primary key with the Spark API classes PairDataOutput and JavaPairRDD.

    • When obtaining (get), updating, or deleting records from the analytics processor or using the applications REST API, use the primary key to identify the record to use in the operation.

  6. From the File Format list, select a file format to store the data in Oracle Cloud Infrastructure Object Storage Classic.
    Available formats are:
    • AVRO
    • JSON
    • TEXT
  7. In the Container field, enter the name of your container in Oracle Cloud Infrastructure Object Storage Classic.
    For more information, see Creating Containers in Using Oracle Cloud Infrastructure Object Storage Classic.
  8. Enter the name of the object to store in Oracle Cloud Infrastructure Object Storage Classic.
  9. In the Auth URL field, enter the URL to your instance of Oracle Cloud Infrastructure Object Storage Classic.
    You can find the name of the host in the email you received when you acquired your subscription to Oracle Cloud Infrastructure Object Storage Classic, or in the Dashboard page for Oracle Cloud My Services.
  10. In the Auth URL field, enter the connection token for Oracle Cloud Infrastructure Object Storage Classic.
    For information on how to obtain this connection token, see Authenticating Access to Oracle Storage Cloud Service in Using Oracle Cloud Infrastructure Object Storage Classic.
  11. Enter the user name to access Oracle Cloud Infrastructure Object Storage Classic.
  12. Enter the password for the user name that you provided in the previous step.
  13. (Optional) Select Use from Worksheets to be able to query this link from the queries in your worksheets.
    If you select this option, then you can use this link in the from clause of your query.
    For example: 
    select * from MyLink
  14. Click Save.
The Oracle Storage Cloud Service link is saved.

You can use this link in the following ways:

  • If you add this link to your analytics processor and generate the source template, the source template will include a line of code that injects this link into your analytics processor.

  • If you selected Use from Worksheets, you can use this link in the from clause of the queries in your worksheets.