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

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

This bridge uses the Gen API to export metadata, therefore Gen must be properly installed and configured on the machine where the bridge is executed.
The bridge requires access to the 'Workstation Update API' (ueapi32w.dll).
The path to the API must be set in 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 ASED QUESTIONS
Q: My model cannot be exported, and the Gen error is: EAPI_MODEL_INCOMPATIBLE_RC, what could this mean?
A: There can be many reasons, among those reasons are:
- the selected Gen version may not match with the version of the Gen software installed locally.
- the Gen software is limited to short 8.3 file names (Model.ief) and short path lengths (128 characters).

Q: What patches may be necessary?
A: For COOL:Gen 4.1a only: to run properly the 'Workstation Update API' requires some patches (currently TSN4133, TSN4140 and CSN4102) to be applied.
Contact your Computer Associates support for the availability of these patches.

Q: Why can I not see the 'Workstation Update API' in the COOL:Gen Product list?
A: Contact your Computer Associates support to get a Product Code that will allow
you to install the 'Workstation Update API'.

Q: How to install the COOL:Gen 5.0 APIs for Windows?
A: Note that this process should work also 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 finish the installation.
See the 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, 7.5, 8.0 Update API for Windows?
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 The bridge will create 4 DAT files in the directory specified by this parameter.
If this directory is accessible by Gen, the new model will be proposed in the list of possible models to open when you start Gen.
DIRECTORY     Mandatory
Version Specify the version of Gen to export to ENUMERATED
8.5
8.0
7.6
7.5
7.0
6.5
6.0
5.1
5.0
4.1a
8.5  

 

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  
Attribute Attribute  
Description Description  
DesignLevel Category LOGICAL_ONLY if Category is 'Derived'
InitialValue Default Value  
Name Name  
Optional Optional  
PhysicalName TD Name  
Position   Determine the order of the attribute
BaseType Attribute Domain  
DataType Domain See datatype conversion array
Length Length  
Name Name  
Scale Decimal Places  
CandidateKey Identifier  
Description Description  
Name Name  
UniqueKey Primary UID Flag  
Class Entity Type  
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
InitialValue Attribute Permitted Values Default Value  
Length Length  
LowerBound Attribute Permitted Values Range From  
Name Name  
PhysicalName   Based on the datatype
Scale Decimal Places  
UpperBound Attribute Permitted Values Range To  
DesignPackage Subject Area  
Description Description  
Name Name  
Generalization Partitioning  
Description Description  
GeneralizationRole Partitioning  
Index Identifier  
Position   Determine the order of the attribute in the key
StoreModel Main Subject Area an empty model will be populated with the Model Elements
Description Description  
Name Name  
TypeValue Attribute Permitted Values  
Name Value/Description  
Value Value