 |
|
|||||||
 |
   
|
|
||||||
|
|
|||||||
|
|
|
||||||
| Vendor | Sypherlink |
| Tool Name | Harvester |
| Tool Version | 4.x |
| Tool Web Site | http://www.sypherlink.com/products/hrm.asp |
| Supported Methodology | [Metadata Management] ETL (Source and Target Data Stores) via XML File |
Import tool: Sypherlink Harvester 4.x (http://www.sypherlink.com/products/hrm.asp)
Import interface: [Metadata Management] ETL (Source and Target Data Stores) via XML File from Import bridge: 'SypherlinkHarvester' 6.0.2 - Aug 20 2008 19:37:41
| Parameter Name | Description | Type | Values | Default | Mandatory |
| File | An XML file exported by Harvester Relationship Manager. | FILE | Yes | ||
| Generate Views | Data transformations can be converted to SQL Views. Afterwards the transformations are deleted as are any target tables that do not also function as sources. | BOOLEAN | False |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Sypherlink Harvester" Metamodel |
Mapping Comments |
| Attribute | Column | |
| Name | Name | |
| Position | Calculated by position of the Column element in the parent Table element. | |
| BaseType | Type | Calculated from the TypeMap in the Database element. |
| Class | Table | |
| Name | Name | |
| ClassifierMap | Used to connect and store lineage from source to destination tables. | |
| DataAttribute | Built to represent transformations. | |
| DataSet | Built to represent transformations. | |
| DatabaseCatalog | Database | |
| Name | Name | |
| SystemType | Kind | |
| DatabaseSchema | Schema | |
| Name | Calculated from Schema ID. | |
| DerivedType | Type | |
| DataType | Name | |
| Length | Length | Taken from Column element. |
| Name | Name | Derived from the datatype ODBCType |
| Scale | Scale | Taken from Column element. |
| DesignPackage | Calculated from Datbase/Schema for tables and Condition Group for transformation tasks | |
| UserDefined | Set to FALSE | |
| FeatureMap | Used to connect and store lineage from source to destination tables. | |
| Model | ResultSet | |
| Description | Description | |
| Name | Calculated from the source file name | |
| Transformation | Generates Reader, Writer, Expression and Join tranformation types. | |
| TransformationTask | Creates one Transformation Task per condition Group name. |
Last updated on Mon, 25 Aug 2008 19:36:22
