CA COOL:BusinessTeam (GroundWorks) 2.2.1 - Import
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | CA technologies |
| Tool Name | COOL:BusinessTeam |
| Tool Version | 2.2.1 and 1.2A.5.0 |
| Tool Web Site | http://www.ca.com/acq/sterling/ |
| Supported Methodology | [Data Modeling] Data Store (Logical Data Model) via VAR Export File |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: CA technologies / COOL:BusinessTeam version 2.2.1 and 1.2A.5.0 via VAR Export File
See http://www.ca.com/acq/sterling/
Metadata: [Data Modeling] Data Store (Logical Data Model)
Component: CaGroundWorks version 11.2.0
OVERVIEW
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
n/a
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 | |||||||||||||||||||||||||
| File | When a model is currently loaded in Sterling Software COOL:BusinessTeam (Cayenne GroundWorks) 1. Choose 'Export' from the 'File' menu. 2. Type the file name for the model you are saving in the 'File Name' text box (browse to select a specific directory). 3. Click 'Save'. The bridge will use the generated VAR file as input. |
FILE | *.var | Mandatory | ||||||||||||||||||||||||||
| Duplicate Attributes on Generalizations | Determine whether Attributes should be duplicated through Generalizations. 'True' Yes, all attributes are copied from the parent Class to the subtype Class. 'False' No. Only the Primary key Attributes are migrated. |
BOOLEAN | False | |||||||||||||||||||||||||||
| Design Level | Define the Design level to apply to the imported objects. 'Logical and Physical' All objects are imported as both Logical and Physical 'Logical' All objects are imported as Logical only. 'Physical' All objects are imported as Physical only. To be able to later export the model in most design tools, the default, 'Logical and Physical' should be kept. But in some cases, it might be useful to mark the object as Logical only. |
ENUMERATED |
|
Logical and Physical | ||||||||||||||||||||||||||
| 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:BusinessTeam (GroundWorks) 2.2.1" Metamodel CaGroundWorks |
Mapping Comments |
| Association | Partnership | |
| Aggregation | Based on attributes belonging both to a primary key and a foreign key associated with the association | |
| AssociationRole | Partnership Set | |
| Description | Description | |
| Multiplicity | Minimun/Maximun Volumes | |
| Name | Name | |
| Source | Based on the multiplicity | |
| AssociationRoleNameMap | When migrated attributes have a different name | |
| Attribute | Attribute | |
| Description | Description | |
| Name | Name | |
| Optional | Nulls Allowed | |
| Position | Order | |
| BaseType | Domain | Created as side effect of Derived Type creation |
| DataType | Datatype | See datatype conversion array |
| Name | Datatype | Standard name based on the type |
| PhysicalName | Datatype | Standard name based on the type |
| CandidateKey | Key | |
| Description | Description | |
| Name | Name | |
| UniqueKey | Only for primary key | |
| Class | Entity | |
| CppClassType | Set to ENTITY | |
| CppPersistent | Set to True | |
| Description | Description | |
| Name | Name | |
| ClassDiagram | Filter, Keyword | Diagrams based on Filters and Keywords are imported |
| Name | Filter name | |
| DerivedType | Domain | |
| DataType | Datatype | See datatype conversion array |
| Description | Description | |
| Length | Length/Precision | |
| LowerBound | Numeric Range (Maximum) | |
| Name | Name | |
| Scale | Scale | |
| UpperBound | Numeric Range (Minimum) | |
| UserDefined | Always True | |
| DesignPackage | No equivalent in GroundWorks. A main package "Logical View" is created to contain all entities/partnerships | |
| ForeignKey | Foreign Key | |
| Name | Name | |
| Generalization | Entity (supertype) | |
| GeneralizationRole | Entity (supertype) | |
| Index | Keys, Foreign Keys | Associated with each key |
| Name | Name | |
| IndexMember | Associated with each attribute in a key | |
| Position | Order in the file | |
| Note | Notes | |
| Projection | Diagram Object Projection | Graphical Information |
| BackgroundColor | background color | |
| Bold | ignored | |
| FontColor | font color | |
| FontName | font | |
| FontSize | ignored | |
| Height | height | |
| Italic | ignored | |
| LineColor | line color | |
| Strike | ignored | |
| Underline | ignored | |
| Width | width | |
| X | x | |
| Y | y | |
| StoreModel | GroundWorks project | |
| Name | Name | |
| Synonym | Entity Synonym | |
| Name | Name |