Tibco Data Virtualisation Case Study – Fortune 50 Computer Financial Services
Business Challenge
TIBCO was presented with a complex business challenge by one of its Fortune 50 Financial Services customers in the US. The company was faced with the typical but not insignificant problem of integrating the data and systems of another large financial services organisation it had acquired. To complicate matters, this integration needed to take place against a backdrop of the industry implementing tough new regulations around data integrity and management.
The company in question had a history of physically consolidating data from acquired companies’ systems into their systems. As a result, their “acquisition integration DNA” was one of falling into “another massive ETL project.”
Taking a step back to contemplate
The Vice President that owned integration programme, looked at the challenge of the impending integration and the complications and costs implicit with extract, transform and load (ETL) projects where data is physically replicated. He identified several ETL downsides that he wanted to avoid, including the fact that ETL projects are often quite time consuming, and more so when dealing with data of massive scope as in this case. To achieve the benefits of the merger quickly, the firm did not have the luxury of waiting months to see the combined data. Furthermore, regulations required high levels of auditability from source to consumer and ETL, where transformations and storage occur in different systems, make this end-to-end traceability and attestation difficult.
In this instance, the newly acquired company had already successfully implemented a number of data virtualisation projects with TIBCO. This led to the question as to whether data virtualisation could be a viable data integration option, even though it would be a departure from the “automatic ETL” approach the acquiring company had traditionally taken.
Absorbing the benefits of Data Virtualisation
The data virtualisation experiences of the company being acquired provided an impressive reference point for how the technology could be used generically. They had already implemented a significant data virtualisation layer that had integrated 200 disparate data sources from 25 applications serving over 500 data consumers. This delivered a number of clear business benefits. By virtualising access to these data sources, the company reduced infrastructure costs associated with building physical data stores. They were also able to become far more flexible and agile in quickly giving data consumers quick and easy access to new data sources with no disruption. The projects had also increased business opportunities as developers can now rapidly connect new applications to new data sources and thereby accelerate new application delivery. Plus every access point, transformation, and delivery was automatically tracked, making data audits easier than ever before.
Rapid Merger Data Integration
Seeing the benefit of the existing data virtualisation use cases, the VP of the acquiring company was able to satisfy himself that his curiosity around the technology was well founded. As a result, the firm applied data virtualisation to create a single virtualised pool of integrated data from across the two companies. This gave data consumers one virtual place to go for data from either or both firms. And with data virtualisation they were able to provide this data without having to first “lift and shift” from the acquired firm’s data management systems into equivalent systems at the acquiring firm using ETL. And from a time to merged business value point of view, with data virtualization the merged companies were able to get a unified view of all their data within weeks, whereas ETL would have required months, if not longer.
Post-Merger Value
Virtualising access to the data sources, while leaving them in place meant that the company got the integrated view of data they needed without having to make fundamental decisions about which systems and applications they might eventually need to adapt or decommission. This removed the pressure to make rapid and possibly mistaken core infrastructure decisions at the time of integration. As an example, both companies in this merger had its own commercial banking portal. The merged organisation needed one portal with the branding of the acquiring company. Once the initial integration between the portals was accomplished virtually, the company was able to go back and modify or retire underlying or consumer systems independently without affecting their valued commercial banking customers.
Proven ROI
Once the dust had settled after the successful merger, the company was able to access and quantify what turned out to be a quite compelling ROI on their use of TIBCO Data Virtualisation.
Meeting merger schedule objectives – The company was able to meet all the deadlines for integrating data and thus enable a seamless business transition. This included supporting the data needs for both internal and external data consumers, within and across both firms.
Deliver additional revenue streams – The VP carried KPIs to implement integrations that enabled new revenue streams. By quickly plugging new data streams from the merged firm into a variety of customer applications, data virtualisation accelerated the time-to-market for these revenue driving applications.
Cost effective consolidated infrastructure – Because data virtualization leverages existing data infrastructure, there was no need to spend on additional databases, ETL and integration infrastructure.
Success Factors Summarised
Utilizing a data virtualisation platform, where data consumers are separated from data sources provided the organization with the integration agility that was the foundation for realising the merger’s strategic value. TIBCO Data Virtualisation not only facilitated a swift and painless merger integration, it provided a solid, agile data infrastructure to drive additional improvements post-merger. Distinct from other data virtualisation solutions, TIBCO Data Virtualisation’s unique contributions to this foundation were absolutely critical including:
- The ability to easily create virtual views/data services across disparate data sources using TIBCO’s integrated development environment (IDE) facilitated rapid response to new information requests. This turned business users into data virtualization advocates.
- TIBCO’s ability to cache materialised views offered significant benefits, such as providing 24×7 access to data, minimizing the performance effect on underlying systems and the ability to update the cache on a scheduled basis. These effectively countered objections from ETL teams designed to justify the data-consolidation status quo.
- TIBCO’s ability to expose business functionality as web services eliminated the need to write special Java or web services wrapper code. This enabled the delivery of a wide variety of data sources – including legacy, external, merged and more – to the business in a consistent manner and further encouraged business adoption of data virtualization.
Through agile integration of new data sources and new data consumers whenever the need arises, TIBCO’s value add has continued beyond the merger use cases, contributing daily to the companies’ top and bottom lines. That’s a merger we can all respect!
Archive
- October 2024(44)
- September 2024(94)
- August 2024(100)
- July 2024(99)
- June 2024(126)
- May 2024(155)
- April 2024(123)
- March 2024(112)
- February 2024(109)
- January 2024(95)
- December 2023(56)
- November 2023(86)
- October 2023(97)
- September 2023(89)
- August 2023(101)
- July 2023(104)
- June 2023(113)
- May 2023(103)
- April 2023(93)
- March 2023(129)
- February 2023(77)
- January 2023(91)
- December 2022(90)
- November 2022(125)
- October 2022(117)
- September 2022(137)
- August 2022(119)
- July 2022(99)
- June 2022(128)
- May 2022(112)
- April 2022(108)
- March 2022(121)
- February 2022(93)
- January 2022(110)
- December 2021(92)
- November 2021(107)
- October 2021(101)
- September 2021(81)
- August 2021(74)
- July 2021(78)
- June 2021(92)
- May 2021(67)
- April 2021(79)
- March 2021(79)
- February 2021(58)
- January 2021(55)
- December 2020(56)
- November 2020(59)
- October 2020(78)
- September 2020(72)
- August 2020(64)
- July 2020(71)
- June 2020(74)
- May 2020(50)
- April 2020(71)
- March 2020(71)
- February 2020(58)
- January 2020(62)
- December 2019(57)
- November 2019(64)
- October 2019(25)
- September 2019(24)
- August 2019(14)
- July 2019(23)
- June 2019(54)
- May 2019(82)
- April 2019(76)
- March 2019(71)
- February 2019(67)
- January 2019(75)
- December 2018(44)
- November 2018(47)
- October 2018(74)
- September 2018(54)
- August 2018(61)
- July 2018(72)
- June 2018(62)
- May 2018(62)
- April 2018(73)
- March 2018(76)
- February 2018(8)
- January 2018(7)
- December 2017(6)
- November 2017(8)
- October 2017(3)
- September 2017(4)
- August 2017(4)
- July 2017(2)
- June 2017(5)
- May 2017(6)
- April 2017(11)
- March 2017(8)
- February 2017(16)
- January 2017(10)
- December 2016(12)
- November 2016(20)
- October 2016(7)
- September 2016(102)
- August 2016(168)
- July 2016(141)
- June 2016(149)
- May 2016(117)
- April 2016(59)
- March 2016(85)
- February 2016(153)
- December 2015(150)