Informatica Developer - Import - 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:
  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor Informatica
Tool Name Developer
Tool Version 9.x to 10.x
Tool Web Site https://www.informatica.com/products/data-integration.html
Supported Methodology [Data Integration] Multi-Model, Data Store (Logical Data Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing) via Eclipse Java API on XML File
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

BRIDGE INFORMATION
Import tool: Informatica Developer 9.x to 10.x (https://www.informatica.com/products/data-integration.html)
Import interface: [Data Integration] Multi-Model, Data Store (Logical Data Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing) via Eclipse Java API on XML File from Informatica Developer
Import bridge: 'InformaticaDeveloper' 10.1.0

BRIDGE DOCUMENTATION
This bridge imports Informatica Developer metadata objects from an XML file.
This bridge requires a Java version 1.6.

FREQUENTLY ASKED QUESTIONS


Bridge Parameters

Parameter Name Description Type Values Default Scope
File The bridge uses an XML file exported from Informatica Developer.

For example, to export one or more data models using Informatica Developer into an XML file:
1. Start the Developer tool.
2. From the 'File' menu, select the 'Export' menu item.
3. From the Export wizard, select 'Informatica', then 'Object Export File'.
4. Then, select a project, and the data model(s) to export.
5. Finally, specify the XML file location, name and click the 'Finish' button.

For more details about exporting and importing objects, refer to the Informatica documentation.

This bridge will use the generated XML file as input.
FILE *.xml   Mandatory
Miscellaneous Specify miscellaneous options identified with a -letter and value.

For example, -l -c -m 4G -j -Dname=value -Xms1G

-v set environment variable(s) (e.g. -v var1=value -v var2="value with spaces").
-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
-pppd enables the DI/ETL post-processor processing of DI/ETL designs in order to create the design connections and connection data sets.
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Informatica Developer"
Metamodel
InformaticaDeveloper
Mapping Comments
     
Association Reference  
Aggregation   computed from migrated FK attributes
Description Description  
Name Name  
AssociationRole Reference Two roles are created for each Reference
Multiplicity   set to 0..1 on the parent role, 0..* on the child role
Source   set to TRUE on parent role, FALSE on child role
AssociationRoleNameMap Reference created if FK attribute renaming occurs
Attribute Attribute  
Description Description  
InitialValue Default Value  
Name Name  
Optional Nullable  
Position Position  
BaseType Attribute Datatype BaseTypes are inferred from datatypes found in the model
DataType Datatype computed
CandidateKey Primary, Alternate Key  
Description Description  
Name Name  
UniqueKey   set to True
Class Logical Data Object  
CppClassType   set to ENTITY
CppPersistent   set to True
Description Description  
Name Name  
DerivedType Attribute Datatype  
DataType Datatype See datatype conversion arrays
Length Precision  
LowerBound Lower constraint  
Scale Scale  
UpperBound Upper constraint  
ForeignKey Reference  
StoreModel Model  
Description Description  
DesignLevel   set to LOGICAL_ONLY
Name Name