Add Stream Explorer References to Static Data

Add references to enrich messages sent by devices to analyze and process the data. Once the data appears in the messages source, you can explore and enrich the data.

To add a database table to the list of available exploration sources:

1. Go to the Explorations tab in the Data and Exploration page of your application. The upper part of the page allows you to add and delete exploration sources which can be device messages, database tables, or maps. The lower part allows you to add, edit, and delete explorations. Use the Add, Edit, and Delete icons to perform required actions.

2. Click the Add icon in the exploration source section, enter a name for the new source, and select Database as the source type.

3. If your database connection is already defined, select it from the list. Otherwise, select Create a New Connection, enter the database connection details, and click Create. The connection details are similar to the ones required when configuring DBaaS as a connection in SQL developer.

4. Select a table from the list in the Table or View field.

To select the database table as a source in an existing exploration:

1. In the Exploration tab, select the exploration you want to modify and then click Edit.

2. Click anywhere inside the Sources box.

3. Select the name of the database table exploration source created in step 1.

4. Select a property from the device message source and database table source to correlate in the Correlation box.

Based on the correlation properties defined, incoming device messages will be enriched in the live data stream.