English
JapaneseImpact Stories
Transforming Banking Dynamics with SBI's Informatica Upgrade Journey
Optimizing Banking Operations by SBI's Data Transformation Journey
Company Name
SBI
Industry
Banking
Location
India
Implementation
Optimized Strategic Upgradation
Application
Informatica
Background
State Bank of India (SBI), one of the largest banks in India, has leveraged Informatica's data management solutions to enhance its operations and customer services by upgrading its system from Informatica version 10.4.1 to 10.5.3. This collaboration between SBI and Informatica signifies a strategic approach to managing data effectively in the banking sector.
Our Approach
Implementing Informatica 10.5.3 Across SBI's Servers
SBI’s business operational value is quite huge and valuable, they couldn’t afford long downtime and system unavailability. So, we devised a strategy for smooth data transfer and technology update from 10.4.1 accomplishing accurate and fast upgrade to informatica 10.5.3 without compromising on data integrity, security and system availability.
Challenges Faced
System Downtime & Business Continuity
For an organization as massive as the State Bank of India (SBI), minimizing downtime is crucial as any interruption in services can lead to significant financial losses and affect customer satisfaction.
Fixing Informatica 10.5.3 incompatibility with RHEL7
Informatica 10.5.3's compatibility issues with RHEL7 pose a significant challenge as it hinders the smooth functioning of the system and can lead to errors, failures, or security vulnerabilities.
Identifying necessary system upgrade/installation
Identifying the specific upgrades or installations required to support the Informatica upgrade process can be complex, especially in a multifaceted environment like SBI's, as any missing components or dependencies can lead to system errors or failures.
The Strategy
Server/Structure Mirroring
We did not want to disturb the current working ecosystem of SBI comprising of four environments, System Integration Testing (SIT), User Acceptance Testing (UAT), Production, and Disaster Recovery (DR) servers. So, we started this process on New Servers for upgrade. Set up all these four environments on new servers by importing data backup of current running servers on version 10.4.1, ensuring smooth data transfer with rigorous load testing.
Transformation Preparation
New Informatica is incompatible with current Operating system RHEL7, pressing for OS Upgrade to RHEL8 Also, Oracle Client Software had to be updated across all servers as per the current OS upgrade for smooth and effective communication between client software and Data Base Servers. Upon successful update, followed rigorous testing and trouble shooting.
The Upgrade to New Informatica 10.5.3
Initialized the upgrade to Informatica 10.5.3, across all four servers by installing and restoring data backup, tested by executing sample workflows and verifying existing mappings and configurations to ensure error-free system upgrades.
Finalizing main connections
Upon successful upgrade, the SBI’s system interface was connected to new servers for SBI to run its operational functions on the new upgraded Informatica 10.5.3
Business Outcome
Operational Streamlining
Cubastion's strategic approach led to operational benefits, making the system more robust and user-friendly, reducing administrative overhead and enhancing overall system reliability.
Enhanced Stability
The upgrade to Informatica 10.5.3 significantly enhances platform stability, allowing SBI to focus more on leveraging the tool's capabilities rather than troubleshooting technical issues.
Expanded Catalog Curation
With the upgraded EDC API in informatica 10.5.3, SBI gains greater flexibility in curating the data catalog, enabling the addition of business metadata to complement technical metadata effectively.
