6. Copying Objects To The BI Beans Catalog
Exercise Objectives
In this exercise, you will learn how to copy the presentations that you have
created to a persistent BI Beans Catalog. Saving presentation in the Catalog
lets other users access your reports from their applications. Ensure that you
have installed the BI Beans Catalog as described in Installing
the BI Beans Catalog.
Exercise Description
For better security management and application deployment, copy your presentations
to the BI Beans Catalog in a persistent database. Objects that are stored in
the BI Beans Catalog can be shared with other users and are managed professionally
within the database. Also, your deployed application can reference objects in
the Catalog without additional configuration. Therefore, you should copy your
objects to the Catalog before deployment.
This exercise introduces you to the basic steps for copying objects to the
Catalog using Oracle JDeveloper wizards.
Exercise Tasks
Copying objects
To copy objects to the BI Beans Catalog
- In the System-Navigator pane, right-click Project1BIDesigner1
under Project1.jpr, and choose Copy Objects to Remote Catalog.
- In the Copy Objects to Remote Catalog Wizard, read the introduction on the
Welcome page and choose Next to continue.
- You can either specify an existing connection or add a new connection. If
you have an existing Catalog connection defined, select that connection and
skip to Step 5.
- To add a new connection, use the following procedure:
- Choose New.
- In the Connection Wizard, read the introduction on the Welcome page and
choose Next to continue.
- Accept the default connection name (for example, CatalogConnection1) and
connection type Oracle(JDBC). Choose Next.
- Enter Username and Password, and choose Next. Enter the
BI Beans Catalog schema owner's credentials for the username and password.
Use BIBCAT as the username and password for the Catalog that
you installed in Getting Started.
Note: The username and password must be in uppercase.
- Enter thin for Driver type, enter host name, JDBC port,
and SID for the database connection. Choose Next.
- Choose Test connection.
- Choose Finish if the connection is successful to close
the Connection Wizard.
- Enter BIBCAT as the Catalog User and choose Test.
This is the default user created with the Catalog.
- Choose Next in the Copy Objects to Remote Catalog wizard
if the connection is successful.
- Select the following three objects: Quota Variance, Sales
Analysis Crosstab, and Sales Analysis Graph.
- Ensure that the Overwrite existing objects ...
box at the bottom of the objects tree is checked. The wizard will then overwrite
any existing objects on the Catalog.
- Ensure that the Update the runtime ... box is
checked. The wizard will then update the runtime settings so that applications
will reference objects from the Catalog.
- Choose Finish to copy the objects.
- After the copying process has successfully completed, review the summary
messages to ensure that there are no errors, and choose Close.
- To verify that the objects have copied successfully, in the System-Navigator,
under Project1.jpr, right-click Project1BIDesigner1 and choose
Browse Remote Catalog.
- Select the Catalog that you specified when you copied objects to the remote
Catalog (for example, CatalogConnection1), accept the default user, and choose
OK. This runs the BI Explorer utility.
- BI Explorer provides BI Catalog functionality that is similar to the functionality
that Windows Explorer provides for your local file system. Click F5
to refresh the contents and you should see the copied objects in the BI Catalog.
- From the File menu, choose Exit to exit the Explorer.
- In JDeveloper, from the File menu, choose Save All to save
your work.
Exercise Summary
In this exercise, you learned how simple it is to copy objects to the BI
Beans Catalog. By storing objects in a persistent database, you facilitate object
management and deployment.
5. Formatting Presentations
| Overview