Introduction

Exporting data from a database requires three modelling objects:

1. Table: The location(s) in PhixFlow which holds the data required for export.
2. Data Exporter: sends data to the datasource using a SQL command.
3. Datasource: Provides the connection to the database.

Image Added

Solution

1. 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.

2. 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.
   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.
   2. Save 

      Insert excerpt
      _finish _finish nopanel true

       your changes.

3.