How to Load Meta-Data From USoft Developer to Microsoft Repository

Previous Next

See Also

To load meta-data from USoft Developer into Microsoft Repository:

1. From the USoft Definer menu bar, choose Tools, Data Model Loader, Microsoft Repository.
2. In the Data Model Loader window, check that:
· The External Connection pane in this window shows the MSR meta-data you last connected to.
· The USoft Connection pane shows the USoft Developer meta-data.

If not, you first need to set up Data Model Loader connections.

· If you wish to connect to another MSR data source, make sure the cursor is in the External Connection pane. Click Connect, and then provide the required information. You can also choose Load, Connect from the menu bar.

Before connecting to a Microsoft Access or SQL Server data source for the first time, you may need to initialize it as a Microsoft Repository source.

The External Connection pane now shows a representation of the external meta-data you connected to.

3. In the External Connection pane, click the folder node where you want the USoft export data to be inserted in the object hierarchy. The currently selected folder is marked by an overlay icon.

Before you do that, you may need to re-organize the External Connection object hierarchy by using the New, Rename or Delete options from the Load menu.

When navigating through the tree views, you can click Stop to interrupt lengthy tree view node expansion.

4. In the USoft Connection pane, select the meta-data elements you want to load into Microsoft Repository. You can select a single element by clicking on it, or use the Select All and Unselect All options to select or unselect all leaf nodes within the current folder.

Selected items are marked by overlay icons on leaf nodes, NOT at folder node level.

Only tables and relationships OWNED (as opposed to shared) by a business object can be transferred. They can only be selected by expanding the business object node that owns them. The overlay icons mark the elements that will actually be transferred.

5. Click Transfer, or choose Load, Transfer Selected Items from the menu bar.

The meta-data is now loaded to Microsoft Repository. If required, you can interrupt lengthy transfer procedures by clicking Stop.

To view newly loaded data in the External Connection pane, select the parent folder in this pane. Click Refresh, or choose Load, Refresh Folder from the menu bar.

Inspect transfer log and error information by choosing Load, Transfer Log and Error Log options from the menu bar. Deal with errors as required.