Newsletters Welcome, Guest Log In | Register

Integration

Begin with business processes and then progress into leading-edge technologies

About this Blogger RSS

Subscribe

Sign up now and get the best business technology insights direct to your inbox.

  • Daily Edge
  • CTO Edge Update
  • Business Tools & Templates
  • Aligning IT & Business Goals
  • Maximizing IT Investments

2

The Unexpected Business Uses of Data-Synchronization Tools

Posted by Loraine Lawson May 20, 2009 3:23:21 PM

Data synchronization is a critical part of many integration projects. If you're consolidating CRM systems, undertaking a master data management project, building support for real-time fraud detection or just trying to provide better customer service, then you're probably going to need data synchronization.

 

In fact, data synchronization tools and techniques “are used today at an unprecedented level,” according to The Data Warehousing Institute, thanks in part to the increase in both transactional and operational data-integration projects.

 

TWDI recently published a free checklist on data-synchronization tools. It's titled a checklist, but I thought that was a bit of a misnomer – it's more of a FAQ, detailing the numerous uses and attributes of data synchronization, but written in the format of a list.

 

To be honest, I thought “data synchronization” was a bit self-explanatory, and it's not like this is exactly a new thing. But I actually found the report very illuminating, because it speaks directly to how data synchronization can support specific, strategic business needs without being overly technical.

 

Mind you, there's still a healthy dose of technical information in the report, but it manages to remain useful and accessible to business readers. For instance, the report explains there is a difference between data synchronization and data replication, even though many data-synchronization tools are built with replication technology. In fact, many data-integration tools – including enterprise application integration and ETL – can be used or contribute to data syncing, according to the report.

 

Primarily, the report speaks to when you would use a data-synchronization solution and how data synchronization aids other technology initiatives. Here's the primary business-use cases the report describes:

  • On-going synchronization of customer data across multiple CRM and CDI solutions, which helps improve data integrity.
  • Synchronizing operational data across ERP applications.
  • Real-time data delivery – especially if you're interested in improving customer service, cross-selling, up-selling, detecting fraud or material management.
  • Providing database high availability, because it can handle the “bidirectional active-active configurations that are becoming the standard architecture for database high availability.”

 

As I said, the report is free, but you do have to fill out a standard information form. It's written by TDWI analyst Philip Russom and sponsored by GoldenGate Software, which, of course, sells a data-synchronization product. (Incidentally, if you're curious about GoldenGate, I recently interviewed GoldenGate Vice President of MarketingSami Akbay, about why real-time retail data is taking so long.)

Add a comment Leave a comment on this blog post.
May 22, 2009 4:37 AM Guest anand  says:

there's still a healthy dose of technical information in the report, but it manages to walk that fine line between being useful and remaining accessible to business readers.??

May 22, 2009 10:02 AM Loraine Lawson Loraine Lawson    says in response to anand:

Touche!

 

Well, you know - everybody makes mistakes. I'll see if I can get that reworded.

Software Forum: Information On Demand Virtual Experience

This interactive virtual forum presents leading IT experts providing the insights you need to turn your information into a strategic driver for innovation, business optimization and competitive differentiation.

Performance Under Pressure: The State of Enterprise Web Application Quality and Availability

This research study finds that Web application issues are an all-too-common problem and examines these Web-based enterprise application issues from two perspectives: that of an online customer and that of a site manager.

Six Sigma Framework for IT

This collection of tutorials, calculators, and templates will show you how to apply six sigma thinking to IT service management.

Learn more >

Disaster Recovery & Business Continuity Template Pack

Prepare your company for any type of disaster you can envision and those you cannot. Immediately download this comprehensive set of templates and tools for documenting your business contingency plans.

Learn more >