Importing a Model from External Metadata

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Importing a Model

MetaWizard, a separate product available from IDERA, extends ER/Studio Data Architect's functionality by providing an import bridge that allows you to import metadata from applications such as Microsoft Excel, CA AllFusion Erwin, IBM Rational Data Architect, Oracle Designer, and Sybase PowerDesigner, and also allows you to import metadata from XML structures.

  1. Click File > New.
  2. Select Import Model from and then from the list, click External Metadata.
    Magic Wand Icon.pngTip: Alternatively, with a model already opened, you can select File > Import File > From External Metadata. In this case, the new model will be imported into the open diagram.
  3. Click Import.
  4. From the Import from list in the Import External Metadata wizard, select the XML type of the file to be imported or the application that created the file.
    Error creating thumbnail: File missing
  5. In the Available Options area, click the Value field in the File row, click the ellipses (... ) and then select the file to be imported.
  6. Optionally, set the other available options, which vary depending on the type of the selected file in the Import From list.
  7. Click Next.
    Error creating thumbnail: File missing
  8. In the Name column, click on each of the parameters to see descriptions and help for the parameter. Click on the corresponding cell in the Value column to change its value.
  9. To start the import, click Next.
    The import log displays.
  10. If the import was successful, click Finish to create the model.
  11. Save the new model.

{{Note|The options are self-explanatory and additional details appear in the area beneath the options list.

See Also