Create a SQL View

You can provision a SQL view from a table in a database or generate a SQL view from a data service, database operation, or virtual database operation.

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. You can use SQL to query a SQL view.

You can create SQL views in three ways:

• Provisioned directly from a table in an underlying database. You can do this in the web UI, the command line interface, or WorkSpace Data Federation.
• Generated from a database operation or data service. You can do this in the web UI, the command line interface, 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.

• SQL Views
  A SQL view is a virtual table; it represents a table in a relational database or the results of a database operation or a data service.
• Provisioning a SQL View from a Database Table
  Create a SQL view that brings a table in an external relational database into Sybase Data Federation’s virtual database.
• Generating a SQL View from a Data Service or Database Operation
  Create a SQL view that brings the results of a data service or database operation into Sybase Data Federation’s virtual database.

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.