Data Warehouse Modernization

Cognos Data Manager Conversion to Talend Big Data for Multinational Insurer

case-study-feature-img

An American multinational finance and insurance corporation required a solution for conversion of its IBM Cognos Data Manager ETL system to Talend 6.4

Client Challenges and Requirements

  • Detailed assessment of identified 50 Cognos ETL
  • Convert up to 50 Cognos ETL in current environment to Talend 6.4
  • Deliver Fully Unit Tested code for the converted Talend ETLs

Bitwise Solution

solution-icon

Environment setup as well as installation and configuration of required s/w for new client

solution-icon

High level Analysis & Design Document

solution-icon

Conversion of 50 ETLS covering dimension & fact loads and lookup builds of different complexities

solution-icon

Unit test results documentation in the form of comparison output reports using comparison jobs that were built for data validation in Talend

solution-icon

Scheduling on production box using scheduler (TAC)

solution-icon

Documentation from a change management perspective

Tools & Technologies We Used

Bitwise ETL Converter
Cognos Data Manager
Oracle
Talend 6.4
TAC or Autosys
GitHub
Unix

Key Results

skill-icon

Created custom Java code to generate schema for Talend components by reading Database Tables

skill-icon

Optimized performance by pulling only required fields or contexts into Talend

skill-icon

Created joblets for context parsing and logging

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?