CA Gen - 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.

  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor CA technologies
Tool Name Gen
Tool Version 4.1a to 8.0
Tool Web Site http://www.ca.com/us/products/product.aspx?ID=256
Supported Methodology [Data Modeling] Data Store (Physical Data Model, Logical Data Model) via C API
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: CA technologies Gen 4.1a to 8.0 (http://www.ca.com/us/products/product.aspx?ID=256)
Import interface: [Data Modeling] Data Store (Physical Data Model, Logical Data Model) via C API from CA Gen Import bridge: 'CaCoolGen' 10.1.0

This bridge uses the Gen API to import metadata, therefore Gen must be properly installed and configured on the machine where the bridge is executed.

The bridge requires access to either the 'Workstation Update API' (ueapi32w.dll) or the 'Workstation Read Only API' (eapi32w.dll).
The path to the API must be set into the the environment variable 'PATH'.
Under Windows Control Panel / System / Advanced / Environment Variables, edit the value of 'PATH' system variable, and make sure it contains for example:
For version 7.6: C:\Program Files (x86)\CA\AllFusion Gen\Gen
For version 8.0: C:\Program Files (x86)\CA\Gen r8\Gen
For version 8.5: C:\Program Files (x86)\CA\Gen85\Gen

FREQUENTLY ASKED QUESTIONS
Q: My model cannot be imported, and the Gen error is: EAPI_MODEL_INCOMPATIBLE_RC, what could this mean?
A: There can be many reasons, among those reasons are:
- the model is from a different version which is not compatible with the version of the Gen software installed locally.
- the model is already openned in the Gen tool, you need to close it before using the bridge.
- the Gen software is limited to short 8.3 file names (Model.ief) and short path lengths (128 characters).

Q: What patches must be applied?
A: For COOL:Gen 4.1a only, if you use the 'Workstation Update API', you must apply some patches (currently TSN4133, TSN4140 and CSN4102).
Contact your Computer Associates support for the availability of these patches.

Q: How to install the COOL:Gen 5.0 Workstation APIs for Windows?
A: Note that this process should also work for COOL:Gen 5.1 and 6.0.
a. At the CD-ROM install, select the option for Custom Installation.
b. At the CD-ROM Product List, select
- Read-Only Encyclopedia API or
- Read and Update Encyclopedia API
c. Follow the instructions displayed on the screen to select and install the appropriate API.
See COOL:Gen Documentation (Electronic Books) for details:
- Encyclopedia Administrator: Encyclopedia and Workstation API Guide.
- Installation: Encyclopedia and Workstation API Installation Guide: chapter 2.

Q: How to install the Advantage Gen 6.5 Update API for Windows?
A: a. At the CD-ROM install, select the option for Custom Installation.
b. At the CD-ROM Product List, select Workstation Update API
c. Follow the instructions displayed on the screen to finish the installation.

Q: How to install the Allfusion Gen 7.0 and 7.5 Update API for Windows:
A: a. At the CD-ROM install, select the option for Custom Installation.
b. At the CD-ROM Product List, select Workstation Update API
c. Follow the instructions displayed on the screen to finish the installation.

Note that for the Workstation Update API to appear in the list of components, you may need to install an appropriate FEATURE line in your ca.olf license file


Bridge Parameters

Parameter Name Description Type Values Default Scope
Directory First, download the model from the Gen Encyclopedia to the client, this operation will create a directory with .IEF extension containing 4 DAT files. Specify in the 'Directory' parameter the path of the directory containing the DAT files or the path of one of the DAT files. DIRECTORY     Mandatory
Design level Specify the design level of the model to import:

'Logical only' - For data model import,
'Physical only' - For technical design import.
ENUMERATED
Logical only
Physical only
Logical only  
Append volumetric information to the description field Import and append the volumetric (number of occurences) information to the description field. BOOLEAN   False  
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 Gen"
Metamodel
CaCoolGen
Mapping Comments
     
Association Relationship  
Aggregation   True if one of the role is part of a primary key
AssociationRole Relationship  
Description Description  
ExtraConstraint Deletion Rule  
Multiplicity Sometimes/Always, One/One or More  
Name Name  
Source   Based on the multiplicity of each role
AssociationRoleNameMap Relationship The association between the primary key column and the foreign key column
Attribute Attribute  
Description Description  
DesignLevel Category LOGICAL_ONLY if Category is 'Derived'
Name Name  
Optional Optional  
PhysicalName TD Name  
Position   In the order returned by the COOL:Gen API.
BaseType Attribute Domain  
DataType Domain See datatype conversion array
Name Name  
PhysicalName   Derived from the datatype
CandidateKey Identifier  
Description Description  
Name Name  
UniqueKey Primary UID Flag True for Primary Key
Class Entity Type  
CppClassType   Set to ENTITY
CppPersistent   Set to True
Description Description  
Name Name  
PhysicalName TD Name  
ClassDiagram Subject Area  
Description Description  
Name Name  
DerivedType Attribute Domain, Attribute Permitted Values  
DataType Domain See datatype conversion array
Description Description  
InitialValue Attribute Permitted Values Default Value  
Length Length  
LowerBound Attribute Permitted Values Range From  
Name Name  
PhysicalName   Derived from the datatype
Scale Decimal Places  
UpperBound Attribute Permitted Values Range To  
DesignPackage Subject Area  
Description Description  
Name Name  
ForeignKey Identifier Based on Primary Key and association role
Generalization Partitioning  
Description Description  
GeneralizationRole Partitioning  
Index Identifier Associated with each key
IndexMember   Associated with each attribute in a key
Position   Computed
StoreModel Model The model is built using the elements contained in the COOL:Gen ".ief" directory
Name   extracted from the directory name
TypeValue Attribute Permitted Values  
Name Value/Description  
Position   In the order returned by the COOL:Gen API.
Value Value