CA COOL:BusinessTeam (GroundWorks) 2.2.1 - Import - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

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
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: CA technologies COOL:BusinessTeam 2.2.1 and 1.2A.5.0 (http://www.ca.com/acq/sterling/)
Import interface: [Data Modeling] Data Store (Logical Data Model) via VAR Export File from CA COOL:BusinessTeam (GroundWorks) 2.2.1 Import bridge: 'CaGroundWorks' 10.1.0

Please enter a description


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
Logical
Physical
Logical and Physical  
Encoding Specifies the character set encoding of the model to be imported or exported. If there are multiple choices for a language, the actual encoding will be indicated between parentheses. The default is 'Western European (Windows 1252)' on Windows and 'Western European (ISO 8859-1)' on other platforms. ENUMERATED
Central and Eastern European (iso-8859-2)
Central and Eastern European (windows-1250)
Chinese Traditional (big5)
Chinese Simplified (GB18030)
Chinese Simplified (GB2312)
Cyrillic (iso-8859-5)
Cyrillic (windows-1251)
DOS (ibm-850)
Greek (iso-8859-7)
Greek (windows-1253)
Hebrew (iso-8859-8)
Hebrew (windows-1255)
Japanese (shift_jis)
Korean (ks_c_5601-1987)
Thai (TIS620)
Thai (windows-874)
Turkish (iso-8859-9)
Turkish (windows-1254)
UTF 8 (utf-8)
UTF 16 (utf-16)
Western European (iso-8859-1)
Western European (iso-8859-15)
Western European (windows-1252)
Locale encoding
No encoding conversion
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