Click Apply and Close to finish and close the datasource instance settings.
Back in the datasource settings, click Apply and Close to finish and close.
Create a database collector from the datasource schema browser
In your model, hover your mouse pointer over the CRMDatasource icon you just created. In the popup toolbar, click Show Tables
In the list of tables that PhixFlow opens, scroll down to the SOURCE_CUSTOMER_PHONE_NUMBERS table name.
To have a look at the data in this table, double-click its name.
You can see there are columns for ##CUSTOMER_REF and ##PHONE_NUMBER.
Close this data form
Right-click SOURCE_CUSTOMER_PHONE_NUMBERS and in the popup menu, select Create a Collector. PhixFlow adds a new Database Collector to your model, which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERS.
If the database collector settings are not already open on the right, double-click on the new database collector to open its settings.
In the Basic Settings section → Statement Expression field, you can see that PhixFlow has added a database query.
Close the database collector settings.
In the model toolbar, click Save.
Create a table automatically from a database collector
Hover your mouse pointer over the SOURCE_CUSTOMER_PHONE_NUMBERSDatabase Collector you just created.
In the popup toolbar, click Create a new Table using the attributes returned from the query. PhixFlow adds the new table to your model.
In the model window, click Save.
Run analysis and view the table data
Hover your mouse pointer over your new new SOURCE_CUSTOMER_PHONE_NUMBERS table, and in the popup toolbar click Run Analysis.
To view the data you just loaded, hover over the table and click Show the list of Views.
TheSOURCE_CUSTOMER_PHONE_NUMBERS (Default View)window will show like the image below: