The Cost Cutting Value of Real-Time Data Integration

Share it on Twitter  
Share it on Facebook  
Share it on Linked in  
Slide Show

Strategic Integration: 10 Business-Building Tips

Ten ways that companies can use integration and integration-related strategies to build business.

It's easy to imagine how real-time data integration would be a great thing for many businesses. Who wouldn't want to know which products are still stocked on the shelves or access to the most up-to-date customer information?


It'd be a no-brainer-and certainly, there's interest in real time. According to a 2009 TDWI survey, while only 17 percent of survey respondents said they used real-time functionality with their data warehouse, an impressive 92 percent said they plan to add it within three years.


But there may be reasons beyond the business potential to consider adding real-time data integration. Roger Li, the senior VP for Oracle's Fusion Middleware, Asian Pacific Division, contends that real-time integration can actually save you money and reduce risks:


"Many organizations are wary of data integration projects, believing they involve data migrations that are complicated, expensive, and likely to impact day-to-day operations. However, data integration and replication solutions exist that facilitate the capture, routing, transformation, and delivery of transactional data between heterogeneous databases in real time with minimal overhead. Best of all, the benefits of data integration can be felt almost immediately."


Vendor-written pieces are often just re-purposed sales brochures, but I was pleasantly surprised by this InformationWeek article because it focuses on actual companies that have deployed real-time data integration and how they benefited from it. In fact, Oracle's only mentioned twice in the entire piece-in Li's byline and his short bio.


Li draws on the real-world experiences of Hyundai Securities, the Indian department store Shoppers Stop and the Bombay Stock Exchange to prove the value of real-time data integration. So how did it help these companies, and in particular, how did it help them save money? You'll want to read the full article for details, but there are three main ways it did this:


  1. It expanded the life of legacy systems, saving companies the cost of data migration projects.
  2. It sped transaction times, in one case to five times the number the company previously handled.
  3. It cut costs by eliminating manual transactions.


If you'd like to learn more about real-time data integration, consider signing up for a free Informatica webinar on the topic featuring TDWI's Senior Manager of Research and Services Philip Russom. Frankly, it's my opinion that Russom is always worth hearing, and he'll be speaking specifically about real-time data warehouses which, the promo notes, are "less about the warehouse and more about the data integration functions that feed the warehouse."


The event is scheduled for Tuesday, Sept. 14, at 1 p.m. ET or 10 a.m. PT. Among the topics Russom will cover are what techniques are available to achieve real-time data integration and how data virtualization fits into the overall architecture.