Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from Metadata Excel Format

Bridge Specifications

Vendor Meta Integration Technology, Inc.
Tool Name Metadata Excel Format
Tool Version Excel 2003 to 2010
Tool Web Site http://metaintegration.com/Products/MIMB/
Supported Methodology [Metadata Management] Multi-Model, ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via Excel 2007 (XLSX) File

Import tool: Meta Integration Technology, Inc. Metadata Excel Format Excel 2003 to 2010 (http://metaintegration.com/Products/MIMB/)
Import interface: [Metadata Management] Multi-Model, ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via Excel 2007 (XLSX) File from Metadata Excel Format
Import bridge: 'MicrosoftExcel' 10.0.0

*** MicrosoftExcelImportDescription


Bridge Parameters

Parameter Name Description Type Values Default Scope
File This bridge reads an Excel spreadsheet in XLSX format and creates a model from its textual information. The "File" parameter should contain the name of this first spreadsheet, generally referred to as the "metadata import spreadsheet."

This metadata import spreadsheet MUST be formatted to match the blank spreadsheet.
Please find samples of these metadata import spreadsheets in ${MODEL_BRIDGE_HOME}\conf\MIRModelBridgeTemplate\MIRMicrosoftExcel\BlankFiles\. Using these files as guides, you may simply create a metadata import spreadsheet with your own model information that matches these examples.
FILE *.xlsx   Mandatory
Miscellaneous Specify miscellaneous options identified with a -letter and value.

For example, -m 4G

-v set environment variable(s) (e.g. -v var1=value -v var2="value with spaces").
-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Metadata Excel Format"
Metamodel
MicrosoftExcel
Mapping Comments
     
Attribute Attributes, SourceAttributes or TargetAttributes  
Comment Attribute Comment  
Description Attribute Description  
InitialValue Attribute Initial Value  
Name Attribute Name  
Optional Is Attribute Optional Is Attribute Required
PhysicalName Attribute Physical name  
Position Attribute Position  
Class Classes, SourceClasses or TargetClasses  
Comment Class Comment  
Description Class Description  
Name Class Name  
PhysicalName Class Physical name  
ClassifierMap   Computed based on feature maps
DataAttribute   Computed based on feature maps
DataSet   Computed based on Transformation
DatabaseSchema Schemas, SourceSchemas or TargetSchemas Created based on the "System Type"
Comment Schema Comment  
Description Schema Description  
Name Schema Name  
PhysicalName Schema Physical name  
DerivedType   Create using "Data Type Inherited From" or calculated using template data.
Comment Data Type Comment  
Description Data Type Description  
InitialValue Data Type Initial Value  
Length Data Type Length  
LowerBound Data Type Min Value  
Name Data Type Name  
PhysicalName Data Type Physical Name  
Scale Data Type Scale  
UpperBound Data Type Max Value  
UserDefined   Calculated based on the datatype usage
DesignPackage DataPackages, SourceDataPackages or TargetDataPackages  
Comment Package Comment  
Description Package Description  
Name Package Name  
PhysicalName Package Physical name  
FeatureMap FeatureMaps Computed based on source and target attribute references.
Description Feature Map Description  
Name Feature Map Name  
Operation Feature Map Operation  
FileDirectory Schemas, SourceSchemas or TargetSchemas Created based on the "System Type"
Comment Schema Comment  
Description Schema Description  
Name Schema Name  
PhysicalName Schema Physical name  
PropertyType   Defined in the template
DataType   Defined in the template
InitialValue   Defined in the template
Name   Defined in the template
Name   Defined in the template
Value   Defined in the template
StoreModel Models  
Author Model Creation Time  
Comment Model Comment  
CreationTime Model Creation Time  
Description Model Description  
ModificationTime Model Creation Time  
Modifier Model Creation Time  
Name Model Name  
PhysicalName Model Physical name  
SystemType System Type  
SystemTypeOld System Type  
TypeValue DataTypes, SourceDataTypes or TargetDataTypes  
Description Data Type Enumerated Value Description  
Name Data Type Enumerated Value  

Last updated on Tue, 21 Nov 2017 18:36:26

Copyright © Meta Integration Technology, Inc. 1997-2017 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.