Tools for Data Integration

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.

However, in many cases, access to Data Federation is not entirely ad hoc against “raw” provisioned SQL views. For example, you might want to expose a logical model that creates a combination of procedures and virtual tables that encapsulate operations against raw provisioned SQL views and database operations. The primary mechanisms for building up this logical layer of abstraction in Data Federation are:

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