Versions Compared

Version Old Version 2 New Version 3
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.

They are created in an ERDs ERD and backed by a

Insert excerpt
_datasource
_datasource
nopaneltrue
. Any

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 Flows for direct reading and writing to external tables

  • Screens to provide real time views of data in external databases

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

Use

Insert excerpt
_

property

remote_database_

tabs

table
_

property_tabsnamebasic-h

remote_database_table
nopaneltrue
s in:

  • Insert excerpt
    _

parent

  • actionflow
    _

parent

Attributes

The attributes on this table have a Column Name field.

See All Sections

ExpandtitleClick here to see details of all sections...

  • actionflow
    nopaneltrue

Basic Settings

FieldDescriptionNameThe name of the File Table.Enabled

Enable to allow the table to be used.

Table

The table associated with the datasource

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 amended.DescriptionEnter a description to explain the purpose of this item. 

  • s for direct reading and writing to external tables 

  • Insert excerpt

TablenameViews

  • _screen

Table

TablenameSortOrdersnopaneltrue

Errors 

  • _screen
    nopaneltrue

Insert excerptTable

  • s to provide real time views of data in external databases

error
Note
titleImportant Considerations
  • On ERDs, relations between two
    Insert excerpt
    _
validate		_validatename
remote_database_table
_remote_database_table
nopaneltrue
Insert excerptTableTablenameERDsnopaneltrueTablenameRelations
  • s
    cannot be created unless both remote tables have the same backing datasource
  • Relations cannot be created between
    Insert excerpt
Table
  • _remote_database_table
    _remote_database_table
    nopaneltrue
    s and 
    Insert excerpt
Table
  • _tables
TablenameFilters
  • _tables
    nopaneltrue
    s
  • Insert excerpt
TableTablenameDataRetentionSettings
  • _remote_database_table
    _remote_database_table
    nopaneltrue
Insert excerptTableTablenameAdvancednopaneltrue
  • s cannot be used in Analysis Models
  • Changes made to
    Insert excerpt
    _remote_database_
access
  • table
    _
accessnopaneltrue Insert excerpt_audit_audit
  • remote_database_table
    nopaneltrue

Setting Up Remote Database Tables

On an ERD, drag
  • 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

from the toolbar
  • Name: Provide a name 
    • Datasource: Choose a datasource from the drop down list or clikc the 

    , see Adding Data and Tables to an ERD.

    Insert excerpt
    _property_

    datasource

    tabs
    _

    datasource

    property_tabs
    name

    icon

    basic-h
    nopaneltrue

    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,

    Insert excerpt
    _parent
    _parent
    nopaneltrue

    Basic Settings 

    FieldDescription
    NameThe name of the Remote Database Table.
    Enabled

    Enable to allow the table to be used.

    Table

    The name of the table on the database.

    DatasourceThe name of the datasource connected to the remote database.
    DescriptionEnter 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
    nopaneltrue
    menu

    in the Attributes section

    and choose

    Insert excerpt
    _map_attributes
    _map_attributes
    nopaneltrue

    to display the Mappings window
    Image Removednote

    .

    See All Sections

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

    Insert excerpt

    		_remote_database_table

    Table
    Table
    nameViews
    nopaneltrue

    s do not support analysis runs. 
  • They cannot have Audit Manual Changes enabled. Recordsets cannot be rolled back.
    • When saving to a

    Insert excerpt
    Table
    Table
    nameSortOrders
    nopaneltrue

    Errors 

    Insert excerpt
    _

    remote_database_table_remote_database_table

    validate
    _validate
    nameerror
    nopaneltrue

    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

    Table
    Table
    nameERDs
    nopaneltrue

    cannot be created unless both remote tables have the same backing sourceRelations cannot be created between

    Insert excerpt
    Table
    Table
    nameRelations
    nopaneltrue

    Insert excerpt

    _remote_database_table_remote_database_table

    Table
    Table
    nameFilters
    nopaneltrue

    s and 

    _tables

    Insert excerpt

    _tables

    Table
    Table
    nameDataRetentionSettings
    nopaneltrue

    sAny changes made to the

    Insert excerpt
    Table
    Table
    nameAdvanced
    nopaneltrue

    Insert excerpt
    _

    remote_database_table

    access
    _

    remote_database_table

    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.

    access
    nopaneltrue

    in PhixFlow will update both PhixFlow and the database. 

    Insert excerpt
    _audit
    _audit
    nopaneltrue