IBM Cognos PowerPlay Transformer - 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.

  • 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

SPECIFICATIONS
Tool: IBM / Cognos PowerPlay Transformer version C11 via COM API on MDL File
See http://www.ibm.com/software/analytics/cognos/
Metadata: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage)
Component: CognosPowerPlayTransformer version 11.0.0

OVERVIEW
REQUIREMENTS
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)

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

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