Before using SQL tables from processes or BPM Objects, you must include them into the
component catalog. When you catalog SQL table components, Studio gathers all the
information it needs for integrating with your SQL database and executing statements
at runtime.
Before performing this procedure, you should ensure that your database is
installed, running and accessible from your system through JDBC.
You should also ensure that you have created a module where you want to catalog the SQL
components. See Creating a Module.
To catalog a SQL Component:
-
Right-click on the module where you want to catalog the SQL component.
-
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.
Oracle BPM Studio creates a list of SQL objects that can be
cataloged. This may take several minutes.
-
Select the SQL components you want to catalog.
-
Click Next.
The components are analyzed for dependencies and cataloged.
-
Click Finish.
The components you chose to catalog appear in the Project Navigator.