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

Create a new datasource

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
   • Database Driver: select MariaDB
7. The Datasource Instances section has its own toolbar. Click 

   Insert excerpt
   _new _new nopanel true

   . PhixFlow opens the settings for a new datasource instance. Set:
   
   • Name: Default
   • Enabled: tick
   • Authorisation Type: Local
   • URL: jdbc:mariadb://localhost/trainingCRM
   • Username: training CRM
   • Password:  This is provided by PhixFlow support, contact support@phixflow.com and request your password. XBPOaU493wx3amNAGySU
   • 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.

Create a database collector from the datasource schema browser

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

   Insert excerpt
   _datasource _datasource nopanel true

    icon. In the popup toolbar, click  

   Insert excerpt
   _table_database _table_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 popup menu, select Create a Collector. PhixFlow adds a new 

   Insert excerpt
   _database_collector _database_collector nopanel true

   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

   .

Create a table automatically from a database collector

1. Hover your mouse pointer over the

   Insert excerpt
   _database_collector _database_collector nopanel true

    .
2. In the popup toolbar, click 

   Insert excerpt
   _table_with_attributes _table_with_attributes nopanel true

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

   Insert excerpt
   _save _save nopanel true

   .

Run analysis and view the table data

1. To run analysis on your new table hover your mouse pointer over the new table, and in the popup toolbar, click 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

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

   Insert excerpt
   _view_show _view_show nopanel true

   . In the drop-down list, select

   Insert excerpt
   _view_default _view_default nopanel true

   .