Importing a Model from External Metadata

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

Go Up to Importing a Model

Notepad blue icon 2.pngNote: This feature is not supported by the Developer Edition of ER/Studio Data Architect.

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.
    ImportETL1.png
  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.
    ImportETL2.png
  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.

Notepad blue icon 2.pngNote:

  • The options are self-explanatory and additional details appear in the area beneath the options list.
  • You can find additional information on the Meta Integration Model Bridges at http://www.metaintegration.net/Partners/IDERA.html.
  • The Import File From External Metadata command generates a data model based on metadata in standard XML and common proprietary formats. For a current list of supported platforms, valid BridgeIDs, and corresponding bridge names, see:
    • C:\ProgramData\IDERA\ERStudio Data Architect 16.0\MetaIntegration\MIRModelBridges.xml
    • The PDF version of this file is available online.

See Also