Data Federation and Integration
November 24, 2006 2:34 AM
Filed Under: WorkSpace Data Integration SOA
With every release of Sybase WorkSpace we find new products, from the Sybase group of products, integrated into the Workbench ISE (Integrated Service Environment).
So what is Data Federation? Simply put, it is the combining of data from various data sources into one single virtual data source or Data Service. The data can then be accessed, managed and viewed as if it were part of a single system.
This Data Service can be a combination of files, HTTP Requests, Web Services, SQL queries (including Stored Procedures) and other Data Services etc. We need also to introduce two concepts, a Database Connector and a Database Operation. The Database Connector is a mechanism that enables one or more database operations to connect to a relational database and a Database Operation is a mechanism that can extract/modify data from/in a relational database and deliver it to a Data Service.
This Data Service can then be used like any other data source in WorkSpace, to create Database Services, that can be used in a Business Process Orchestration.
That’s true SOA and Integration Power , and all from within the same ISE… seamless.
Check out more within WorkSpace v1.6 and specifically the Avaki Perspective
Posted by Ian Thain on November 24, 2006 2:34 AM
