| 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
| Note |
|---|
| title | Important 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 |
|---|
| nopanel | true |
|---|
|
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 |
|---|
| 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 |
|---|
|
|