By the end of this chapter you will be able to:
...
- Create Datasourcesdatasources
- Create Database Collectors database collectors from the Datasource datasource schema browser
- Create Streams streams automatically from Database Collectors
...
- database collectors
Create a new
...
datasource
Add a new Datasource datasource to your model:
- Drag
Drag - Add a new Datasource onto the modelling pane
- In the new Datasource form that pops up, enter a the Name:
CRM - Press OK
The new Datasource datasource will now show on your modelling pane. Press Save the model layout.
- Double-click your new Datasource 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
- 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://
mysql:3306 - Name:
- cview
phixflow- Anonymous Username:
cview - Password:
cview
anchor_GoBack _GoBack Press
- Back in the Datasource datasource details form, press
...
...
Create a
...
database collector from the
...
datasource schema browser
- Hover over the Datasource 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
database collector - Double-click on this new Database Collector database collector to open the details form; you will see the query generated in the tab field Query String
- Close the Database Collector 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 CollectorPress
database collector - Press
In your model, you will see the new Stream stream that has been created.
In the model window, press Save the model layout.
...
...
Run Analysis on Stream
Run Analysis analysis on your new Streamstream:
- Hover over the stream, and press
- See the run complete in the Console
...
View Stream data
To view the data you just loaded:
- Hover over the Stream stream and in the hover menu press
- In the drop down list, select Default View