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 

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