Data integration tasks range from the use of SQL SELECT statements against SQL views to complex integrations using data services, virtual database operations, and view generators.
Sybase Data Federation appears to external applications and users as a virtual database when accessed via JDBC or ODBC. You can execute the simplest data integration tasks by using SQL SELECT syntax to run queries against SQL views that have been provisioned in the Data Federation virtual database.
You can use WorkSpace Data Federation to define view models, and then deploy those view models as data services. Like database operations, data services are accessible as stored procedures via ODBC and JDBC. They are also accessible via SOAP. In addition, you can generate SQL views from data services that return rowsets, thus exposing these logical abstractions as tables as well as stored procedures via SQL.
You can create virtual database operations. A virtual database operation is just like a regular database operation, except that its source database is Data Federation itself. Use virtual database operations to capture and reuse SQL SELECT queries against SQL views.
To cover more advanced situations where you need the full power of Java or you need to perform XML processing within Data Federation, you can create data services that are implemented in Java, JavaScript, or XSLT directly.
Finally, if you have data consumers or applications that require flat file output, you can route the output of database operations or data services to flat files using Data Federation view generators.
For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com