Restricted access

November 2, 2010

When To Use Integration Appliances For Data Integration?

Filed under: Data Integration, Data Quality — Katherine Vasilega @ 3:15 am

An integration appliance is a computer system specifically designed to lower the cost of integrating computer systems. It enables to integrate all types of applications and data directly from Web and on–premises resources, without installing any additional software. Very few vendors offer these solutions at the moment.

The concept of integration appliances is compelling and cost-effective. They offer a simplified environment and often include connectors and adapters that are ready for installation. Appliances are certainly appealing, but are they really sufficient for your data integration needs? Do they provide data quality?

If you need a simple method of data integration, these solutions will probably fit. But what if you need to integrate more complex data? With any enterprise data warehouse, there is a strong need to analyze and interpret data. Integrating the data and presenting it to the business users in a suitable manner is crucial, if you want to get the real value of data integration. With integration appliances, as soon as you start to add business rules, the process slows down. The bottleneck tends to happen around the integration layer component where data integration, separation, and transformation are handled.

Integration appliances are supposed to eliminate excessive complexity for users, but data integration experts agree that these solutions are not always a good fit for an organization. Until integration appliance vendors can offer solutions that integrate information with very complex transformations and business rules, the appliances will continue to fit the simple data integration needs and will not suit enterprise-level data management requirements.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment