IBM Cognos Series 7 Impromptu - 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 Series 7 Impromptu
Tool Version 7.0.702, 7.1.116, 7.1.529, and 7.3.1413
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 XML File
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: IBM Cognos Series 7 Impromptu 7.0.702, 7.1.116, 7.1.529, and 7.3.1413 (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 XML File from IBM Cognos Series 7 Impromptu Import bridge: 'CognosImpromptu' 10.1.0

The bridge relies on the Cognos Impromptu COM/OLE API in order to import metadata. Therefore, Cognos Impromptu must be properly installed on the machine executing this bridge.

If you just installed Cognos Impromptu on this computer, make sure to configure it, otherwise the API may not work properly:
- start the Cognos Configuration Manager,
- in the File menu, choose Open Current Configuration,
- select Cognos Impromptu / Impromptu Administrator / General
- press Validate (check mark icon)
- press Apply (green dot icon) in the toolbar.

This step will register the COM API in the Windows registry, where the following key should now appear: HKEY_CLASSES_ROOT\Impromptu.Application.

METAMODEL FAQ

FOLDERS:
The bridge creates metamodel Dimensions and Packages to represent Folders in Impromptu. A bridge parameter controls how folders are imported.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File The import path name corresponds to the name of the Catalog file to import. FILE *.cat   Mandatory
Login User Class Provide here the Catalog User Class required when opening a Catalog file in Impromptu.

When opening a distributed master catalog, you must use the Creator user class.
STRING   Creator  
Login Password Provide here the Catalog password for the specified Login User Class. PASSWORD      
Logout (Close) after execution Close Impromptu after importing the model. By default the tool will be closed.
'False' - The Impromptu application is left open on the desktop after the bridge has run.
'True' - The Impromptu application is closed after the bridge has run.

Note that the Impromptu application is started on the same machine where this bridge is running.

If running this bridge remotely on a distant server, this option should be set to 'True', otherwise the Impromptu application will be left running on the server.
BOOLEAN   True  
Data model Tables design level This option controls the design level of the imported tables.

It is particularly relevant when exporting metadata to a target tool which supports two views of the model: a logical view and a physical view.

Some Data Modeling tools support this concept, where you can decide if a table appears both as a physical table and as a logical entity.

Some Business Intelligence tools also support this concept, where you can decide if a table appears both in the physical model and in the business view of the model.

'Logical and physical' - If you would like the tables to appear both in the logical view and in the physical view of the model.

'Physical' - If you would like tables to appear only in the physical view of the model (default).
ENUMERATED
Physical
Logical and physical
Physical  
Dimensional model Folders This option controls how the tree structure of Folders and subFolders should be imported.

The bridge will import each Folder containing Items as a Dimension (as defined by the CWM OLAP standard). In addition, Folders and subFolders can also be imported as a tree of Packages (as defined by the CWM and UML standards).
'As a flat structure' - No Packages are created (default).
'As a simplified tree structure' - A Package is created for each Folder with subFolders.
'As a full tree structure' - A Package is created for each Folder.
ENUMERATED
As a flat structure
As a simplified tree structure
As a full tree structure
As a flat structure  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"IBM Cognos Series 7 Impromptu"
Metamodel
CognosImpromptu
Mapping Comments
     
AliasClassifier Alias Table The link to the source table is managed by a ClassifierMap
Name Alias Name  
AliasFeature Alias Column The link to the source column is managed by a FeatureMap
Name Alias Name  
Attribute Column  
DesignLevel   as defined by the "Table Logical information" bridge option
Name Name  
Position   In the order returned by the Impromptu API.
BaseType Column, Item BaseTypes are created to represent the columns and Items datatype
DataType   See datatype conversion array
Name   Derived from the datatype
PhysicalName   Derived from the datatype
CandidateKey Column A primary candidate key is created for columns part of their table's primary key
UniqueKey   Set to True
Class Table  
CppClassType   Set to ENTITY
CppPersistent   Set to True
DesignLevel   as defined by the "Table Logical information" bridge option
Name Name  
ClassDiagram   One default Diagram is created to display the tables and joins used in the catalog
Name   set to <Main Subject Area>
ClassifierMap Join, Folder Items Used to hold the traceability of Joins and Folder Items via FeatureMap objects.
Condition Join, Filter Used to hold the WhereClause statement of Joins via a FeatureMap object. Used to hold the Condition of a Filter via a FeatureMap object.
DatabaseSchema Database Schema  
Name Name  
DerivedType Column, Item  
DataType   See datatype conversion array
Name   Derived from the datatype
PhysicalName   Derived from the datatype
DesignPackage Folder One default Package is created to store the tables and joins used in the catalog. The folders are also imported as a tree of logical packages, or flattened into the default package, as set by the "Import Folders" bridge option.
DesignLevel   Set to LOGICAL_ONLY for Folders
Name Name  
Dimension Folder A dimension is created for each Folder containing Items
Name Name  
Type   Set to Regular
UserDefined   Set to True
DimensionAttribute Item  
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)
Filter Item Filter Items are imported as Filter
Name Name  
Join Join  
Type Outer  
UserDefined   Set to True
JoinRole Join 2 JoinRoles are created for each join
Multiplicity OuterJoin  
Measure Item Numeric Calculation Items are imported as Measures
Name Name  
Prompt Prompt Item  
Name Name  
PromptAnswer Prompt Item  
Name Name  
SQLViewAssociation   Views are managed as regular Tables in the tool
SQLViewAttribute   Views are managed as regular Tables in the tool
SQLViewEntity   Views are managed as regular Tables in the tool
StoreConnection Database Catalog  
Name Name  
StoreModel Catalog file The model is built using the Catalog tables, columns, joins, folders and items
Description Description  
Name   Catalog file name