Using the Catalog API

After creating a Designer object and getting a Catalog API instance, you can then use the Catalog API to perform tasks as required. For example, you can use it to set up a connection in a catalog, insert an object into the catalog, and modify the query of the catalog.

The following sections describe how to program with the Catalog API:

• Creating a connection
• Inserting an object
• Inserting a table/view
• Inserting a stored procedure
• Importing an SQL file
• Inserting a UDS
• Inserting a query
• Inserting a business cube, report cube or business view
• Inserting a formula, summary, parameter or a WHERE portion
• Deleting an object
• Modifying a query
• Getting objects in a catalog
• Refreshing the reference table of a catalog
• Saving a catalog