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

Create a new datasource

Step 1  Add a new datasource to your model

...

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  click 

   Insert excerpt
   _finishsave _finishsave nopanel true

    to save and close the settings.
4. PhixFlow adds the new datasource to your model. In the model toolbar, click 

   Insert excerpt
   _save _save nopanel true

   .

...

1. You will now add more settings to the datasource

...

Double-click your new datasource to open its settings and set the following fields:

1. .
2. In the Basic Settings section:
   
   • Enabled: tick
   • Driver Class: select MariaDB
3. In the The Datasource Instances section , in the toolbar, click 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
   • Click 

     Insert excerpt
     _addfinish _addfinish nopanel true

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

   Insert excerpt
   _addfinish _addfinish nopanel true

    to finish and close.

Create a database collector from the datasource schema browser

1. Hover over the datasource icon in

   In your model

   view, and in the hover menu press Image Removed Show Tables

   , 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

   
   

   Info
   If you cannot see the table required it might be on another page. You can filter on the table name header, or use the paging bar to increase the page size or select the next page.

   
   

2. In the list of tables that appears, find the table called PhixFlow opens, scroll down to the SOURCE_CUSTOMER_PHONE_NUMBERSDouble-click on this row in the schema browser; a new form will pop up showing table name.
   1. To have a look at the data in
   the table
   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
3. Right-click on this row and SOURCE_CUSTOMER_PHONE_NUMBERS and in the pop-up menu, select Create a CollectorA . PhixFlow adds a new database collector  will appear on your  to your model view, to read which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERS.
4. Double-click on this the new database collector to open the details formits settings.
5. In the Basic Settings section → Statement Expression field, you will see the query generated in the field Statement Expressioncan see that PhixFlow has added a database query.
6. Close the database collector details formsettings.
7. In the model window, press Save the model layout, 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 nopanel

2. Press Image Removed Create a new Stream using the attributes returned from the query

...

1. 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,

...

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

   .