1. Enterprise Modeling User Guide
  2. Managing Sandbox
  3. Workflow
  4. User Roles
  5. Managing Sandbox
  6. Searching Sandbox Definition
  7. Incremental Data Model Upload

Incremental Data Model Upload

The Increment Upload Required column in the Sandbox Maintenance window displays the status as "Y" or "N" depending on the need for Incremental Data Model Upload for the Sandbox definition. The Incremental Data Model Upload button is enabled only when the model versions between Production and Sandbox information Domain are different.
Incremental Data Model Upload facilitates you to synchronize the difference of a Data Model which exists in the Production and Sandbox Information Domain. You can refresh the details and fetch the incremental data model changes from Production to Sandbox Information Domain.
Note the following points:
  • The Incremental Data Model Upload button will not be enabled for the sandboxes in which the No option is selected for the Is data model upload required? field, even though there is a difference between the model versions in the Production and Sandbox information domains.
  • Incremental data model upload is supported only when the difference in sandbox and production is at table level, that is, the sandbox schema has at least one table less or more when compared to the production schema.
  • Incremental data model upload is not supported for Hive-based sandboxes.
To perform an incremental data model upload, follow these steps:
  1. Select the checkbox adjacent to the Sandbox ID which has the Increment Upload Required status as "Y". The status will be Y only when there is a difference in the model versions between Production and Sandbox information Domain.
  2. Click Reset icon from the Sandbox Maintenance toolbar. The Incremental Data Model Upload window is displayed with the selected Sandbox definition details in View mode.

    Figure 6-5 Incremental Data Model Upload


    This image displays the Incremental Data Model Upload.

  3. Click Refresh. The incremental data model changes are fetched and updated.
  4. An information dialog is displayed confirming successful incremental data model upload. Click OK.
    Once the Incremental changes are updated to the Data Model in the Sandbox Information Domain, you need to re-save the details in the Sandbox Definition window. For more information, see the Modifying Sandbox Definition section.