Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia) - 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 UNICOM Systems
Tool Name System Architect (SA)
Tool Version 10.4.23 to 11.4.5
Tool Web Site http://unicomsi.com/products/system-architect/
Supported Methodology [Data Modeling] Data Store (Logical Data Model), Graphical Layout via COM API

Export tool: UNICOM Systems System Architect (SA) 10.4.23 to 11.4.5 (http://unicomsi.com/products/system-architect/)
Export interface: [Data Modeling] Data Store (Logical Data Model), Graphical Layout via COM API to Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia) Export bridge: 'PopkinSaEncy' 10.1.0

The bridge uses the System Architect COM/OLE Automation interface to connect to the tool, therefore System Architect needs to be installed locally in order to have this bridge running.

The System Architect API may not be completely installed by the Telelogic installer. To make sure the API is properly installed, please type the following command lines in a DOS window:

cd c:\Program Files\Telelogic\System Architect Suite\System Architect Suite\System Architect
sa2001.exe /regserver

This setup is required for Telelogic version 10.0.14 and all older versions.

FREQUENTLY ASKED QUESTIONS

Q: What types of diagrams does this bridge support?
A: This bridge supports Entity Relationship diagrams of Project Data Models.

Q: Does this bridge support the update of a Project Data Model?
A: No, if a data model with the same name already exists in the encyclopedia, the conversion process will not work. However you can use the 'Project Data Model name' bridge option to specify another name.

Q: On large models, the bridge does not respond until I respond to the following message: "The size of the undo file is too small for this diagram. Would you like to enlarge it to allow continued undoing?"
A: As the Telelogic bridge is API based, the Telelogic application may require interaction from the user. Please refer to Telelogic's documentation on how to eliminate some of these dialog boxes. In the case of this particular dialog, the undo file size can be set via Tools->preferences. The Undo file size is a numeric value; the maximum file size is 10M, and the default file size is 128K (when System Architect is initially installed).

Q: The export data model failed. This model worked in version 10.1.
A: Verify that the value in the connection name is correctly entered. The connection name in version 10.4 and greater is managed by the SA connection manager. In prior versions the connection name was the same name as the udl file.

Q: Some of my subject areas were not exported.
A: Your source model subject areas will not be exported, if there is a subject area with the same name in the SA encyclopedia.

Q: What are the required configuration steps when running the bridge as a Windows service?
A: This bridge interacts with System Architect via its COM based API which may have to display messages on the desktop. Therefore, if this bridge is running within a server launched as a Windows service (rather than a classic Windows desktop application), click on the 'Properties' menu of such service, go to the 'Log On' tab, select 'This account' and specify the same username and password used as Windows session when testing connectivity from System Architect to the encyclopedia, and restart the Windows service.

System Architect (SA) stores connection configuration files in the local user area. Therefore, if this bridge is running within a server launched as a Windows service (rather than a classic Windows desktop application), then such files must be available to the current user. In this case, running System Architect (SA) logged as 'JohnSmith' will store the connection files in:
Windows XP: 'C:\Documents and Settings\JohnSmith\Local Settings\Application Data\Telelogic\System Architect\Connections\*'
Windows 7: 'C:\Users\JohnSmith\AppData\Local\Telelogic\System Architect\Connections\*'

Q: Why does the bridge tries to export to a different Encyclopedia than specified in the parameters?
A: System Architect allows one to specify a default Encyclopedia to be opened at startup. In the 'File'->'Open' menu, the checkbox 'Open this encyclopedia at startup' should not be checked. If this checkbox is checked, it may interfere with proper bridge execution, and that encyclopedia will be used for the export. Therefore please uncheck that checkbox in the System Architect UI before exporting.


Bridge Parameters

Parameter Name Description Type Values Default Scope
Connection name Specify here the connection name to connect to the encyclopedia database.

In SA 10.4 and greater, the connection name is defined within the SA connection manager.
Note: Sometimes, the connection name required here will be different from what you see in the SA Enterprise Manager. To determine the required name:
1. Start System Architect
2. Select Open
3. Select Open Encyclopedia...
4. Look at the two columns called 'Name' and 'Located on Connection'
5. Be sure to use the value in the 'Located on Connection' column value for this bridge parameter.

Please refer to the Frequently Asked Questions in the bridge tooltip for the default Encyclopedia setting.
STRING     Mandatory
Encyclopedia name Specify here the encyclopedia name to connect to.
Note: Sometimes, the encyclopedia name required here will be different from what you see in the SA Enterprise Manager. To determine the required name:
1. Start System Architect
2. Select Open
3. Select Open Encyclopedia...
4. Look at the two columns called 'Name' and 'Located on Connection'
5. Be sure to use the value in the 'Name' column value for this bridge parameter.

Please refer to the Frequently Asked Questions in the bridge tooltip for the default Encyclopedia setting.
STRING     Mandatory
Project Data Model name This option allows to customize the name of the Project Data Model that will be created.

If this option value is empty, the bridge will use the Model name (as defined by the source tool) instead.

In SA 10.4 and greater, the project data model name must be defined, if the encyclopedia already includes any data models.
STRING      
Close System Architect Close System Architect after exporting the model. By default the tool will not be closed BOOLEAN   False  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia)"
Metamodel
PopkinSa
Mapping Comments
     
Association Relationship, Non-specific relation  
Aggregation Identifying  
Description Description  
Name Name  
AssociationRole Relationship, Non-specific relation  
ExtraConstraint Delete, Update, Insert Rule  
Multiplicity From Cardinality, To Cardinality, Allow Nulls  
Name Name, Reverse Phrase  
Source   determine the order of the relationship
AssociationRoleNameMap All Foreign Key Components  
Name Role Name  
Attribute Attribute/Data Element  
Comment Database Comment  
Description Description  
InitialValue Default Value  
Name Name  
Optional Default Nullity  
PhysicalName Column name  
Position   determine the order of the attribute in the entity (Description)
BaseType Data Domain, Attribute, Data Element  
DataType SQL Data Type See datatype conversion array
Name Name  
CandidateKey Access Path  
Name Name  
UniqueKey Unique  
Class Entity  
Comment Database Comment  
Description Business Description  
Name Name  
PhysicalName Table Name  
ClassDiagram Subject Area  
Description Description  
Name Name  
DataType SQL Data Type See datatype conversion array
Description Description  
InitialValue Default Value  
Length SQL Data Type Qualifier  
Name Name  
ForeignKey All Foreign Key Components  
Name Constraint Name Of either the Relationship or the Supersub relation
Generalization Super-sub Relation  
Description Description  
Name Name  
GeneralizationRole Super-sub Relation  
Index Access Path, All Foreign Key Components Associated with each key
Name Name, Constraint Name  
IndexMember Access Path, All Foreign Key Components  
Name Name  
Position Description determine the order in the Description property
SortOrder Description determine the /SEQ value
Note Notes  
Projection Symbol Graphical Information
BackgroundColor fill color  
FontColor font color  
Height height  
LineColor pen color  
Width width  
X x  
Y y  
RelationshipProjection Relation Symbol Graphical Information
BackgroundColor fill color  
FontColor font color  
Height height  
LineColor pen color  
Width width  
X x  
Y y  
StoreModel Project Data Model  
Description Description  
Name Name