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.
-
In the Project Navigator, right-click on the Module where you want to Catalog a SQL query.
-
Select
-
Select one of the following options:
| Option |
Description |
|---|
| Use existing configuration |
Select this option if you have already configured an External Resource
of type SQL Database. |
| Create a new configuration |
Select this option if you need to configure a new External Resource of
type SQL Database. See Creating an External Resource. |
-
Click Next.
-
Enter a name for the new component that represents your query.
-
Enter the SQL "SELECT" statement to query your database.
Select the Parametric option if your query defines
placeholders to be parametrized at runtime. See Parametric Queries for details.
- If the Parametric options is not selected, you may
click Preview to test your query before continuing.
-
Click Next.
The SQL query is executed. This may take a few minutes.
If the query defines parameters, you may now fill in sample values for each
parameter and click Preview to test your query before
continuing, then click Next
The list of columns returned by the query are displayed in a table.
-
Click Next.
The component is cataloged.
-
Click Finish.
The SQL query component appears in the Project Navigator .