Feeds

Another way of tackling integration

The purpose of repurposing

Top three mobile application threats

Of course, there are a variety of different types of integration and there are a range of different things that you can do with data integration. I am not here to suggest that there is another way of tackling data integration in general. However, there are specific aspects of data integration (and in this context I am talking specifically about the data movement aspects of integration) where there may be an alternative that is worth considering.

In particular, think about a call centre application or similar CRM (customer relationship management) requirements, or even analogous supply chain functions. In most circumstances a customer calls up (or you call him or her) and what you need to know is how much they have spent over a period of time and what products they have bought. Based on that information you want to try to up-sell or cross-sell this customer.

So far, so easy. There are traditionally two ways to do this, especially bearing in mind that you may have multiple applications within which this customer data is stored. The first is that you put all the information into a data warehouse (or some other suitable storage) and extract the relevant information as and when needed. Alternatively, you can use federated queries that access the live database systems and bring all the relevant data together in real-time. Typically, preference is for the former because of the performance implications of using a federated approach. However, there is a third alternative.

The alternative is based on the fact that all the information that you need in the call centre application is contained within the customer's statements. If you could read the customer's statements from the archive in which they have been stored, and retrieve the information you need and combine it in appropriate ways, then you would fulfil the needs of the call centre.

Having described this potential approach, which is technically known as repurposing, it will come as no surprise that it is actually available from a number of vendors, though Xenos is perhaps the most well-known, and it certainly offers the best performance.

Basically, it can read any print format from either a document or report and convert it into more or less whatever you want, including XML, or you can present the data within a portal (either Xenos' own or a third party's). Of course, the software has the ability to access multiple content repositories and collate information across these. Moreover, it can index content such as statements to enable rapid retrieval.

There are two further points that we need to make. The first is that repurposing is not going to be suitable for all sorts, even of call centre, applications. For example, suppose you want to include such things as customer lifetime value within your up-sell or cross-sell calculations: you could not do this simply by repurposing statement data.

On the other hand, you can do quite complex calculations, such as "which customers have spent over $1,000 a month for the last three months on their credit card and have bought from PCWorld?".

In other words, if the data can be derived from the statement (or other printed form) then you can do it using repurposing. So, if you wanted to include customer lifetime value data you would need to create a report that (potentially) printed this out and then the repurposing software could use that information: except that that report might need to derive from the data warehouse, thereby defeating the object.

The final point is that this technology is great for delivering self-service capability. This is not an area where you would expect to see data integration vendors playing (perhaps they should?) and so Xenos and its competitors have a more or less open goal here, as the alternative is conventional development. Repurposing is hardly a technology on every IT manager's lips: maybe it should be.

Copyright © 2006, IT-Analysis.com

Maximizing your infrastructure through virtualization

More from The Register

next story
Apple fanbois SCREAM as update BRICKS their Macbook Airs
Ragegasm spills over as firmware upgrade kills machines
HIDDEN packet sniffer spy tech in MILLIONS of iPhones, iPads – expert
Don't panic though – Apple's backdoor is not wide open to all, guru tells us
Mozilla fixes CRITICAL security holes in Firefox, urges v31 upgrade
Misc memory hazards 'could be exploited' - and guess what, one's a Javascript vuln
NO MORE ALL CAPS and other pleasures of Visual Studio 14
Unpicking a packed preview that breaks down ASP.NET
Captain Kirk sets phaser to SLAUGHTER after trying new Facebook app
William Shatner less-than-impressed by Zuck's celebrity-only app
Cheer up, Nokia fans. It can start making mobes again in 18 months
The real winner of the Nokia sale is *drumroll* ... Nokia
EU dons gloves, pokes Google's deals with Android mobe makers
El Reg cops a squint at investigatory letters
Chrome browser has been DRAINING PC batteries for YEARS
Google is only now fixing ancient, energy-sapping bug
prev story

Whitepapers

Top three mobile application threats
Prevent sensitive data leakage over insecure channels or stolen mobile devices.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Application security programs and practises
Follow a few strategies and your organization can gain the full benefits of open source and the cloud without compromising the security of your applications.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.