CA COOL:Xtras Mapper (TerrainMap for DB2) - Import

Bridge Specifications

Vendor	CA technologies
Tool Name	COOL:Xtras Mapper
Tool Version	5.3.2
Tool Web Site	http://www.ca.com/acq/sterling/
Supported Methodology	[Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing) via VAR Export File
Data Profiling
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection

SPECIFICATIONS
Tool: CA technologies / COOL:Xtras Mapper version 5.3.2 via VAR Export File
See http://www.ca.com/acq/sterling/
Metadata: [Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing)
Component: CaTerrainMap version 11.2.0

OVERVIEW
This metadata bridge is a model integrator that takes as input:

- a logical data model from a COOL:BusinessTeam VAR file and

- a physical data model from a COOL:DBA VAR file and integrates them to produces a logical and physical data model.

REQUIREMENTS
To use this bridge, you should supply the full path to the logical COOL:BusinessTeam VAR file to the bridge option named 'Groundworks file' and the full path to the physical COOL:DBA VAR file into the usual 'From' field.

IMPORTING FROM STERLING SOFTWARE COOL:BUSINESSTEAM (GROUNDWORKS)

When a model is currently loaded in Sterling Software COOL:DBA (Cayenne Terrain for DB2):

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'.

Some versions of the Terrain design tool, such as Sterling COOL:DBA 2.1.6, may offer the choice between multiple VAR export format flavors:
- The 'Terrain for DB2 5.3 format' flavor is supported by this bridge
- The 'Terrain for DB2 5.4 format' flavor is supported by this bridge
- The 'COOL:DBA 2.1 format' flavor is supported by this bridge
- The 'COOL:DBA 2.x Full Meta Format' flavor is not supported by this bridge

FREQUENTLY ASKED QUESTIONS

Q: How does this bridge work?
A: The TerrainMap utility, delivered with the COOL:DBA tool, allows to generate COOL:DBA physical data models from COOL:BusinessTeam logical data models. This bridge uses the information generated by TerrainMap (MAPSYSMAP) in the COOL:DBA VAR file to merge each physical object with its corresponding logical object in the logical model.

Q: What is the recommended Terrain VAR format flavor?
A: We know the choice of a Terrain VAR format flavor has an impact on how the mapping and traceability information between a logical model and a physical model is encoded and saved in the file. The TerrainMap integrator bridge allows to use this mapping information to integrate a logical model and a physical model. In order to do that, make sure to choose one supported format flavor, and set the option labelled 'Mapping encoding version' to the appropriate value:

- Terrain for DB2 5.3: This one applies if you saved your Terrain model using the export flavor 'Terrain for DB2 5.3'
- Terrain for DB2 5.4: This one applies if you saved your Terrain model using the export flavors 'Terrain for DB2 5.4' or 'COOL:DBA 2.1'

LIMITATIONS
Refer to the current general known limitations at MIMB Known Limitations or bundled in Documentation/ReadMe/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

Bridge Mapping