...
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
...
- 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:
- Name:
Default
- URL:
jdbc:mariadb://mysql:3306localhost/cviewphixflow
- Anonymous Username:
cview
- Password:
cview
- Name:
- 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 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
...