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  Show Tables. The list shows the tables that the users defined in the datasource instances have permission to view. 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  Download data to file button.

See also Datasource.

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  Download data to file 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 

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.