By the end of this page you will be able to:
Table of Contents |
---|
maxLevel | 1 |
---|
exclude | Run analysis* |
---|
|
Create a new datasource
- From the model toolbar, drag a
Insert excerpt |
---|
| _datasource |
---|
| _datasource |
---|
nopanel | true |
---|
|
onto the model. - In the new datasource settings form that opens, enter the Name:
CRM
- In the settings toolbar, click .
- PhixFlow adds the new datasource to your model. In the model toolbar, click .
- You will now add more settings to the datasource.
- In the Basic Settings section:
- Enabled: tick
- Database Driver: select
MariaDB
- The Datasource Instances section has its own toolbar. Click . PhixFlow opens the settings for a new datasource instance. Set:
- Name:
Default
- Enabled: tick
- Authorisation Type: Local
- URL:
jdbc:mariadb://localhost/training
- Username:
training
- Password: This is provided by PhixFlow support, contact support@phixflow.com and request your password.
- Click
Insert excerpt |
---|
| _finish |
---|
| _finish |
---|
nopanel | true |
---|
|
to finish and close the datasource instance settings.
- Back in the datasource settings, click
Insert excerpt |
---|
| _finish |
---|
| _finish |
---|
nopanel | true |
---|
|
to finish and close.
Create a database collector from the datasource schema browser
- In your model, hover your mouse pointer over the
Insert excerpt |
---|
| _datasource |
---|
| _datasource |
---|
nopanel | true |
---|
|
icon. In the popup toolbar, click Insert excerpt |
---|
| _table_database |
---|
| _table_database |
---|
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 database collector