By the end of this

page you will be able to:

Create a new datasource

You will now add a new datasource to your Introduction to Modelling analysis model to connect to an external database.

1. Hover your

1. mouse over  

   Insert excerpt
   _database _database nopanel true

   s in the toolbar to show the list of options.

2. Drag a 

   Insert excerpt
   _datasource _datasource nopanel true

    onto the model.

   Expand
   title Can't see this?
   You may need to press  Insert excerpt _more_options _more_options nopanel true , next to  Insert excerpt _database_collector _database_collector nopanel true  in the toolbar, to show the  Insert excerpt _datasource _datasource nopanel true  option.

   
   

3. In the new datasource settings form that opens, enter the Name: CRM

1. In the settings, click 

   Insert excerpt
   _save _save nopanel true

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

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .
3. You will now add more settings to the datasource.
4. In the Basic Settings section:
   
   • Enabled: 

     Insert excerpt
     _toggle_on _toggle_on nopanel true

   • Database Driver: Select MariaDB
5. The Datasource Instances section has its own toolbar. Click 

   Insert excerpt
   _addIcon _addIcon nopanel true

    Insert. PhixFlow opens the settings for a new datasource instance. Set:
   
   • Name: Default
   • Enabled: 

     Insert excerpt
     _toggle_on _toggle_on nopanel true

   • Authorisation Type: Local
   • For the following settings see your training welcome email:
     • URL:           See welcome email
     • Username: See welcome email
     • Password:  See welcome email
   • Click 

     Insert excerpt
     _finish _finish nopanel true

      to finish and close the datasource instance settings.
6. 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

1. CRM 

   Insert excerpt
   _datasource _datasource nopanel true

    icon you just created. In the popup toolbar, click  

   Insert excerpt
   _datasource_show_tables _datasource_show_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 popup menu, select Create a Collector

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

1. .
   1. If the database collector settings are not already open on the right, double-click on

1. 1. the new database collector to open

1. 1. its settings.
2. In the Basic Settings section → Statement Expression field, you can see that PhixFlow has added a database query.
3. Close the database collector

1. settings.
2. In the model

1. toolbar, click 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .

Create a

table automatically from a

database collector

1. Hover your mouse pointer over the SOURCE_CUSTOMER_PHONE_NUMBERS 

   Insert excerpt
   _database_collector _database_collector

1. nopanel true

    you just created.
2. In the popup toolbar, click 

   Insert excerpt
   _table_with_attributes_icononly _table_with_attributes_icononly nopanel true

    Create a new

1. Table using the attributes returned from the query

1. . PhixFlow adds the new table to your model.
2. In the model window,

1. click 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .

Run analysis and view the table data

1. Hover your mouse pointer over your new SOURCE_CUSTOMER_PHONE_NUMBERS table, and in the popup toolbar click 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

   .
2. To view the data you just loaded

1. , hover over the

1. table and click 

   Insert excerpt
   _view_show_icononly _view_show_icononly nopanel true

    Show the list of

1. Views.

1. The SOURCE_CUSTOMER_PHONE_NUMBERS (Default View) window will show like the image below:
   1. Image Added
2. In the model window, click 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .

Check Point

At this point your screen should look like this:

Image Added