Click Finish and the Excel file is generated. In this case, we specify Physical and Logical. The export object design allows Logical Only, Physical Only, or Physical and Logical export. The included Blank file that matches our selected Mapping file is the following:Ĭ:\Program Files\CA\AllFusion ERwin Data Modeler r7\MetaIntegration\conf\MIRModelBridgeTemplate\MIRMicrosoftExcelExport\DataModel-Blank.xls For this example, we will use one of our included files, DataModel-MetaMap.xls:Ĭ:\Program Files\CA\AllFusion ERwin Data Modeler r7\MetaIntegration\conf\MIRModelBridgeTemplate\MIRMicrosoftExcelExport\ DataModel-MetaMap.xlsīlank file: This option should reference a blank file that is formatted to export the data as you would like. Mapping files can be customized when users become more comfortable with their usage. Metadata Mapping file: This points to any Mapping file. Location: This can point at any empty file or type a new file and a new file will be generated. Type: From this pull-down menu, you will see all file types that are supported by AllFusion ERwin DM. In the Destination tab, specify the following properties:. 
In the Export Editor, leave the Source tab unchanged.
That launches the MetaIntegration interface (Figure 1). After the model opens, select the menu File | Export | To External Format. That path may vary if you customized your installation. We will be using the included sample model, emovies.erwin, which is installed, by default, in the following location:Ĭ:\Program Files\CA\AllFusion ERwin Data Modeler r7\Samples\Standard\eMovies.erwin. Higher versions will work in the same manner. The version number from the Help | About menu should be 7. 
The first thing you want to do is to confirm that you are using the 7.1 Service Pack 1 (SP1) version of AllFusion ERwin Data Modeler or higher. The 1207 build of AllFusion ERwin Data Modeler is the first build that contains the Export and Import option for Microsoft Excel. This has been done by integrating the MetaIntegration Bridge within the tool. r7.1 AllFusion ERwin Data Modeler, we have added the ability to import and export data from other file sources. Specifically, we discuss the ability of the tool to import and export data using a Microsoft Excel Spreadsheet. Within this document we introduce the newly added Metaintegration Bridge technology. Ca erwin data modeler display relationship name how to#
Title: How to use the Metadata Integration Wizard to Import and Export Data Using Excel
0 kommentar(er)
