Page Comparison

...

1. From the model toolbar, drag a 

   Insert excerpt
   _datasource _datasource nopanel true

    onto the model.
2. In the new datasource settings form that opens, enter the Name: CRM
3. In the settings toolbar, click 

   Insert excerpt
   _save _save nopanel true

   .
4. PhixFlow adds the new datasource to your model. In the model toolbar, click 

   Insert excerpt
   _save _save nopanel true

   .
5. You will now add more settings to the datasource.
6. In the Basic Settings section:
   
   • Enabled: tick
   • Driver Class: select MariaDB
7. The Datasource Instances section has its own toolbar. Click 

   Insert excerpt
   _addnew _addnew nopanel true

   . PhixFlow opens the settings for a new datasource instance. Set:
   
   • Name: Default
   • Enabled: tick
   • Authorisation Type: Local
   • URL: jdbc:mariadb://localhost/phixflow
   • Username: cview phixflow
   • Password: cview  This is provided by PhixFlow support with your training link.
   • Click 

     Insert excerpt
     _finish _finish nopanel true

      to finish and close the datasource instance settings.
8. Back in the datasource settings, click 

   Insert excerpt
   _finish _finish nopanel true

    to finish and close.

...

1. In your model, hover your mouse pointer over the 

   Insert excerpt
   _datasource _datasource nopanel true

    icon. In the pop-up toolbar, click  

   Insert excerpt
   _table_tablesdatabase _tablestable_database nopanel true

2. In the list of tables that PhixFlow opens, scroll down to the SOURCE_CUSTOMER_PHONE_NUMBERS table name.
   1. To have a look at the data in this table, double-click its name.
   2. You can see there are columns for ##CUSTOMER_REF and ##PHONE_NUMBER.
   3. Close this data form
3. Right-click SOURCE_CUSTOMER_PHONE_NUMBERS and in the pop-up menu, select Create a Collector. PhixFlow adds a new database collector  to your model, which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERS.
4. Double-click on the new database collector to open its settings.
5. In the Basic Settings section → Statement Expression field, you can see that PhixFlow has added a database query.
6. Close the database collector settings.
7. In the model, click 

   Insert excerpt
   _save _save nopanel true

   .

...

1. Hover your mouse pointer over the

   Insert excerpt
   _database_collector _database_collector nopanel true

    .
2. In the pop-up toolbar, click 

   Insert excerpt
   _streamtable_with_attributes _streamtable_with_attributes nopanel true

   . PhixFlow adds the new stream to your model.
3. In the model window, click 

   Insert excerpt
   _save _save nopanel true

   .

...

1. To run analysis on your new stream hover your mouse pointer over the new stream, and in the pop-up toolbar, click 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

   .
2. To view the data you just loaded, hover over the stream and click 

   Insert excerpt
   _streamview_viewsshow _streamview_viewsshow nopanel true

   . In the drop-down list, select

   Insert excerpt
   _view_default _view_default nopanel true

   .