Database Tools

You will use Sybase Data Federation tools to work with data stored in relational databases. These tools allow you to provision data into the data catalog and set access controls; and to integrate, combine, and transform data into the formats required by your users and applications.

The primary tasks associated with setting up federated data access are:

• Provisioning

  When you provision data you put it into the data catalog (from files, databases, and HTTP sources such as web services and CGI scripts) and set appropriate access controls.

• Integration

  Integration consists of processing, combining, and transforming data into the formats required by users, applications, and databases. This might involve data provisioned from multiple data sources as well as data derived from other data integration steps.

After the source data and the various integration services have been provisioned and defined in the data catalog, end users and applications can access or invoke these data sources and services using several means: transparent file system access via NFS or CIFS, web services (SOAP, the Simple Object Access Protocol), Open Database Connectivity (ODBC), or Java Database Connectivity (JDBC). You can also access data sources through WorkSpace Data Federation and use them to create data services. When considering the various means for provisioning data and implementing integration operations, you will want to consider which end users or applications will need to access it. One of the strengths of Data Federation is that you can make the same data accessible via a number of interfaces or protocols, serving multiple constituents without having to perform any extra work.

• Tools for Provisioning Database-Resident Information
  Sybase Data Federation database connectors, database operations, and SQL views make database data accessible to users and applications.
• Tools for Data Integration
  The simplest data integration tasks can be accomplished by using SQL SELECT syntax to run queries against SQL views; however, you can also perform complex integration tasks using data services, virtual database operations, and view generators.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.