IBM Watson Data & AI - Structured Ideas

Welcome to the idea forum for IBM Watson Data & AI — our team welcomes any feedback, requests, and suggestions you have for improving our products! 

This forum allows us to connect your product improvement ideas with IBM product and engineering teams. 

Add support for importing, managing, and providing lineage reporting for Cognos and other BI tools

There are 2 pieces here IMO

LOB viz/dashboards based on catalog

Harvest of CA metadata into catalog for audit/compliance. 

 

#1 is CA looking into catalog

#2 is using Catalog like IGC to manage compliance/lineage. Catalog pulling from Cognos.

 

Alex is answering #1 and that is what they are building with WACA

 

#2 is a compliance question. In the IGC onPrem world metadata harvest and lineage tracking from BI tools is one of the most popular use cases since BCBS239 and the other compliance use cases they sell into go something like this. 

 

Regulator: "Mr CIO you used BI reporting to make a business decision. Show me where the data you used for that decision came from". 

CIO: "Here's my lineage report"

 

How they build this BI report and track lineage for it. 

Step 1 - Customer uses Data Stage to ETL data into a data mart/warehouse

Step 2 - Customer builds BI reports using their favorite DW and tool of choice (Tableau, Cognos, Qlik)

 

Data Stage and IGC share the same catalog and operate in a closed loop proprietary system so every transformation that Data Stage does is immediately known to IGC, however once it's loaded into Cognos it has left the Info Server system yet still needs to be tracked. Cognos further processes and manipulates the data via cube/dimensional analysis. To provide full end to end linage IGC has connectors to these BI tools to pull that metadata and lineage into IGC which when coupled with Data Stage ETL provides the full end to end lineage view. 

 

I believe that second part...pulling from Cognos into catalog...is what Alex is askign about. 

 

IGC/Cognos integration for the compliance use case i described here

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.mdbbr.doc/topics/r_cognostm1_bridge_ref.html

 

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.mdbbr.doc/topics/MIRCognosRepositoryCommon_en.html

  • Guest
  • Jan 2 2018
  • Under Consideration
  • Attach files