IDERA ER/Studio Data Architect - 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.

Bridge Specifications

Vendor IDERA
Tool Name ER/Studio Data Architect
Tool Version 7.0 to 18.x
Tool Web Site https://www.idera.com/er-studio-data-architect-software
Supported Methodology [Data Modeling] Multi-Model, Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout via DM1 File

Export tool: IDERA ER/Studio Data Architect 7.0 to 18.x (https://www.idera.com/er-studio-data-architect-software)
Export interface: [Data Modeling] Multi-Model, Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout via DM1 File to IDERA ER/Studio Data Architect Export bridge: 'EmbarcaderoErStudioDM1' 10.1.0

This bridge generates an IDERA ER/Studio DM1 file.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File Specify here the Embarcadero ER/Studio DM1 file to export. FILE *.dm1   Mandatory
Version Select here the version of ER/Studio you want to use ENUMERATED
Latest
17.1
16.5
16.0
9.5
9.0
8.5
8.0
7.5
7.0
Latest  
Create dimensional model This option enables the dimensional modeling features of ER/Studio for this model and exports the tables dimensional type properties. BOOLEAN   False  
Encoding Specifies the character set encoding of the DM1 file to generate.

The default is 'Western European (Windows 1252)'.
ENUMERATED
Japanese (shift_jis)
Korean (ks_c_5601-1987)
Western European (windows-1252)
windows-1252  
Summary lineage This parameter controls how ETL summary mappings are exported to ER/Studio.
ETL mapping metadata is generally imported and summarized at the level of OMG CWM Activities (Informatica Workflow, DataStage Container).
Such ETL Activity summary indicates which source tables and columns are related to which target tables and columns, whenever summarization is possible.
ETL Activity summary is represented in ER/Studio as a DataFlow, and it may contain a large number of source and target table components.

'Activity driven' - The Activity is represented with only one ER/Studio Transformation, with many source and target tables.
'Target table driven' - The Activity is decomposed into many ER/Studio Transformations, one for each target table. (default)
'Source table driven' - The Activity is decomposed into many ER/Studio Transformations, one for each source table.
'Target column driven' - The Activity is decomposed into many ER/Studio Transformations, one for each target column.
'Source column driven' - The Activity is decomposed into many ER/Studio Transformations, one for each source column.
'None' - No DataFlow or Transformation is created, only source and target models and tables are created.
ENUMERATED
Activity driven
Target table driven
Source table driven
Target column driven
Source column driven
None
Target table driven  
Convert Foreign Key Indexes This parameter specifies whether the Foreign Key Indexes are converted to ER/Studio.

'False' - Foreign Key Indexes are not converted to ER/Studio. (default)
'True' - Foreign Key Indexes are converted to ER/Studio.
BOOLEAN   False  
Connection Allows selecting a connection by name, if the source model contains multiple database connections.
If the source model contains multiple connections and this parameter value is left empty, the connection with the most objects is selected.
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"IDERA ER/Studio Data Architect"
Metamodel
EmbarcaderoErStudioDM1
Mapping Comments
     
Association Relationship/Foreign Key  
Aggregation Relationship Type Non Specific for Many to Many Identifying for aggregation = true Non-Identifying for aggregation = false
Description Definition  
DesignLevel Logical Only, Physical Only  
Name Business Name  
AssociationRole Relationship/Foreign Key  
ExtraConstraint Trigger Parent Action, Trigger Child Action  
Multiplicity Cardinality, Existence  
Name Verb Phrase, Inverse Verb Phrase  
OnDelete Trigger Parent Action, Trigger Child Action  
OnInsert Trigger Parent Action, Trigger Child Action  
OnUpdate Trigger Parent Action, Trigger Child Action  
Source   Parent Entity / Child Entity information
AssociationRoleNameMap ForeignKeyColumn  
Attribute Attribute/Column  
Comment Column Definition  
Description Attribute Definition  
DesignLevel Logical Only, Physical Only  
InitialValue Declared Default, Default  
Name Attribute Name, Logical Rolename  
Optional Allow Nulls  
PhysicalName Column Name, Physical Rolename  
Position Sequence  
BaseType Attribute Datatype  
DataType Datatype  
BusinessRule Defaults, Rules, Reference Values  
Description Definition  
LowerBound Range minimum  
Name Name  
UpperBound Range maximum  
Value Rule Value, Default Value  
CandidateKey Key / Index  
DesignLevel Logical only, Physical only  
Name Name  
PhysicalName Name  
UniqueKey Unique  
Class Entity/Table  
Comment Table Definition  
Description Entity Definition  
DesignLevel Logical only, Physical only  
DimensionalRole Dimensional model Table Type  
DimensionalType Dimension Table Type  
Name Entity Name  
PhysicalName Table Name  
ClassDiagram Submodel  
Description Definition Exported as Definition since version 8.0, as Attachment property for older versions
Name Name  
DatabaseSchema Owner Schema  
Name Owner  
DerivedType Domain, User Datatype, Attribute Datatype  
DataType Datatype  
Description Definition  
InitialValue Default, Declared Default  
Length Width  
LowerBound Reference Value Minimum  
Name Domain Name, UserDatatype Name  
Scale Scale  
UpperBound Reference Value Maximum  
ForeignKey ForeignKey  
Name Name  
PhysicalName Constraint name  
Generalization Supertype/Subtype Cluster  
GeneralizationRole Supertype/Subtype Relationship  
Identity Sequence, Identity properties  
Cycle Cycle  
IncrementValue Increment By  
MaximumValue Max Value  
MinimumValue Min Value  
StartValue Start Value  
Index Key/Index, ForeignKey  
Name Name  
Unique Unique  
IndexMember IndexColumn  
Position Sequence  
SortOrder Sort Ordering  
Note Note  
Value note text  
Projection Element Display Graphical information
BackgroundColor background color  
Bold bold  
FontColor Font text color  
FontName Font  
FontSize Font size  
Height height  
Italic italic  
LineColor outline color  
Strike strikeout  
Underline underline  
Width width  
X x  
Y y  
PropertyType Attachment  
DataType Data type  
Description Description  
Group Attachment Type Name  
InitialValue Value  
Name Name  
PropertyValue Attachment Binding  
Value Value override  
RelationshipProjection Relationship Display  
LineColor relationship color  
SQLViewAssociation View Relationship  
AliasName View Table Alias  
SQLTableSequence Sequence  
SQLViewAttribute View Column  
Expression Column Expression  
Name Name  
Position Sequence  
SQLViewEntity View  
Description Definition  
HavingClause Having  
Name Name  
ViewStatement DDL  
WhereClause Where  
Sequence Sequence  
DataType Datatype  
Length Datatype  
Name name  
NativeDataType Datatype  
Scale Datatype  
Shape Shape  
BackgroundColor Shape Background  
Bold Font Style  
FontColor Text Color  
FontName Font Font typeface name
FontSize Text Font Size  
Height   Height of the shape
Italic Text Font Style  
LineColor Shape Outline  
LinePoints   Vertex coordinates for pentagon, hexagon and octagon, or endpoints for straight line
Name Shape Name  
ShapeType Shape Type Type of the shape according to the Drawing Shapes toolbar
Strike Text Font Strikeout  
Underline Ttext Font Underline  
Width   Width of the shape
X   X coordinate of the shape center
Y   Y coordinate of the shape center
Z   Z order of the shape
StoreModel Diagram  
Description Definition  
Name Name  
SystemType Database Platform  
SystemTypeOld Database Platform  
StoredProcedure Procedure  
Description description  
Name name  
Semantics SQL  
Synonym Synonym  
Description Description  
Name Name  
Trigger Trigger  
Description Description  
Name Name  
Semantics SQL  
TypeValue Reference Value  
Description Value Description  
Name Value Description  
Position Sequence  
Value Value