Versions Compared

Version Old Version 2 New Version Current
Changes made by

Zoe Baldwin

Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameerd
nopaneltrue

Insert excerpt
_remote_database_table
_remote_database_table
nopaneltrue
s feature in PhixFlow v12.1+.

Overview

Insert excerpt
_remote_database_table
_remote_database_table
nopaneltrue
s allow tables in external databases to be used in PhixFlow and data written back to the database.

They are created in an ERDs ERD and backed by a

Insert excerpt
_datasource
_datasource
nopaneltrue
. Any

Action Flows

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
nopaneltrue
 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. These changes will be saved back to the external database.

Use

Insert excerpt
_remote_database_table
_remote_database_table
nopaneltrue
s in:

  • Insert excerpt
    _actionflow
    _actionflow
    nopaneltrue
    s for direct reading and writing to external

tablesScreens

  • tables 

  • Insert excerpt
    _screen
    _screen
    nopaneltrue
    s to provide real time views of data in external databases


Excerpt
nameConsiderations


Note
titleImportant Considerations
  • On ERDs, relations between two Remote Database Tables cannot be created unless both remote tables have the same backing datasource
  • Relations cannot be created between Remote Database Tables and 
    Insert excerpt
    _tables
    _tables
    nopaneltrue
    s
  • Remote Database Tables cannot be used in Analysis Models
  • Changes made to 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
nopaneltrue
, see Adding Data and Tables to an ERD.

Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic SettingsSettings 

FieldDescription
NameThe name of the File Remote Database Table.
Enabled

Enable to allow the table to be used.

Table

The name of the table associated with on the datasourcedatabase.

Datasourceemote 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 OnlyTick to signify that the file table's attributes cannot be amendedThe name of the datasource connected to the remote database.
DescriptionEnter a description to explain the purpose of this item. 

Attributes

The attributes on this table have a Column Name fieldAfter 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
nopaneltrue
menu and choose
Insert excerpt
_map_attributes
_map_attributes
nopaneltrue
.

See All Sections

Expand
titleClick here to see details of all sections...

Insert excerpt
Table
Table
nameViews
nopaneltrue

Insert excerpt
Table
Table
nameSortOrders
nopaneltrue

Errors 

Insert excerpt
_validate
_validate
nameerror
nopaneltrue

Insert excerpt
Table
Table
nameERDs
nopaneltrue

Insert excerpt
Table
Table
nameRelations
nopaneltrue

Insert excerpt
Table
Table
nameFilters
nopaneltrue

Insert excerpt
Table
Table
nameDataRetentionSettings
nopaneltrue

Insert excerpt
Table
Table
nameAdvanced
nopaneltrue

Insert excerpt
_access
_access
nopaneltrue

Insert excerpt
_audit_audit
nopaneltrue

Setting Up Remote Database Tables

On an ERD, drag a Insert excerpt_remote_database_table_remote_database_tablenopaneltrue from the toolbar
  • Name: Provide a name 
    • Datasource: Choose a datasource from the drop down list or clikc the  Insert excerpt_datasource_datasourcenameiconnopaneltrue icon to open the lost of datasources in the Repository, or create a new one
  • Set Up:
    1. Automatic: find the tables in the datasource automatically
    2. Manual: type in the table name
  • 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)
  • Click Confirm
    Image Removed
  • 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_tablenopaneltrue
    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_tablenopaneltrue properties, hover over the Insert excerpt_more_options_more_optionsnopaneltrue menu in the Attributes section and choose Insert excerpt_map_attributes_map_attributesnopaneltrue to display the Mappings window

    Note
    Insert excerpt

    Image Removed

    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.s do not support analysis runs. 
  • They cannot have Audit Manual Changes enabled. Recordsets cannot be rolled back.
    • When saving to a using a save action in an actionflow, an

    _

    remote_database_table    		_remote_database_table
    nopaneltrue
    Insert excerpt
    _remote_database_table_remote_database_table
    nopaneltrue
    audit

    trail will no exist for the changes.Relations between Insert excerpt_remote_database_table_remote_database_table

    nopaneltrue

    cannot be created unless both remote tables have the same backing sourceRelations cannot be created between Insert excerpt_remote_database_table_remote_database_tablenopaneltrues and  Insert excerpt_tables_tablesnopaneltruesAny changes made to the Insert excerpt_remote_database_table_remote_database_tablenopaneltrue in PhixFlow will update both PhixFlow and the database.