...

• Create Datasources
• Create Database Collectors from the Datasource schema browser
• Create Streams automatically from Database Collectors

Anchor
_Toc442889045 _Toc442889045

Create a new Datasource

Add a new Datasource to your model:

...

• Double-click your new Datasource to open the details form
• Complete the configuration:
• (You will already been in the Details pane)
• Tick the Enabled flag
• Select the Driver Class: MySQL
• Select the Datasource Instances tab
• Press  – Add a new item
• In the new Datasource Instance form that pops up, enter the following details:
  • Name: Default
  • URL: jdbc:mariadb://mysql:3306/cview
  • Anonymous Username: cview
  • Password: cview

    Anchor
    _GoBack _GoBack

  • Press 
• Back in the Datasource details form, press 

Anchor
_Ref348595761 _Ref348595761

Anchor
_Toc442889046 _Toc442889046

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; you will see the query generated in the tab Query String
• Close the Database Collector details form
• In the model window, press Save the model layout

Anchor
_Ref348597228 _Ref348597228

Anchor
_Toc442889047 _Toc442889047

Create a Stream automatically from a Database Collector

• Hover over the Database Collector
• Press - 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.

Anchor
_Toc442889048 _Toc442889048

Run Analysis on Stream

Run Analysis on your new Stream:

• Hover over the stream, and press  - Run Analysis
• See the run complete in the Console

Anchor
_Toc442889049 _Toc442889049

View Stream data

To view the data you just loaded:

...