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 in external databases to be used in PhixFlow.

They are created in an ERD and backed by a

Insert excerpt

	_datasource
	_datasource
nopanel	true

.

Changes can be made to remote database tables in PhixFlow, such as updating or inserting, and saved in an Actionflow using a

Insert excerpt

	_action_save
	_action_save
nopanel	true

action. These changes will be saved back to the external database.

Use

Insert excerpt

	_remote_database_table
	_remote_database_table
nopanel	true

s in:

Insert excerpt
_actionflow
_actionflow
nopanel true
s for direct reading and writing to external tables
Insert excerpt
_screen
_screen
nopanel true
s to provide real time views of data in external databases

s
Remote Database Tables
cannot be created unless both remote tables have the same backing datasource

Relations cannot be created between Remote Database Tables and

Note

title	Important Considerations

On ERDs, relations between two

Insert excerpt

_remote_database_table

nopanel

true

_remote_database_table

Insert excerpt

	_remote_database_table
nopanel	true

s and

_tables
	_tables
nopanel	true

s Insert excerpt_remote_database_table_remote_database_tablenopaneltrues

Remote Database Tables cannot be used in Analysis Models

Changes made to Insert excerpt_remote_database_table_remote_database_tablenopaneltrue in Remote Database Tables in PhixFlow do not have an audit trail and their recordsets cannot be rolled back

For how to create a

Insert excerpt

	_remote_database_table
	_remote_database_table
nopanel	true

, see Adding Data and Tables to an ERD.

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 Remote Database Table.
Enabled	Enable to allow the table to be used.
Table	The name of the table on the database.
Datasource	The name of the datasource connected to the remote database.
Description	Enter a description to explain the purpose of this item.

Attributes

After mappings in the column names from the remote table, they will appear here as attributes.

The attribute's column name (as it appears on the database) can be seen by double-clicking the attribute to see the Column Name field.

To display the Mappings window, hover over the

Insert excerpt

	_more_options
	_more_options
nopanel	true

menu and choose

Insert excerpt

	_map_attributes
	_map_attributes
nopanel	true

.

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

Insert excerpt

	_audit
	_audit
nopanel	true

Version	Old Version 3	New Version 4
Changes made by	Zoe Baldwin	Zoe Baldwin
Saved on	Mar 07, 2025	Mar 07, 2025

Versions Compared

Key

Overview

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Basic Settings

Attributes

See All Sections

Errors

Content Comparison

Versions Compared

Key

Overview

Insert excerpt_property_tabs_property_tabsnamebasic-hnopaneltrue

Basic Settings

Attributes

See All Sections

Errors

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true