Storage of Experts: Public and Private

In a workspace, Experts can be created in a public Experts folder or in the private Experts folder that is included in each project. Private Experts are typically used only in the context of its parent project. As with other public objects, public Experts are stored in the globals area and can be used across all projects in the workspace. Public Experts typically encapsulate functionality that is useful across different types of projects.

Depending upon how they are implemented, Experts can be invoked in several different contexts:

• Some Experts are designed to be right-clicked and executed from the Experts or Public Experts folder.

• Experts can be added to the right-click menus associated with most objects in Warehouse Builder, as well as being added as new menu commands in Design Center. In such a case, the Expert executes in a context where the object from which it was invoked is passed as a parameter.

• OWB can also be launched from the command line in a mode that hides Design Center from the user and runs a single Expert, then exits. These two capabilities allow the creation of simplified, constrained interfaces to OWB functionality for users who are not frequent OWB users or ETL developers.