Hi, I am currently evaluating various products in the market to build the data services layer in the SOA model. This layer will serve as an abstraction to the diverse (relational, xml, etc) physical data sources we have and provide a cohesive logical schema (xml schema definitions) exposed through services which is mapped/aggregated/transformed from the physical sources. I have tried the BEA Aqualogic data services and trying to achieve the same by combining WSO2 WSAS and WSO2 ESB. Here is my requirement - I have two different relational sources db1, db2 and a simple http rest style service. I need to aggregate information from all these sources and transform it to comply with a logical schema definition that is defined. This is what I am planning to do-
1. Use WSO2 WSAS data service to expose the data in the relational sources as xml using appropriate sql queries. 2. In WSO2 ESB, expose a proxy service that complies with the logical schema definition I have. 3. Define mediators in the ESB to combine the data from these services using XQuery/XSLT. Would this approach work? Are there better ways to do this? Thanks, Siva
_______________________________________________ Esb-java-user mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/esb-java-user
