Product Info

Select a product to view
details, access demos to meet product managers.

Approaches to Data Integration

The act of drawing data from different sources together to provide a unified view is known as data integration. Data integration can be implemented in a variety of ways, including: data warehousing, federated queries, and repurposing printed statements.

Data Warehousing

Data warehousing involves use of extract, transform, and load (ETL) solutions to extract information from a variety of data sources, transform that data into a common format, and finally load the resulting data into a single data store, or warehouse. This approach may be preferable due to the performance implications of querying a single data store (as opposed to querying multiple data stores).

Federated Queries

A second approach to data integration involves creating the infrastructure for queries to be run across multiple data stores, assuming adapters to those stores exist. At run-time when a query is executed, the appropriate data stores are queried and the information is combined and presented. Architecturally, this results in a much looser coupling.

Repurposing Printed Statements

Lastly, your business may have already performed data integration to create printed statements. These statements typically contain information from a number of stores and may already provide you with all of the data you need. Repurpose this data.

Data Integration Solutions from Xenos

Xenos provides a number of data integration solutions depending on the approach you wish (or need) to take.

Xenos terminalONE™ provides a means of collecting data across a number of different channels, intelligently routing and transforming that data. As a key component of ETL or federated queries, terminalONE’s transformation capabilities can be provided as an enterprise-wide service for numerous applications on your network, or performed in real-time where it is needed.

Archive consolidation can be considered a form of data warehousing, in which the input data stores are retired after data migration is complete. Based on our extensive experience architecting, managing and implementing successful electronic content management projects, Xenos has formed an Information Architecture Practice , which has implemented many successful archive consolidation projects.

Xenos d2e™ provides you with a solution to data integration you may not have considered: repurposing data on the printed page. “[This] technology is great for delivering self-service capability,” says Philip Howard, Director at Bloor Research. “This is not an area where you would expect to see data integration vendors playing … and so Xenos … [has] a more or less open goal here, as the alternative is conventional development.” (Read more.)