CA COOL:Enterprise (ADW) 2.7 - Import
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | CA technologies |
| Tool Name | COOL:Enterprise |
| Tool Version | 2.7 |
| Tool Web Site | http://www.ca.com/acq/sterling/ |
| Supported Methodology | [Data Modeling] Data Store (Logical Data Model) via EXP Export File |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: CA technologies / COOL:Enterprise version 2.7 via EXP Export File
See http://www.ca.com/acq/sterling/
Metadata: [Data Modeling] Data Store (Logical Data Model)
Component: CaAdw version 11.2.0
OVERVIEW
n/a
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
Q: The bridge asks for a single path, however since the model is located in 4 different files, what should I provide as a pathname?
A: In the 'From' text box you can either enter the path of the directory containing the .exp files or the path of one of the .exp files.
Q: How do I create the .exp files?
A: Creating the .exp export files:
- From COOL:Enterprise (ADW): refer to the documentation.
- From COOL:Biz:
- Open your model (BML files) in the COOL:Biz 'Model Manager',
- Select the 'SystemPackages' folder,
- Click on 'Export to COOL:Enterprise' in the 'Data Transfer' main menu,
- You should now be able to set the names of the EXP export files.
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | |||||||||||||||||||||||||
| Directory | Refer to the COOL:Enterprise (ADW) documentation for creating the files to be imported. The bridge will use the generated .exp files as input. Note that the bridge expects the files to be named OI.exp, AI.exp, PI.exp and TI.exp (or xxxxxxOI.exp ...). | DIRECTORY | Mandatory | |||||||||||||||||||||||||||
| User defined types | Import the Types as user-defined types (also called Domains). | BOOLEAN | False | |||||||||||||||||||||||||||
| Check datatype of attributes in key | Do not put attributes whose datatype is undefined in a Primary key. | BOOLEAN | True | |||||||||||||||||||||||||||
| Encoding | The character set encoding of the model to be imported. If there are multiple choices for a language, the actual encoding will be indicated between parentheses. |
ENUMERATED |
|
windows-1252 |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"CA COOL:Enterprise (ADW) 2.7" Metamodel CaAdw |
Mapping Comments |
| Association | From-To Relationship | |
| Aggregation | True when the association is part of an identifier | |
| Description | Description + Comments | |
| AssociationRole | Roles | |
| Multiplicity | From-to Maximum + From-to Miminum | |
| Name | To-from Name / From-to Name | |
| Source | Based on the multiplicity of each role | |
| Attribute | Attribute Type | |
| Description | Description + Comments | |
| Name | Name | |
| Optional | False is attribute is part of a primary key, True otherwise | |
| Position | Position in ETD | |
| BaseType | Information Type | All derived types will be linked to an "undefined" BaseType. |
| DataType | See datatype conversion array | |
| Name | Based on the datatype | |
| PhysicalName | Derived from the datatype | |
| CandidateKey | Attribute (identifier property) | Attribute Type that describes the Entity Type and parts of an association |
| UniqueKey | True | |
| Class | Entity Type | |
| CppClassType | Set to ENTITY | |
| CppPersistent | Set to True | |
| Description | Description + Comments | |
| Name | Name | |
| ClassDiagram | Subject Area | |
| Description | Description + Comments | |
| Name | Name | |
| DerivedType | Information Type, Value Set | |
| DataType | Data Type | See datatype conversion array |
| Description | Description + Comments | |
| Length | Precision, Maximum length | |
| LowerBound | Minimum Range | |
| Name | Name | |
| PhysicalName | Derived from the datatype | |
| Scale | Fractional Precision | |
| UpperBound | Maximum Range | |
| UserDefined | Based on bridge option | |
| Description | Description + Comments | |
| Name | Name | |
| ForeignKey | Based on Primary Key and association role | |
| Index | Associated with each key | |
| IndexMember | Associated with each attribute in a key | |
| Position | Computed | |
| StoreModel | Hierarchy of subject areas | The model is built using the elements contained in the ADW file |
| Name | Derived from the ADW file name | |
| TypeValue | Value | |
| Name | Name | |
| Value | Sequence Number |