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

...

  • Double-click your new datasource to open the details form
  • Complete the configuration:
    • Tick the Enabled flag
    • Select the Driver Class: MySQL
    • Go to the Datasource Instances section
    • Press Insert
    • In the new datasource instance form that pops up, enter the following details:
    • Press 
  • Back in the datasource details form, press 

...

  • 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 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 to open the details form; you will see the query generated in the field Query String
  • Close the database collector details form
  • In the model window, press Save the model layout

...

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

...

  • Hover over the stream, and press Image Modified - Run Analysis

View Stream data

...