# EMC ProActivity 3.x & 4.0 - Import Availability-note[AWS](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-aws) AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com ## 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** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Incremental Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Multi-Model Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Remote Repository Browsing for Model Selection** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | **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.2.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 [MIMB Known Limitations](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Subsystems/ModelBridgeGuide/Content/MIMB-Known-Limitations.htm) 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 | **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.** |