SQL Views

A SQL view is a virtual table—a data catalog entry that represents a table in a relational database or the results of a database operation or a data service.

Every SQL view in a Sybase Data Federation domain is part of the domain’s virtual database. SQL views are treated like relational tables by Data Federation query engines, and you can execute SQL queries against them. SQL view data can be accessed using standard SQL statements in a virtual database operation or by connecting to Data Federation with ODBC or JDBC.

You can create SQL views in three ways:

Provisioned from a table in an underlying database, using a database connector. You can do this in the Web UI, the CLI, or WorkSpace Data Federation.
Generated from a database operation or data service. You can do this in the Web UI, the CLI, or WorkSpace Data Federation.
Mapped from a database table, a database operation, or a data service, using the metadata model editor. You can do this in WorkSpace Data Federation.

For information on provisioning or generating SQL views using the Web UI, see the Data Federation Provisioning and Advanced Data Integration Guide, part of the DI Suite documentation set, which is available on the Sybase Product Manuals Web site at http://sybooks.sybase.com.

For information on provisioning or generating SQL views using the CLI, see the Data Federation Command Reference, part of the DI Suite documentation set, which is available on the Sybase Product Manuals Web site at http://sybooks.sybase.com.