For this example we assume that the external database table Employees is a View in our Thereforeā¢ database.
How do I create a new reference table?
1.The table needs to be in the Thereforeā¢ database. Typically this is done by creating a view on the external database. Or, for Thereforeā¢ systems where the Thereforeā¢ server cannot access the external database (e.g. Thereforeā¢ Online), this can be done using Table Replication. Data can also be retrieved from a web service and saved into a referenced table via calling a web service with REST.
Tutorial: Calling a Web Service via REST.
2.Right-click on 'Referenced Tables' and select 'New Referenced Table...'
3.Enter Employees for the Referenced Table Name. Select the Employees database table from the Table Name (or View) drop-down list. Select EmployeeNo as the Unique Identifier. Note: any column from the view can be selected, but it must be unique.
|