Updating Imported External Data Objects

Go Up to Session 8: Importing External Data Objects from ER/Studio Data Architect

You can use the Update External Data Objects wizard to update an existing External Data Object data source that you have already imported. All existing objects that match an object you have selected will be updated. All objects that you have selected but are not in the existing data source will be brought in as new. In the following example, we will walk through the update steps even though the ER/Studio model has not been changed.

1. In the Model View tree, right-click the External Data Objects data source node labeled “Southwind,” and then select Import > From ER/Studio > Update Existing External Data Objects....
2. In the Location text box, browse to …ERStudio Business Architect X.X.X\samples\ERStudio Data Architect Models\ and select the file named “Northwind.dm1” and click Open.
3. Leave the data source name “Southwind”.

   Note: You can select the “Delete objects in model that aren’t contained in source file.” If you enable this option, any objects in the target model that do not match an object that you select in the source model for update is deleted. If this option is not selected, (it is not selected by default), none of the objects in the target model are deleted. For purposes of this session, select this option.

4. Click Next. In the Model Selection dialog, select the logical model “Territories,” and then click Next.
5. In the Object Selection dialog, select the “Territories” folder from the Available Objects window, and then click . Your selection now appears in the Selected Entities list box. Notice that the folder labeled “Territories” does not appear in this list, only the four entities: Employee Territories, Region, Shippers, and Territories.

   

6. When you click Finish, a dialog opens telling you that the import was successful. Click OK and the new/updated objects appear in the “Southwind” node in the External Data Objects node.