IBM Cognos
IBM Cognos is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics.
Objects Extracted
Enterprise Data Catalog extracts metadata of the following schema objects from an IBM Cognos Business Intelligence Suite resource:
- •Axis
- •Body
- •Crosstab
- •Crosstab Columns
- •Crosstab Node
- •Crosstab Node Member
- •Data Sources
- •DataAttribute
- •Database Query
- •Dimension
- •Field
- •Filter
- •Folder
- •Footer
- •Header
- •Hierarchy
- •Namespace
- •Package
- •Page
- •PromptAnswer
- •Queries
- •Query
- •Query Item
- •Query Package
- •Rectangle
- •Report
- •Table
- •Text
- •Variables
- •Cognos Column
- •OlapSchema Namespace
- •Connection Model
- •crosstab corner
- •FrameworkManager Model
- •QueryStudio Model
- •ReportStudioModel
- •Namespaces
- •ConnectionPackage Data Source
- •Repository
- •StoreConnection Data Sources
- •Alias column
- •Alias Table
- •Business layer view
- •Cell
- •Class
- •Businessobjectscolumn
- •Connection folder
- •Contexts
- •Crystal report
- •Crystal report model
- •Custom hierarchies
- •Data provider
- •Database connection
- •Default hierarchies
- •Target
- •Dimension result
- •Dimension variable
- •Enterprise folder
- •Formulas
- •Group Name Fields
- •Join
- •Key
- •Logical column
- •Measure result
- •Query filter
- •Report chart
- •Report field
- •Report folder
- •Report page
- •Report table
- •Repository
- •Schema
- •Section
- •Special fields
- •Summary fields
- •Group Name Fields
- •Universe folder
- •Universe model
- •Universe query
- •View
- •Web intelligence document
- •Web intelligence model
- •Connection
- •Expand mapping
- •Expression
- •Group
- •Joiner
- •Lookup
- •Lookup port
- •Mapping
- •Source qualifier
- •Derived table
Prerequisites
You must install the Enterprise Data Catalog Agent to extract metadata from IBM Cognos running on Microsoft Windows.
Permissions to Configure the Resource
Before you create an IBM Cognos resource, you must configure the permissions for the user account that you use to connect to IBM Cognos.
You must configure the read, execute, and traverse permissions for all objects for which Enterprise Data Catalog extracts metadata. For example, reports, queries, analysis, packages, and connections.
Basic Information
The General tab includes the following basic information about the resource:
Information | Description |
|---|
Name | The name of the resource. |
Description | The description of the resource. |
Resource type | The type of the resource. |
Execute On | You can choose to execute on the default catalog server or offline. |
Resource Connection Properties
The General tab includes the following properties:
Property | Description |
|---|
Agent URL | URL to the Enterprise Data Catalog agent that runs on a Microsoft Windows Server. Note: Make sure that you specify the URL in the following format: http://<hostname>:<connector_port>/MIMBWebServices |
Version | Indicates the Cognos server version. |
Dispatcher URL | URL used by the framework manager to send requests to Cognos. |
Namespace | Defines a collection of user accounts from an authentication provider. |
User | User name used to connect to the Cognos server. |
Password | Password for the user account to connect to the Cognos server. |
Detailed Lineage | Select to extract and ingest metadata related to transformation logic for assets that include transformations. A transformation indicates generation, modification, or passage of data between source and target connections. A transformation logic displays the mappings or data flow relation types between source assets and target assets related to the asset you select in Enterprise Data Catalog. |
Add Dependent Objects | Use to import dependent objects to the selection. Selecting this option requires a complete scan of report dependencies on the Cognos server. You can select any of the following options for this property: - - None: only imports the selected Cognos objects.
- - Packages referenced by selected reports: imports the reports and associated source packages.
- - All: imports the source packages when a report is selected and imports the dependent reports when a source package is selected.
|
Folder Representation | Specifies how the folders from Cognos framework manager must be represented. You can select from the following options: - - Ignore: ignores the folders.
- - Flat: represents the folders as diagrams, but does not retain the hierarchy.
- - Hierarchical: represents folders as diagrams and retains the hierarchy.
|
Transformer Import Configuration | The XML file that describes mappings between Cognos Content Manager data sources and PowerPlay Transformer models. |
Worker Threads | Number of worker threads required to retrieve metadata asynchronously. |
Auto Assign Connections | Specifies to automatically assign the connection. |
The Metadata Load Settings tab includes the following properties:
Property | Description |
|---|
Enable Source Metadata | Select to extract metadata from the data source. |
Content Browsing Mode | Specifies the content to be retrieved while searching the Cognos repository. You can select any of the following options: - - Packages Only: retrieves the packages and folders and does not retrieve the reports.
- - Connections Only: retrieves the list of connections.
- - All: retrieves the packages, folders, queries, and reports.
- - Content: allows you to reduce the scope of import to a smaller set of objects than the whole set of objects on the server.
|
Content | Specifies the hierarchy for the content objects. |
Memory | Specifies the memory required to run the scanner job. Select one of the following values based on the data set size imported: Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal |
Custom Options | JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters: - - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
- - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number.
- - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
- - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. The default value is 1.
|