...
Add a new datasource to your model:
- 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
- Double-click on this new database collector to open the details form; . In the Basic Settings section, you will see the query generated in the field Query String Statement Expression
- Close the database collector details form
- In the model window, press Save the model layout
...