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
- 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
- Select
- The Datasource Instances section has its own toolbar. Click
Insert excerpt _
...
addIcon _
...
Insert. PhixFlow opens the settings for a new datasource instance. Set:addIcon nopanel true - Name:
Default
- Enabled:
- Name:
...
-
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
- For the following settings see your training welcome email:
- 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 theInsert excerpt _datasource _datasource nopanel true
...
- popup toolbar, click
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_NUMBERS.Insert 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 nopanel true
...
- you just created.
- In the
...
- popup toolbar, click
Create a new Table using the attributes returned from the query. PhixFlow adds the newInsert excerpt _table_with_attributes_icononly _table_with_attributes_icononly nopanel true
...
- table to your model.
- In the model window, 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 of Views.Insert excerpt _view_show_icononly _view_show_icononly nopanel true
...
- 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