The simplest approach is to deploy directly from the Design Center by selecting an object and clicking the Deploy icon.
In this case, Oracle Warehouse Builder deploys the objects with the default deployment settings. Alternatively, if you want more control and feedback on how Oracle Warehouse Builder deploys objects, from the Design Center menu select Tools , then Control Center Manager.
Whether you deploy objects from the Design Center or the Control Center Manager, be sure to deploy all associated objects. For example, when deploying a mapping, also deploy the target data objects such as tables that you defined and any associated process flows or other mappings.
In this step, you move data for the first time. Repeat this step each time you want to refresh the target with new data. You have two options for executing the ETL logic in mappings and process flows.
It is essential to ensure the quality of data entering your data warehouse over time. Data auditors enable you to monitor the quality of incoming data by validating incoming data against a set of data rules and determining if the data confirms to the business rules defined for your data warehouse. Although the Control Center Manager displays histories for both deployment and execution, the Repository Browser is the preferred interface for monitoring and reporting on Oracle Warehouse Builder operations.
Oracle Database provides Oracle Warehouse Builder as part of the standard software when the database is installed. Oracle Warehouse Builder is an integral part of Oracle Database. The main Oracle Warehouse Builder components on the client or desktop side, which are discussed in Chapter 3, "User Interface Tour" , are:.
Figure illustrates the components that comprise Oracle Warehouse Builder and where they reside and run on clients and servers. A major feature of the architecture in Oracle Warehouse Builder is the single, unified Oracle Warehouse Builder Repository for the database instance, which is pre-seeded with a schema and database objects.
The run time environment and the design environment reside in this single repository. Administrators and developers generally register other database users and assign them required privileges, rather than using Oracle Warehouse BuilderSYS account directly. You can create multiple repositories if you prefer to separate the run time and design environments; however, this is not recommended. To start using Oracle Warehouse Builder, you create at least one, new workspace.
Users access their respective workspaces, instead of the repository as a whole. Thus, if you are Oracle Warehouse Builder administrator, instead of granting users access to a repository, you grant them access to one or more workspaces. Because all workspaces are stored in a single repository schema, creating workspaces is simplified.
In defining the repository, an administrator creates one or more workspaces, with each workspace corresponding to a set of users working on related projects. For example, a common practice is to create separate workspaces for Development, Testing, and Production. This practice provides team focus in addition to security. Users such as developers can have access to the Development and Testing workspaces, and can be restricted from the Production workspace.
Later in the implementation cycle, you can use the Repository Assistant in Oracle Warehouse Builder to manage existing workspaces or to create new ones. Each workspace has a default Control Center that points to itself, and it is started and stopped with its corresponding Control Center Service. A Control Center stores detailed information about every deployment and execution, which you can access either by object or by job.
You can use the default Control Center to deploy to the local system, or you can create additional Control Centers for deploying to different systems as needed.
Only one Control Center is active at any given time, and this is the Control Center associated with the current active configuration. For some heterogeneous data access scenarios, you must install a standalone Java Run time on hosts where there is no Oracle database installed.
You start the Control Center Agent with ccastart from the command line. The data in your Oracle Warehouse Builder project is stored in a target schema within the server. This data is in the form of data objects such as tables, views, and dimension and cube objects.
In a traditional data warehousing implementation, there is typically only one target schema, which is the data warehouse target. You can design both relational and dimensional target schemas.
To design a target schema, you first create the target module that contains all the data objects. A target module is a container that holds the metadata definitions of all your data warehouse objects.
Each target module corresponds to a target location that represents the physical location where the objects are stored. In addition to context-sensitive help available with the F1 key, Oracle Warehouse Builder provides a Help Menu with links to utilities, training, the discussion forum, Oracle Technology Network and more. Provides a shortcut to the search facility for the online Help Center.
Table of Contents. Opens the "Help Center" with the Table of Contents selected. Help Favorites. Opens the Help Center with your favorites selected, if you have configured favorite Help topics. The purpose of the Oracle Warehouse Builder Utility Exchange is to provide the user community with a forum where utilities, code samples, and tips and tricks can be exchanged.
The utilities posted here are not part of any Oracle production release and are, therefore, free-of-charge and not supported. Provides a shortcut to Oracle University where you can find out about training for Oracle Warehouse Builder. Oracle Technology Network. Check for Updates. Checks for Oracle Warehouse Builder product updates.
When grayed out, no updates are available. Session Properties. Displays information about the current workspace session such as workspace owner and name; connection properties like host name, service name and database version; and roles granted to the workspace owner.
Displays version information about the current software release. The system displays the following message: "Thank you for accepting the OTN License Agreement; you may now download this software. Under the Standalone Software download, click the down arrow beside the platform of your choice to download the zip file that contains Oracle Warehouse Builder. On Windows: choose the Microsoft Windows option.
After you obtain the standalone installation files for Oracle Warehouse Builder and extract them, you must install the software. In Windows Explorer, navigate to the directory that contains the extracted Oracle Warehouse Builder installation files. At the End of Installation screen, click Exit. The Exit message appears asking if you really want to exit.
The overall process for installing on an Oracle RAC environment is similar to the general process for installing a single-instance database. However, there are a few specific details to observe as noted in this section. Cross references to generic installation guides are given after the last step of this procedure.
If you have not done so, review the most recent Oracle Warehouse Builder Release Notes available with the installation media. Note ID Oracle Database Release For each computer to host Oracle Warehouse Builder components, configure the tnsnames.
Configure tnsnames. If you fail to configure tnsnames. If necessary, install Oracle Warehouse Builder standalone software. However, this is generally not necessary because Oracle Warehouse Builder is installed as part of every Oracle Database 11 g Release 2 installation. Create your first workspace within Oracle Warehouse Builder Repository. The Repository Assistant prompts you and guides you with procedures.
There are no additional installation tasks. To properly configure Oracle Warehouse Builder and its repository on a host that runs an earlier version of the database, such as Oracle Database 10 g Release 2, you must:. Ensure that the database is fully installed and working; if it is not, see Oracle Database Installation Guide for Microsoft Windows. Note the host name, the port, and Oracle service name of this database. The example here uses the following connection information: localhostorcl.
Oracle Warehouse Builder has command-level scripts to perform this task:. Starting with Oracle Warehouse Builder The information provided is organized in a format suitable for business-oriented users. The reports generated are based on the data present in the design repository.
In this article, we have discussed the Oracle warehouse builder in detail. This is a powerful tool of the first generation that helped many organizations to create warehouses and reports to supplement their ERP applications.
This is a guide to Oracle Warehouse Builder. Here we discuss the components, working, advantages, and uses of Oracle Warehouse Builder. You can also go through our other suggested articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.
0コメント