Overview

Skill Level: Advanced

IIS Insights, Analytical thinking for Data Processing

This topic covers, how to make use of available IBM IIS Tools / Applications to achieve the Bulk CRUD operations in Information Governance Catalog (Data Governance).

Ingredients

  • Intermediate Knowledge in Information Governance Catalog (IGC) & Meta data Asset Manager (IMAM)
  • Basic Knowledge in OPEN IGC
  • Understanding of Rest full / SOAP services (Real time integration)
  • Intermediate JSON Structures & Notations (Messages are invoked with JSON format over Https protocol)
  • Basic of SSL Connections
  • Expertise in IBM Data Stage (Real time nodes - Hierarchical Stage)

Step-by-step

  1. Problem Statement

    Business / Technical Users need to perform CRUD ( Create ,Read, Update and Delete) operations on the governance assets in Information Governance Catalog.

  2. Recommended Solution

    The above request can be achieved by simply browsing & editing the governance assets in IGC,
    will term this implementation as “Manual Manipulation”. (Approach 1)

    In case the users need to process (CRUD operations) Bulk glossary assets, then “Bulk Manipulation”
    can be used to achieve the required. (Approach 2)

  3. Manual Work flow

    Manual-Workflow

  4. Bulk Work flow

    Bulk-Work-Flow

  5. Comparison Graph - CRUD vs Time

    Comparison-CRUD-vs-Time

  6. Sample Use Case

    • Lets update the multiple “IGC Terms” short and long description, stewards, labels & custom attributes in single shot.
    • 5 IGC Terms will be updated with above properties in our example (more properties can be updated depends on the user needs)
    • This example is applicable for all governance assets including database tables, views, governance rules, policies, ETL designs, applications etc.
    • This use case is demonstrated in TCS environment, IBM IIS Application version 11.7 (Knowledge Acquisition)
  7. Create Information Governance Catalog Terms

    Create-IGC-Terms

  8. Users(Layman) Input

    Layman-Input

  9. Generate Asset Id’s

    Generate-Asset-Id’s

  10. System Input

    System-Input

     

  11. System Input -> JSON Format

    System-Input-JSON-Format

     

    System-Input-JSON-Format-2

     

     

  12. Data stage Job : Convert_CSV_to_JSON

    Convert_CSV_to_JSON-Job

     

  13. Overview : Open IGC

    Open-IGC

     

  14. Data Stage Job : IGC_Rest_Call

    IGC_Rest_Call-Job

     

    IGC_Rest_Call-Job-21

     

    IGC_Rest_Call-Job-3

     

    IGC_Rest_Call-Job-4

     

     

  15. Validate Results in IGC

    Validate-Results-in-IGC

     

  16. Audit : IGC_Rest_Call Job

    Audit-IGC_Rest_Call-Job

     

3 comments on"Information Governance Catalog - CRUD Operations"

  1. Muthusundar March 31, 2018

    Hey Sundar,

    Thank you for sharing this document.

  2. Vikas KPandey April 03, 2018

    Yougasundar,

    Very innovative insight.
    Good work and thanks for sharing.

  3. Thank you for good information .

Join The Discussion