EMC ProActivity 3.x & 4.0 - Import - Cloud

Talend Cloud Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Catalog

Note: This bridge is not available in Talend Cloud Data Catalog by default. You need to set up a remote harvesting agent to import metadata from this source. For more information, see Deploying a remote harvesting agent in Talend Cloud Data Catalog Administration guide.

Bridge Requirements

This bridge:
  • is only supported on Microsoft Windows.

Bridge Specifications

Vendor EMC (ProActivity)
Tool Name ProActivity
Tool Version 3.0 & 3.1 & 4.0
Tool Web Site http://www.proactivityinc.com/products/index.htm
Supported Methodology [Data Modeling] Data Store (Physical Data Model, Logical Data Model) via ODBC API
Data Profiling
Remote Repository Browsing for Model Selection
Incremental Harvesting
Multi-Model Harvesting

SPECIFICATIONS
Tool: EMC (ProActivity) / ProActivity version 3.0 & 3.1 & 4.0 via ODBC API
See http://www.proactivityinc.com/products/index.htm
Metadata: [Data Modeling] Data Store (Physical Data Model, Logical Data Model)
Component: ProActivity version 11.0.0

OVERVIEW
The bridge will connect to ProActivity server's underlying Database.

REQUIREMENTS
You need to create an ODBC Data Source Name (DSN), using the appropriate database ODBC driver. The bridge will use this DSN to connect to the ProActivity database.

FREQUENTLY ASKED QUESTIONS
n/a

LIMITATIONS
Refer to the current general known limitations at http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html or bundled in Documentation/ReadMe/MIMBKnownLimitations.html

SUPPORT
Provide a trouble shooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6


Bridge Parameters

Parameter Name Description Type Values Default Scope
Data Source Name Specifies the ODBC data source name to use to connect to the database.
Use the ODBC Administrator to configure a data source for the database that you will be accessing. Refer to OBDC online help for more information.
STRING     Mandatory
User Id Specifies the user name to use to connect to the database.

Enter the user name you specified when creating the DSN.

This should be the user id you use for loging on to ProActivity.
STRING      
Password Specifies the password to use to connect to the database.

Enter the password you specified when creating the DSN.

This should be the password you use for loging on to ProActivity.
PASSWORD      
ProActivity Version Specifies the version of the ProActivity database schema.

Make sure to set this value to the version of the ProActivity software you have.
ENUMERATED
3.0 & 3.1
4.0
3.0 & 3.1  
Encoding The character set encoding of the model to be imported.

If there are multiple choices for a language, the actual encoding will be indicated between parentheses.
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)
"EMC ProActivity 3.x & 4.0"
Metamodel
ProActivity
Mapping Comments
     
Association   An Association is created to link a BusinessObject and a DataObject
Aggregation set to true  
AssociationRole   Two association roles are created for each association
Position Order Order in the Data Element window list
Source True for the BO side True for the BO side
Attribute Data Element Attributes of Type Derived are not mapped
Description Notes  
InitialValue Default Value  
Name Name  
Optional Required?  
PhysicalName Origin Field Name  
Position Order Order in the Data Object window list
BaseType see DerivedType some MIRBaseType are created (see DataType Mapping below)
Class Business Object and Data Object Each BO and each DO found in the database is mapped into a class.
Description Notes  
Name Name  
PhysicalName Origin Entity Name Only for Data Objects
ClassDiagram Project A class diagram is generated for each project found in the database.
Description Project note  
Name Project name  
DerivedType Field Type and Data Element  
DataType   Computed from the name for some base types. For unknown types, the datatype is set to undefined. See also the datatype mapping below.
InitialValue Initial Value  
Name type name  
Scale Data Element decimal #  
UserDefined   set to True
DesignPackage Project A package is generated for each project found in the database.
Description Note  
Name Name  
StoreModel   A model named "ProActivity IT" is generated.