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

Create a new datasource

...

Info
This step is not available within the training instance since database passwords cannot be shared here. However, read the steps to understand the process. Then jump below to continue from "Create a database collector from the datasource schema browser". Use the datasource "CenterView" by dragging it from the repository onto the 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 

   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
   • Driver Class: select MariaDB
7. 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
   • 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 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 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 pop-up menu, select Create a Collector. PhixFlow adds a new database collector  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

   .

...