By the end of this chapter page you will be able to:

...

Create a new datasource

1. From the model toolbar, drag a 

   Insert excerpt
   _datasource

Add a new datasource to your model:

...

1. _datasource nopanel true

    onto the model.
2. In the new

...

1. datasource settings form that

...

1. opens, enter the Name: CRM

...

The new datasource will now show on your modelling pane. Press Save the model layout

...

2. In the settings toolbar, click 

   Insert excerpt
   _save _save nopanel true

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

   Insert excerpt
   _save _save nopanel true

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

   Insert excerpt
   _add _add nopanel true

   . PhixFlow opens the settings for a new datasource instance. Set:
   
   • Name: Default
   • Enabled: tick
   • URL: jdbc:mariadb://localhost/phixflow
   • Anonymous Username: cview
   • Password: cview

...

1. • Click 

     Insert excerpt
     _finish _finish nopanel true

      to finish and close the datasource instance settings.
2. Back in the datasource

...

1. settings, click 

   Insert excerpt
   _finish _finish nopanel true

    to finish and close.

Create a database collector from the datasource schema browser

...

1. In your model

...

1. , hover your mouse pointer over the 

   Insert excerpt
   _datasource _datasource nopanel true

    icon. In the pop-up toolbar, click  

   Insert excerpt
   _tables _tables nopanel true

2. In the list of tables that

...

1. PhixFlow opens, scroll down to the SOURCE_CUSTOMER_PHONE_NUMBERS

...

1. table name.
   1. To have a look at the data in

...

1. 1. this table, double-click its name.
   2. You can see there are columns for ##CUSTOMER_REF and ##PHONE_NUMBER.
   3. Close this data form
2. Right-click

...

1. SOURCE_CUSTOMER_PHONE_NUMBERS and in the pop-up menu, select Create a Collector

...

1. . PhixFlow adds a new database collector Image Modified

...

1.  to your model

...

1. ,

...

1. which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERS.
2. Double-click on

...

1. the new database collector to open

...

1. its settings.
2. In the Basic Settings section → Statement Expression field, you

...

1. can see that PhixFlow has added a database query.
2. Close the database collector

...

1. settings.
2. In the model

...

1. , click 

   Insert excerpt
   _save _save nopanel true

   .

Create a

...

stream automatically from a

...

database collector

1. Hover your mouse pointer over the

   Insert excerpt
   _database_collector _database_collector

...

1. nopanel true

    .
2. In the pop-up toolbar, click 

   Insert excerpt
   _stream_with_attributes _stream_with_attributes nopanel true

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

...

Run Analysis on Stream

...

1. click 

   Insert excerpt
   _save _save nopanel true

   .

Run analysis and view the stream data

1. To run analysis on your new stream

...

1. hover your mouse pointer over the new stream, and

...

1. in the pop-up toolbar, click 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

   .
2. To view the data you just loaded

...

1. , hover over the stream and

...

1. click 

   Insert excerpt
   _stream_views _stream_views nopanel true

   . In the drop-down list,

...

1.  select

   Insert excerpt
   _view_default _view_default nopanel true

   .