Overview

Importing data from a database requires three modelling objects:

1. Datasource: Provides the connection to the database.
2. Database Collector: retrieves data from the datasource using a SQL command.
3. Table: The location in PhixFlow to hold the data.

Solution

1. Setting up the Datasource

1. From the Create section of the toolbar click Database.
2. Drag Datasource onto the canvas.
3. In the properties window that opens on the right:
   1. Enter a Name.
   2. Select a Database Driver class.
   3. Add a datasource instance:
      1. Enter a Name.
      2. Enter the URL for the database.
      3. Specify the Username and Password.
      4. Tick the Enabled check box when it is ready to use.
   4. Tick the Enabled check box when it is ready to use.
   5. We recommend you tick Protect during import to prevent this datasource being updated or deleted during import.
   6. Other settings are optional.
   7. Save 

      Insert excerpt
      _finish _finish nopanel true

       your changes.

2. Database Collector

1. Hover over the datasource and click

   Insert excerpt
   _datasource_show_tables _datasource_show_tables nopanel true

   , all available tables will be listed.
2. Right click on the desired table and click create a collector.
3. A database collector is created and set to import all data.
   1. If you wish to edit what data is retrieved, edit the Statement Expression in the properties window open on the right. For more information on editing the Statement Expression see Database Collector Properties.
   2. Save 

      Insert excerpt
      _finish _finish nopanel true

       your changes.

3. Table

1. Hover over the Database Collector and click 

   Insert excerpt
   _table_with_attributes _table_with_attributes nopanel true

   .
2. A table now exists ready hold imported data in PhixFlow.
   1. To import the data hover over the table and click 

      Insert excerpt
      _run_analysis _run_analysis nopanel true

      .
   2. To remove any imported data see Removing Recordsets.