Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Add a new datasource to your model:

  • Drag Image Removed Drag Image Added - Add a new Datasource onto the modelling pane
  • In the new Datasource form that pops up, enter the Name: CRM
  • Press OK

...

  • Hover over the datasource icon in your model view, and in the hover menu press - Show Tables
  • In the list of tables that appears, find the table called SOURCE_CUSTOMER_PHONE_NUMBERS
  • Double-click on this row in the schema browser; a new form will pop up showing the data in the table
  • Close this data form
  • Right-click on this row and select Create a Collector
  • A new Database Collector Image Removed database collector Image Added will appear on your model view, to read data from the table SOURCE_CUSTOMER_PHONE_NUMBERS
  • Double-click on this new Database Collector database collector to open the details form; you will see the query generated in the tab field Query String
  • Close the Database Collector database collector details form
  • In the model window, press Save the model layout

Create a Stream automatically from a Database Collector

  • Hover over the Database CollectorPress Image Removed database collector
  • Press Image Added - Create a new Stream using the attributes returned from the query

In your model, you will see the new Stream stream that has been created.
In the model window, press Save the model layout.

Run Analysis on Stream

Run Analysis analysis on your new Streamstream:

  • Hover over the stream, and press Image Modified - Run Analysis
  • See the run complete in the Console

View Stream data

To view the data you just loaded:

  • Hover over the Stream stream and in the hover menu press  - Show the list of Stream Views
  • In the drop down list, select Default View