...
Add a new datasource to your model:
- Drag Drag - 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 collector 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 Press - Create a new Stream using the attributes returned from the query
...
- Hover over the stream, and press - Run Analysis
View Stream data
...