Previewing Data

The preview feature shows you the relational tables that are created as a result of the data mapping from the schema definition. Preview your data to see how a table or virtual table would appear in ODBC and JDBC applications.

Note:

When working with Couchbase data, make sure that the connector is configured to execute queries in SQL instead of N1QL. The Schema Editor uses a SQL query to determine which data to preview.

For information about configuring the connector to use SQL or N1QL, see the descriptions of "Query Mode" or "QueryMode" in the Installation and Configuration Guide for your Couchbase connector.

To preview data:

  1. In the Design View, in the left pane, select the table that you want to preview.
  2. In the main pane, click Preview.

The bottom area of the main pane displays up to 10 rows showing how the table appears in ODBC and JDBC applications. The configuration of the database and the connector determine which rows are selected to be included in the preview.