...

• Create datasources
• Create database collectors from the datasource schema browser
• Create streams automatically from database collectors

Create a new datasource

Step 1  Add a new datasource to your model

...

1. Drag Image Modified Add a new Datasource onto the modelling pane
2. In the new

...

1. datasource settings form that pops up, enter the Name: CRM

...

2. In the toolbar, click 

   Insert excerpt
   _add _add nopanel true

    to save and close the settings.
3. The new datasource will now show on your modelling pane.

...

1. Click 

   Insert excerpt
   _save _save

    to save the model.

Step 2  Set up the datasource

Double-click your new datasource to open

...

its settings and set the following fields:

1. In the Basic Settings section:
   
   • Enabled: tick
   • Driver Class: select MariaDB
2. In the Datasource Instances section

...

1. , in the toolbar, click 

   Insert excerpt
   _add _add nopanel true

   .
2. PhixFlow opens the settings for a new datasource instance. Set:
   
   • Name: Default
   • Enabled: tick
   • URL: jdbc:mariadb://localhost/phixflow
   • Anonymous Username: cview
   • Password: cview

...

1. • Click 

     Insert excerpt
     _add _add nopanel true

      to finish and close the datasource instance settings.
2. Back in the datasource

...

1. settings, click 

   Insert excerpt
   _add _add nopanel true

    to finish and close.

Create a database collector from the datasource schema browser

1. Hover over the datasource icon in your model view, and in the hover menu press Image Modified Show Tables
2. In the list of tables that appears, find the table called SOURCE_CUSTOMER_PHONE_NUMBERS
3. Double-click on this row in the schema browser; a new form will pop up showing the data in the table
4. Close this data form
5. Right-click on this row and select Create a Collector
6. A new database collector Image Modified will appear on your model view, to read data from the table SOURCE_CUSTOMER_PHONE_NUMBERS
7. Double-click on this new database collector to open the details form. In the Basic Settings section, you will see the query generated in the field Statement Expression
8. Close the database collector details form
9. In the model window, press Save the model layout

Create a Stream automatically from a Database Collector

1. Hover over the database collector
2. Press Image Modified Create a new Stream using the attributes returned from the query

In your model, you will see the new stream that has been created.
In the model window, press Save the model layout.

...