Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
By the end of this
...
page you will be able to:
...
Table of Contents | ||||
---|---|---|---|---|
|
Create a new datasource
...
You will now add a new datasource to your Introduction to Modelling analysis model to connect to an external database.
Hover your
...
The new datasource will now show on your modelling pane. Press Save the model layout
...
- Tick the Enabled flag
- Select the Driver Class: MySQL
- Go to the Datasource Instances section
- Press Image Removed – 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
- Name:
- Press Image Removed
...
mouse over
s in the toolbar to show the list of options.Insert excerpt _database _database nopanel true Drag a
onto the model.Insert excerpt _datasource _datasource nopanel true Expand title Can't see this? - You may need to press
, next toInsert excerpt _more_options _more_options nopanel true
in the toolbar, to show theInsert excerpt _database_collector _database_collector nopanel true
option.Insert excerpt _datasource _datasource nopanel true
- You may need to press
- In the new datasource settings form that opens, enter the Name:
CRM
...
- In the settings, click
.Insert excerpt _save _save nopanel true - PhixFlow adds the new datasource to your model. In the model toolbar, click
.Insert excerpt _save_saveModel _save_saveModel nopanel true - You will now add more settings to the datasource.
- In the Basic Settings section:
- Enabled:
Insert excerpt _toggle_on _toggle_on nopanel true - Database Driver: Select
MariaDB
- Enabled:
- The Datasource Instances section has its own toolbar. Click
Insert. PhixFlow opens the settings for a new datasource instance. Set:Insert excerpt _addIcon _addIcon nopanel true - Name:
Default
- Enabled:
Insert excerpt _toggle_on _toggle_on nopanel true - Authorisation Type: Local
- For the following settings see your training welcome email:
- URL: See welcome email
- Username: See welcome email
- Password: See welcome email
- Click
to finish and close the datasource instance settings.Insert excerpt _finish _finish nopanel true
- Name:
- Back in the datasource settings, click
to finish and close.Insert excerpt _finish _finish nopanel true
Create a database collector from the datasource schema browser
...
- In your model, hover your mouse pointer over the
...
- CRM
icon you just created. In the popup toolbar, clickInsert excerpt _datasource _datasource nopanel true Insert excerpt _datasource_show_tables _datasource_show_tables nopanel true - In the list of tables that
...
- PhixFlow opens, scroll down to the SOURCE_CUSTOMER_PHONE_NUMBERS
...
- table name.
- To have a look at the data in
...
- this table, double-click its name.
- You can see there are columns for ##CUSTOMER_REF and ##PHONE_NUMBER.
- Close this data form
- Right-click
...
-
SOURCE_CUSTOMER_PHONE_NUMBERS
and in the popup menu, select Create a Collector
...
- . PhixFlow adds a new
to your model, which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERSInsert excerpt _database_collector _database_collector nopanel true
...
- .
- If the database collector settings are not already open on the right, double-click on
...
- the new database collector to open
...
- its settings.
- In the Basic Settings section → Statement Expression field, you
...
- can see that PhixFlow has added a database query.
- Close the database collector
...
- settings.
- In the model
...
- toolbar, click
.Insert excerpt _save_saveModel _save_saveModel nopanel true
Create a
...
table automatically from a
...
database collector
- Hover your mouse pointer over the SOURCE_CUSTOMER_PHONE_NUMBERS
Insert excerpt _database_collector _database_collector
...
you just created.nopanel true - In the popup toolbar, click
Create a newInsert excerpt _table_with_attributes_icononly _table_with_attributes_icononly nopanel true
...
- Table using the attributes returned from the query
...
- . PhixFlow adds the new table to your model.
- In the model window,
...
Run Analysis on Stream
Run analysis on your new stream:
- Hover over the stream, and press Image RemovedRun Analysis
...
- click
.Insert excerpt _save_saveModel _save_saveModel nopanel true
Run analysis and view the table data
- Hover your mouse pointer over your new SOURCE_CUSTOMER_PHONE_NUMBERS table, and in the popup toolbar click
.Insert excerpt _run_analysis _run_analysis nopanel true - To view the data you just loaded
...
- , hover over the
...
- table and click
Show the list ofInsert excerpt _view_show_icononly _view_show_icononly nopanel true
...
- Views.
...
- The SOURCE_CUSTOMER_PHONE_NUMBERS (Default View) window will show like the image below:
- Image Added
- In the model window, click
.Insert excerpt _save_saveModel _save_saveModel nopanel true
Check Point
At this point your screen should look like this:
Image Added