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

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

Create a new datasource

Add a new datasource to your model:

• Drag  Add a new Datasource onto the modelling pane
• In the new Datasource settings that pops up, enter the Name: CRM
• Click  OK 

The new datasource will now show on your modelling pane. Press Save the model layout

• Double-click your new datasource to open the details form
• Complete the configuration:
  
  • Tick the Enabled flag
  • Select the Driver Class: MariaDB
  • Go to the Datasource Instances section
  • Press  Insert
  • In the new datasource instance form that pops up, enter the following details:
    • Name: Default
    • URL: jdbc:mariadb://localhost/phixflow
    • Anonymous Username: cview
    • Password: cview
    • Click  OK 
• Back in the datasource settings, click  OK 

Create a database collector from the datasource schema browser

• Hover over the datasource icon in your model view, and in the hover menu press  Show Tables
• In the list of tables that appears, find the table called SOURCE_CUSTOMER_PHONE_NUMBERS
• Double-click on this row in the schema browser; a new form will pop up showing the data in the table
• Close this data form
• Right-click on this row and select Create a Collector
• A new database collector  will appear on your model view, to read data from the table SOURCE_CUSTOMER_PHONE_NUMBERS
• 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
• Close the database collector details form
• In the model window, press Save the model layout

Create a Stream automatically from a Database Collector

• Hover over the database collector
• Click 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, click  Save the model layout.

Run Analysis on Stream

Run analysis on your new stream:

• Hover over the stream, and press Run Analysis

View Stream data

To view the data you just loaded:

• Hover over the stream and in the hover menu press  Show the list of Stream Views
• In the drop down list, select Default View