IBM Cognos PowerPlay Transformer - 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:
  • is only supported on Microsoft Windows.

  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor IBM
Tool Name Cognos PowerPlay Transformer
Tool Version C11
Tool Web Site http://www.ibm.com/software/analytics/cognos/
Supported Methodology [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage) via COM API on MDL File
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: IBM Cognos PowerPlay Transformer C11 (http://www.ibm.com/software/analytics/cognos/)
Import interface: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage) via COM API on MDL File from IBM Cognos PowerPlay Transformer Import bridge: 'CognosPowerPlayTransformer' 10.1.0

The bridge relies on the IBM Cognos Transformer OLE Automation API in order to import metadata. Therefore, IBM Cognos Transformer must be properly installed on the machine executing this bridge.

For the bridge to work properly, TransformerSDK.dll must be available on the user's system (it is included as part of the Transformer installation)


SUPPORT

Q: How do I provide IBM Cognos Transformer metadata to the support team to reproduce an issue?
A: You need to locate your MDL and/or PYJ file and send it to support team.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File The path name of the Transformer Model Definition Language (MDL, PYJ) file to import. FILE
*.mdl
*.pyj
  Mandatory

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"IBM Cognos PowerPlay Transformer"
Metamodel
CognosPowerPlayTransformer
Mapping Comments
     
Name Alias Name  
Name Alias Name  
DesignLevel   as defined by the "Table Logical information" bridge option
Name Name  
Position   In the order returned by the Impromptu API.
DataType   See datatype conversion array
Name   Derived from the datatype
PhysicalName   Derived from the datatype
UniqueKey   Set to True
Class Data Source  
CppClassType   Set to ENTITY
CppPersistent   Set to True
DesignLevel   as defined by the "Table Logical information" bridge option
Name Name  
Name   set to <Main Subject Area>
ClassifierMap Join, Folder Items Used to hold the traceability of Joins and Folder Items via FeatureMap objects.
Name Name  
DataType   See datatype conversion array
Name   Derived from the datatype
PhysicalName   Derived from the datatype
DesignPackage View  
DesignLevel   Set to LOGICAL_ONLY for Folders
Name Name  
Dimension Dimension  
Description description  
Name Name  
DimensionAttribute Level  
Description description  
Name Name  
Name Name  
Name Name  
FeatureMap Join, Item Used to hold the traceability of Joins Condition and Items
Operation expression parsed SQL expression, empty if simple enough (direct mapping)
Name Name  
Type Outer  
UserDefined   Set to True
Multiplicity OuterJoin  
Measure Measure Numeric Calculation Items are imported as Measures
Name Name  
Name Name  
Name Name  
Name Name  
StoreModel Model file  
Description Description