This page is for data modellers who want to configure a database table.

Overview

From a PhixFlow

datasource, you can

open a window listing the tables in that database.

For example, in the datasource properties tab, in the toolbar click on 

For each table, you can

display:

• the data in the table
• a list of the attributes defined in that table

Depending on where you

open the table list from, it will be either a simple list with only the name of each table, or a detailed list.

The database tables list has a toolbar with common buttons. You can export data from a detailed list using the 

Detailed Table List

In the detailed table list, the following fields are shown for each table:

You can do the following things

:

• To show data in table

• , double-click on the table.

• To display a simple list of the table attributes, right-click to display the context menu and select Show Table Attributes

• .
• To display a detailed list of

• attributes, right-click and select Show Attribute Details; see Table Attribute Details

• below.
• To export data from a table, use the 

  Insert excerpt
  _excel_export _excel_export nopanel true

   button; see Download CSV or Excel Data.
• To create a collector for the

• table: 
  • either drag the table onto a model view

• • or right-click and select Create a Collector

• • .

Table Attribute Details 

Anchor
list list

Anchor
databaseTableAttributesDetailedList databaseTableAttributesDetailedList

Depending on how you display them, database table attributes

may be

• either in a simple list, with only the name of each attribute
• or in  detailed list.

In the detailed list, the following fields are shown for each attribute:

You can select several attributes and drag them onto a model window. PhixFlow creates a database collector to read the selected fields from that table.