Use Contextual Data Connections

Contextual data connections let you access factory and machine related data from database tables. You can use a Database Classic Cloud Service instance to store your data. You can also use an Autonomous Transaction Processing database table.

You may have contextual data stored in external systems, such as supply chain planning or maintenance systems, and you may want to use this contextual data feed in the Production Monitoring application to define metrics and perform analytics.

Create a Contextual Data Connection to an Oracle Autonomous Transaction Processing Instance

Create a contextual data connection to link to an Autonomous Transaction Processing database table. You can use the data in the table for metric computations and analytics.

1. Click Menu and then click Design Center.
2. Select Organization from the Design Center menu.
3. Click Contextual Data .
4. Click Add .
5. Enter a Name and an optional Description for the contextual data connection.
6. Under Data Format, select ATP as the database Type.
7. Enter the name of your ATP database table in the Table Name field.
8. Click Choose File to select the wallet file required to connect to your ATP instance.
   Oracle client credentials (wallet files) are downloaded from ATP by a service administrator. If you are not an ATP administrator, your administrator should provide you with the client credentials.
   The wallet file for the ATP database can be downloaded from the ATP service console.
9. Enter the Connection String to use for the Autonomous Transaction Processing instance.
   For example, a simple connection string would look like the following:

   database_host[:port][/[service_name]

10. Enter the user name for connecting to the Autonomous Transaction Processing database in the User Name field.
11. Enter the password for the user in the Password field.
12. If you are creating a new table, then under the Fields section, click Create New () to add a table column.
    Specify a Name and Type (data type) for each table column that you add. Select Primary Key when adding the primary key column.
13. Under Associations, you can associate the ATP table fields with their corresponding sensor attributes.
    1. Click Add and select a Name for the association.
    2. Under From, select a machine type.
    3. Select a sensor attribute from the list of sensor attributes available for the machine type.
    4. Under To, select the corresponding ATP table column.
    5. Add additional sensor attributes to column associations, as required.
14. Click Save to create the contextual data connection.

Create a Contextual Data Connection to a Database Classic Cloud Service Instance

Create a contextual data connection to link to a Database Classic Cloud Service table. You can use the data in the table for KPI computations and predictive analytics.

1. Click Menu and then click Design Center.
2. Select Organization from the Design Center menu.
3. Click Contextual Data .
4. Click Add .
5. Enter a Name and an optional Description for the contextual data connection.
6. Select DBaaS in the Type list.
7. Enter the name of a table in the Table Name field.
   1. Select Table already exists if the table is already present in the DBaaS database.
8. Enter the URL for the Database Classic Cloud Service instance in the Connection String field.
9. Enter the user name for the Database Classic Cloud Service instance in the User Name field.
10. Enter the password for the Database Classic Cloud Service instance in the Password field.
11. If you are creating a new table, then under the Fields section, click Add () to add a table column.
    Specify a Name and Type (data type) for each table column that you add. Select Primary Key when adding the primary key column.
12. Under Associations, associate the DBaaS table fields with their corresponding machine type attributes.
    1. Click Add to create a new association.
    2. Enter a Name for the association.
    3. Under From, select a machine type and a machine type attribute.
    4. Under To, select the corresponding DBaaS table column or field.
    5. Click OK.
    6. Add additional associations, as required.
13. Click Save to create the contextual data connection.