Cataloging a SQL Query

The following procedures show you how to catalog a table using a SQL Query.

Before performing these procedures, ensure that you have create a Module within the Catalog.

  1. In the Project Navigator, right-click on the Module where you want to Catalog a SQL query.
  2. Select Catalog Component > Table
  3. Select an existing External Resource configuration.

    SeeCreating an External Resource for information on creating a new External Resource.

  4. Click Next.
  5. Enter the SQL command to return data from your table.
  6. Click Next.

    The SQL query is executed. This may take several minutes depending on the size of your query. The results of your query are displayed in a table.

  7. Click Next.

    The component is cataloged.

  8. Click Finish.
The SQL table appears as a resource with the Catalog.
Parent topic: Table (SQL Query)