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
...
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
...
The new datasource will now show on your modelling pane. Press Save the model layout
...
- 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
- Name:
...
- 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
- Enabled:
- 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
you just created.Insert excerpt _database_collector _database_collector nopanel true - In the popup toolbar, click
Create a new Table using the attributes returned from the queryInsert excerpt _table_with_attributes_icononly _table_with_attributes_icononly nopanel true
...
- . 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 Removed - Run Analysis
- See the run complete in the Console
...
- 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