Uniform Access to Any Data
Data within an enterprise can be stored in various formats, including relational databases (which themselves come in a large number of varieties), text files, XML files, Web services, spreadsheets and a variety of proprietary storage methods, each with their own indexing and data access methods. In most enterprises data from multiple sources must be combined in order to obtain a complete data set. Ecrion Data Aggregation Server uses visual diagrams in Ecrion Data Architect to gather data from multiple sources on-demand and convert it into XML.
With Ecrion Data Aggregation Server, all data within your organization will appear to users as a single homogenous data source.
Data Integration
Data integration involves combining data residing in different sources and providing users with a unified view of these data.
In the traditional approach, multiple data repositories are merged into one; an ETL process Extracts information from the source databases, Transforms it and then Loads it into the data warehouse.
Because the merged copy doesn't update when the original data source does, the trend in data integration has favoured loosening the coupling between data and use a uniform query interface over a mediated schema.
Getting Started
While other data integration tools require a complicated API and months of training, Data Aggregation Server was built with the maximum simplicity in mind. All you have to do is to create a diagram using Ecrion Data Architect. The diagram is executed at runtime by DAS to generate XML from multiple sources.