PhixFlow Help
3 Creating Datasources and Database Collectors
By the end of this page you will be able to:
Create a new datasource
- From the model toolbar, drag a Datasource onto the model.
- In the new datasource settings form that opens, enter the Name:
CRM
- In the settings toolbar, click Save.
- PhixFlow adds the new datasource to your model. In the model toolbar, click Save.
- You will now add more settings to the datasource.
- In the Basic Settings section:
- Enabled: tick
- Driver Class: select
MariaDB
- The Datasource Instances section has its own toolbar. Click Add. 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 OK to finish and close the datasource instance settings.
- Name:
- Back in the datasource settings, click OK to finish and close.
Create a database collector from the datasource schema browser
- In your model, hover your mouse pointer over the Datasource icon. In the pop-up toolbar, click Tables
- 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 pop-up menu, select Create a Collector. PhixFlow adds a new database collector to your model, which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERS. - 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, click Save.
Create a stream automatically from a database collector
- Hover your mouse pointer over the Database Collector .
- In the pop-up toolbar, click Add Stream Using Attributes. PhixFlow adds the new stream to your model.
- In the model window, click Save.
Run analysis and view the stream data
- To run analysis on your new stream hover your mouse pointer over the new stream, and in the pop-up toolbar, click Run Analysis.
- To view the data you just loaded, hover over the stream and click Stream Views. In the drop-down list, select Default View.
Please let us know if we could improve this page feedback@phixflow.com