Experience / Case Studies

Case Study: Therma-Tru - Informatica to Talend Conversion

Migrating existing Informatica code base to Talend

About Therma-Tru

Therma-TruTherma-Tru is the leading entry door brand most preferred by building professionals. Founded in 1962, Therma-Tru pioneered the fiberglass entry door industry, and today offers a complete portfolio of entry and patio door system solutions, including decorative glass doorlites, sidelites, transoms, and door components. Therma-Tru is headquartered in Maumee, Ohio.

Therma-Tru’s Business Needs

Therma-Tru was using on-premise Informatica PowerCenter for populating SQL server Datawarehouse and was experiencing issues with slow performance. Therma-Tru was planning to standardize their enterprise ETL tool as Talend and were looking for integration partners who could accelerate this migration process. 

Therma-Tru’s Selection Process

Therma-Tru opted to migrate from Informatica PowerCenter to Talend Studio 7.3.1 because it met all their real-time big data processing and cloud requirements.
Therma-Tru selected KPI for this assignment due to KPI's cloud ETL migration capabilities and their prior successful projects in similar engagements.

What KPI Delivered

  • KPI converted highly complex Informatica mappings to Talend using KPI's Partner solution, BladeBridge converter
  • KPI Optimized the auto-converted code to meet Therma-Tru's business needs. KPI implemented Talend best practices
  • KPI performed rigorous testing and ensured the converted code was production-ready.
  • KPI fixed issues found during UAT as prioritized by Therma-Tru within available UAT time. KPI provided Project Management services as an add-on.
  • To accelerate the project timeline pro-actively plan the workload, scheduling, and any required training for client personnel in a timely manner. Transferred knowledge to client personnel in a manner that ensures the project was successful after the KPI Partners engagement.

Business Benefits

  • Automated code conversion up to 90%
  • Quality Assurance on migrated data and functionality
  • 3x report performance improvement on average for enhanced user adoption
  • Faster ETL incremental loads to give users their data faster
  • Cloud Migration resulting in reduced maintenance cost of ETL server/ platform
  • Faster Project delivery due to usage of BladeBridge automation software
  • Cost-saving up to 50%

Tags: Case Study, MS SQL server, Informatica PowerCenter, Therma-Tru, Talend Studio, BladeBridge, Ajay Kumar

Subscribe to the Case Studies