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

Create a new datasource

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

1. Hover your 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
4. In the settings, click 

   Insert excerpt
   _save _save nopanel true

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

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

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

     Insert excerpt
     _toggle_on _toggle_on nopanel true

   • Database Driver: Select MySQL
8. 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
   • URL: jdbc:mysql://localhost/CRM
   • Username: CRM
   • Password:  XBPOaU493wx3amNAGySU
   • Click 

     Insert excerpt
     _finish _finish nopanel true

      to finish and close the datasource instance settings.
9. 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 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 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.
   1. If the database collector settings are not already open on the right, double-click on the new database collector to open its settings.
4. In the Basic Settings section → Statement Expression field, you can see that PhixFlow has added a database query.
5. Close the database collector settings.
6. In the model 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 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 Table using the attributes returned from the query. PhixFlow adds the new table to your model.
3. In the model window, 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, hover over the table and click 

   Insert excerpt
   _view_show_icononly _view_show_icononly nopanel true

    Show the list of Views.
3. The SOURCE_CUSTOMER_PHONE_NUMBERS (Default View) window will show like the image below:
   1. Image Modified
4. In the model window, click 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .

Check Point

At this point your screen should look like this: