Previewing Data

You can preview data in a table using the Metadata Tree View pane. You can also enter
SQL queries to preview the required data in the database.

To preview data from databases, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a project.

    3. The Metadata Tree View pane appears on the right.

    Previewing Data Database
  3. In the Metadata Tree View pane, right-click a table and hover over Preview Data.
    4. Previewing Table Database
  4. Click any one of the following:
    Preview 100 Records
    Click this option to preview the first 100 records.
    Preview 1000 Records
    Click this option to preview the first 1000 records.
    Advanced Preview
    Click this option to preview data based on a SQL query.

    5. For example, if you click Preview 100 Records, then the User Credentials page appears.

    User Credentials Preview Data
  5. Enter User Name and Password to connect with the database.

    6. You can preview the data based on the options you selected.

    Data Previewed

    If you use Advanced Preview then you need to enter a SQL query in the space provided and click Icon Execute Query to preview the data.

    Advance Data Previewed