2147336
page-template,page-template-right_sidebar,page-template-right_sidebar-php,page,page-id-2147336,page-child,parent-pageid-12536,strata-core-1.0.5,ajax_fade,page_not_loaded,wpb-js-composer js-comp-ver-6.2.0,vc_responsive

About Client

 

A popular tribal casino from Connecticut, US with 364,000 square feet (33,800 square meters) of gambling space. It is home to 2 luxury hotel towers totalling 1,600 rooms, a world-class spa, the 125,000 square-foot Earth Expo Centre, a championship golf course, more than 80 shops, restaurants, and bars as well as three award-winning entertainment venues.

Background

  • Informatica Intelligent Cloud Services (IICS) offer their integration platform as a service (iPaaS), a hybrid integration platform, to integrate and provide data and application services which can be deployed only on the cloud.
  • Since the cloud provider takes care of the software, hardware and networks in the cloud, there is a need to migrate our workload from Informatica PowerCenter (PwC) on-premise to Informatica Intelligent Cloud Services (IICS). Moreover, Informatica has stopped its support/service for PwC recently.

Challenge

  • Support for Informatica On-premise server has been stopped by Informatica

Objective

  • 150 workflows for 3000+ objects were migrated from Informatica on-premise to cloud using a migration tool provided by informatica

  • 90% of the objects were not ready to run because of the difference in feature of IICS and PwC

Our Solution

 

  • We checked each workflow to resolve the issue/ errors in each object
  • Run the workflow and do the functionality testing
  • Validate the data against sources (Application DB, third party sources etc.
  • User Acceptance Testing (UAT) of all the tables part of above work flows
  • The development source had no data at all, making it hard to test the ETL objects
  1. For this we came up with a solution of testing the objects on Production Informatica Intelligent Cloud Services.
  2. The ETL objects once developed, integrated and integration testing completed were migrated to prod Informatica Intelligent Cloud Services(IICS) with only source changed to production.
  3. The target though was still set to development. By doing this, the production source data was now being written to the development target.
  4. As PowerCenter(PwC) was still being run for reading production data and writing to prod target, we tested the data on development target against production target to complete the data Quality Analysis.
  • Once a workflow was signed off on Informatica Intelligent Cloud Services after the testing, the PowerCenter workflow was disabled on schedule and Informatica Intelligent Cloud Services was added to the schedule to replace it

Outcome

20 Weeks

Data migration from Informatica on Premise (PwC) to Cloud (IICS) for all the properties was completed in just 20 weeks which enhanced the digital footprint

02 Weeks

Additional support was extended for 2 weeks

Similar Case Studies

Would You Like Us To Contact You?

  • This field is for validation purposes and should be left unchanged.

Data Analytics & Business Intelligence Strategy Company

 

Subscribe to News Letter

  • This field is for validation purposes and should be left unchanged.

Gartner Reviews

Our Locations

Get Social With Us
© Copyright BizAcuity Solutions Pvt. Ltd.