A Reference table holds information that is common to either all LU instances or to multiple LUs. For optimization reasons, this information is stored in an external table and not in each LUI MicroDB.
Go to Project Tree > References , right-click, then select Create References Based On DB Tables. This will display the DB Browser menu, Context menu and References popup window.
Click DB Connection (top of the window) and select a data source interface.
Click main to display the Tables directory in the source DB.
Select a table. To select multiple tables, press the Ctrl key.
Add a prefix to the Reference table's name in the Name Prefix field (window's footer).
To populate the Reference Table using a Broadway flow, tick the Table population based Broadway flow box.
Switch to DB Interface Explorer View by clicking on its icon ( ), located on the Activity Bar.
Choose the DB Interface and the required table
Right-click on the table. A popup window appears. Choose the Create Reference Table option as seen below
An automatically-generated new reference table has been created; as seen below, it is comprised of external data source table.
Note: Once the reference table is auto generated, a corresponding population flow is auto generated too.
A new reference table can be created also manually.
Go to Project Tree > Implementation > Logical Units / Data Products
Choose Logical Units / Data Products by clicking anywhere along the line
Choose/click on the References logical unit
Choose/highlight the Tables folder > right-click on it
Choose the New Table option from the opened context menu
Name the new Table. Press Enter to confirm or Escape to cancel.
Follow the instructions for creating a new table.
Save the file
Create a corresponding table population.
Reference tables can be edited by either changing the default data mapping, adding transformations or adding or removing columns like in LU tables.
When the Broadway flow population option is selected as described above, the table population process can be edited using the Broadway flow described here.
To access the Reference Viewer do the following:
Go to Project Tree > References, right-click References Viewer, and then select the table. The Data Viewer window is displayed according to its hierarchy in the Instances Tree pane.
Click the data file to display the components hierarchy in the Instance DB Tree pane.
To view Reference tables content:
Properties can be defined in the Table Properties panel in the right pane of the selected Table tab.
By default, reference tables are synched in the background of each table according to the defined Sync policy. The following Sync options can be selected in the Table Properties panel:
None, default value, synchronization is according to the Sync policy defined.
Time Interval, set in days.hrs:min:sec
format.
Decision function, syncs the table according to the Decision function defined under the References > Java folder.
The following functions or other tables can be attached to the Reference table:
Sync Wait Timeout: The timeout in seconds for syncing the. This is similar to schema sync wait timeout
Sync Method: By default, reference tables are synched in the background of each table according to the defined Sync policy. The following Sync options can be selected in the Table Properties panel:
None, default value, synchronization is according to the Sync policy defined.
Time Interval, set in days.hrs:min:sec
format.
Decision function, syncs the table according to the Decision function defined under the References > Java folder.
Truncate Before Sync: When Truncate Before Sync = True (checkbox is checked), the entire LU table is truncated before the populations are executed
Before accessing the Reference Table from a specific LU, or before it can be used as a lookup object, it must be attached to the LU.
Open the Schema Window
In the right panel, select the References tab.
Check the relevant Reference table(s) option.
Open the Schema Window
In the right panel, expand the Dependent References section
Add the required Reference tables to the Reference List: Use the plus (+) button to add another table and then select a table from the list
Note: Reference tables can also be accessed via Lookup tables, Web Services, functions, jobs and Broadway Actors.
Reference Tables must be deployed before being used. As a result of the deployment, a synchronization job process is triggered in the background to ensure that all CommonDB copies are kept in-sync across the Fabric Cluster.
To deploy the Reference Tables, go to the Project Tree, right click References, select Deploy to Server and then the Server to deploy to the Reference table.
Note that if a reference table has been attached to an LU Schema as described above, the LU must be re-deployed.
A Reference table holds information that is common to either all LU instances or to multiple LUs. For optimization reasons, this information is stored in an external table and not in each LUI MicroDB.
Go to Project Tree > References , right-click, then select Create References Based On DB Tables. This will display the DB Browser menu, Context menu and References popup window.
Click DB Connection (top of the window) and select a data source interface.
Click main to display the Tables directory in the source DB.
Select a table. To select multiple tables, press the Ctrl key.
Add a prefix to the Reference table's name in the Name Prefix field (window's footer).
To populate the Reference Table using a Broadway flow, tick the Table population based Broadway flow box.
Switch to DB Interface Explorer View by clicking on its icon ( ), located on the Activity Bar.
Choose the DB Interface and the required table
Right-click on the table. A popup window appears. Choose the Create Reference Table option as seen below
An automatically-generated new reference table has been created; as seen below, it is comprised of external data source table.
Note: Once the reference table is auto generated, a corresponding population flow is auto generated too.
A new reference table can be created also manually.
Go to Project Tree > Implementation > Logical Units / Data Products
Choose Logical Units / Data Products by clicking anywhere along the line
Choose/click on the References logical unit
Choose/highlight the Tables folder > right-click on it
Choose the New Table option from the opened context menu
Name the new Table. Press Enter to confirm or Escape to cancel.
Follow the instructions for creating a new table.
Save the file
Create a corresponding table population.
Reference tables can be edited by either changing the default data mapping, adding transformations or adding or removing columns like in LU tables.
When the Broadway flow population option is selected as described above, the table population process can be edited using the Broadway flow described here.
To access the Reference Viewer do the following:
Go to Project Tree > References, right-click References Viewer, and then select the table. The Data Viewer window is displayed according to its hierarchy in the Instances Tree pane.
Click the data file to display the components hierarchy in the Instance DB Tree pane.
To view Reference tables content:
Properties can be defined in the Table Properties panel in the right pane of the selected Table tab.
By default, reference tables are synched in the background of each table according to the defined Sync policy. The following Sync options can be selected in the Table Properties panel:
None, default value, synchronization is according to the Sync policy defined.
Time Interval, set in days.hrs:min:sec
format.
Decision function, syncs the table according to the Decision function defined under the References > Java folder.
The following functions or other tables can be attached to the Reference table:
Sync Wait Timeout: The timeout in seconds for syncing the. This is similar to schema sync wait timeout
Sync Method: By default, reference tables are synched in the background of each table according to the defined Sync policy. The following Sync options can be selected in the Table Properties panel:
None, default value, synchronization is according to the Sync policy defined.
Time Interval, set in days.hrs:min:sec
format.
Decision function, syncs the table according to the Decision function defined under the References > Java folder.
Truncate Before Sync: When Truncate Before Sync = True (checkbox is checked), the entire LU table is truncated before the populations are executed
Before accessing the Reference Table from a specific LU, or before it can be used as a lookup object, it must be attached to the LU.
Open the Schema Window
In the right panel, select the References tab.
Check the relevant Reference table(s) option.
Open the Schema Window
In the right panel, expand the Dependent References section
Add the required Reference tables to the Reference List: Use the plus (+) button to add another table and then select a table from the list
Note: Reference tables can also be accessed via Lookup tables, Web Services, functions, jobs and Broadway Actors.
Reference Tables must be deployed before being used. As a result of the deployment, a synchronization job process is triggered in the background to ensure that all CommonDB copies are kept in-sync across the Fabric Cluster.
To deploy the Reference Tables, go to the Project Tree, right click References, select Deploy to Server and then the Server to deploy to the Reference table.
Note that if a reference table has been attached to an LU Schema as described above, the LU must be re-deployed.