Insert excerpt

	_Banners
	_Banners
name	erd
nopanel	true

Insert excerpt

	_remote_database_table
	_remote_database_table
nopanel	true

s feature in PhixFlow v12.1+.

Overview

Insert excerpt

	_remote_database_table
	_remote_database_table
nopanel	true

s allow tables from in external databases to be used in PhixFlow.

They are created in an ERDs and backed by a

Insert excerpt

	_datasource
	_datasource
nopanel	true

. Any

Insert excerpt

	_action_save
	_action_save
nopanel	true

and then any save actions / grids that view them will update / read from / insert into the database that the backing datasource is connected to. The table on the backing datasource this Table represents can be selected from a drop down list when created or entered manually. Remote table attributes can be mapped to column names with a new mapping interface.

Use these trables in:

Action Flows for direct reading and writing to external tables
Screens to provide real time views of data in external databases

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Insert excerpt

	_parent
	_parent
nopanel	true

Basic Settings

Field	Description
Name	The name of the File Table.
Enabled	Enable to allow a file to be uploaded and associated information captured, when a file(s) is dragged and dropped onto a File Display or File Gallery component. the table to be used.
Table	The table associated with the datasource
Datasource	emote Database Tables can be backed by a Datasource and then any save actions / grids that view them will update / read from / insert into the database that the backing datasource is connected to.
Read Only	Tick to signify that the file table's attributes cannot be amended.
Description	Enter a description to explain the purpose of this item.

Attributes

Insert excerpt_tableFile_tableFilenopaneltrues have a set of predefined attributes that cannot be changed, deleted or added to. These attributes are: The attributes on this table have a Column Name field.

See All Sections

Expand

title	Click here to see details of all sections...

Insert excerpt

	Table
	Table
name	Views
nopanel	true

Insert excerpt

	Table
	Table
name	SortOrders
nopanel	true

Errors

Insert excerpt

	_validate
	_validate
name	error
nopanel	true

Insert excerpt

	Table
	Table
name	ERDs
nopanel	true

Insert excerpt

	Table
	Table
name	Relations
nopanel	true

Insert excerpt

	Table
	Table
name	Filters
nopanel	true

Insert excerpt

	Table
	Table
name	DataRetentionSettings
nopanel	true

Insert excerpt

	Table
	Table
name	Advanced
nopanel	true

Insert excerpt

	_access
	_access
nopanel	true

true

Insert excerpt

_model_prop

nopanel

true

Insert excerpt

Table

name

Advanced

nopanel

true

Insert excerpt

_access

nopanel

true

Insert excerpt

_audit

nopanel

	_audit
	_audit
nopanel	true

Setting Up Remote Database Tables

On an ERD, drag a
Insert excerpt
_remote_database_table
_remote_database_table
nopanel true
from the toolbar
1. Name: Provide a name
2. Datasource: Choose a datasource from the drop down list or clikc the
  Insert excerpt
  _datasource
  _datasource
  name icon
  nopanel true
  icon to open the lost of datasources in the Repository, or create a new one
3. Set Up:
  1. Automatic: find the tables in the datasource automatically
  2. Manual: type in the table name
4. Table:
  1. If Automatic is chosen for Set Up, this is a drop down list of tables available in the selected datasource
  2. If Manual is chosen for Set Up, this is a input field where the table name can be entered (case insensitive)
5. Click Confirm
  Image Added
PhixFlow will search for the table in the chosen datasource, and if found will display a Mappings window
On the Mappings window, map across the attributes from the datasource you wish to display in the
Insert excerpt
_remote_database_table
_remote_database_table
nopanel true
1. The attributes shown in the left of the mappings window match the column names on the remote database table
To reopen the Mappings window, in the
Insert excerpt
_remote_database_table
_remote_database_table
nopanel true
properties, hover over the
Insert excerpt
_more_options
_more_options
nopanel true
menu in the Attributes section and choose
Insert excerpt
_map_attributes
_map_attributes
nopanel true
to display the Mappings window
Image Added

Note

Insert excerpt
_remote_database_table
_remote_database_table
nopanel true
s do not support analysis runs.
They cannot have Audit Manual Changes enabled. Recordsets cannot be rolled back.
When saving to a
Insert excerpt
_remote_database_table
_remote_database_table
nopanel true
using a save action in an actionflow, an audit trail will no exist for the changes.
Relations between
Insert excerpt
_remote_database_table
_remote_database_table
nopanel true

cannot be created unless both remote tables have the same backing source
Relations cannot be created between
Insert excerpt
_remote_database_table
_remote_database_table
nopanel true
s and
Insert excerpt
_tables
_tables
nopanel true
s

Any changes made to the

Insert excerpt

	_remote_database_table
	_remote_database_table
nopanel	true

in PhixFlow will update both PhixFlow and the database.

Remote tables will be available for selection in Actionflow nodes such as Save, Bulk Update.

Remote tables will be available as the backing table on Grids, card containers and forms.

User case: Write data to a database in an actionflow.

Version	Old Version 1	New Version 2
Changes made by	Zoe Baldwin	Zoe Baldwin
Saved on	Feb 28, 2025	Mar 06, 2025

Versions Compared

Key

Overview

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Basic Settings

Attributes

See All Sections

Errors

Setting Up Remote Database Tables

Content Comparison

Versions Compared

Key

Overview

Insert excerpt_property_tabs_property_tabsnamebasic-hnopaneltrue

Basic Settings

Attributes

See All Sections

Errors

Setting Up Remote Database Tables

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true