Refresh Data

The refresh source table functionality enables you to compare the schema of a table in Studio to the schema in your ERP or flat file. This may be necessary if your source schema has been changed or modified.

Click Refresh. The Compare and Refresh Source Table window is displayed.

Tables may be refreshed in either of the following ways:

• ERP: Select this option to connect to the ERP and refresh the schema in your project.
• File: Select this option to browse for a CSV or XML file and update your project schema through this file.

After selecting one of the options, click the Refresh button. The window lists the table selected and the columns and attributes that changed in the source. The Status column indicates what the status of the Studio table or column will be if you click Update Source Table. The Status column displays one of 3 statuses-Add, Update, or Delete.

For example, if a column from the selected table has been deleted in the source, the Status column will display Delete. If you now click Update Source Table, that column will be deleted from the table in Studio.