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.

Solution

1. Table

1. Hover over the Database Collector and click  Create Table Using Attributes.
2. A table now exists ready hold imported data in PhixFlow.
   1. To import the data hover over the table and click  Run Analysis.
   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  Apply and Close your changes.

2. Database Collector

1. Hover over the datasource and click  Show Tables, 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  Apply and Close your changes.

3.