OWB试验手册1.docx

1、OWB试验手册1OWB实战一、 安装准备1. 安装OWB确保已完成了Oracle 10gR2的安装实例名：orcl用户：sys/password 安装时带实例schemas：OE SH HR2. 安装owb10gr23. 安装workflow 2.6.4在Oracle Database 10g Companion CD中4. 配置Workflow Account: (Accept the default) owf_mgrWorkflow Password: owf_mgrSYS Password: TNS Connect Descriptor: localhost:1521:orcl二、 OW

2、B使用的准备1. 下载owbdemo_files.zip，并解压如：D:newowbdemoxxxxxx2. 创建用户和RepositoryStart Programs your Oracle - OWB10gR2clientHome Warehouse Builder Design Center Click Get Started. The Welcome screen of the Repository Assistant Wizard appears. Click Next.In the Install Type window, choose Basic Install. Click N

3、ext.In the Repository User and Connection Information window, create a user named rep_user, by entering the following values:Repository User Namerep_userRepository User Password rep_userSYSDBA User Name sysSYSDBA Password Host Name localhost Port Number 1521Oracle Service Name orcl Click Next. In th

4、e Password Confirmation window, re-enter the password rep_user, and click OK.In the Repository Owner Information window,. Enter rep_owner as username and password. Click Next. Note: If you have already created another repository owner before this course, click Cancel to exit the Repository Assistant

5、 and create rep_owner now by invoking the Repository Assistant as follows: 1. Select Start Programs your Oracle - OWBclientHome Warehouse Builder Administration Repository Assistant. Click Next on the Welcome Page. 2. Choose Advanced Setup and follow the prompts to create a new repository owner, nam

6、ing it rep_owner. Then rerun steps 1 through 5. The scripts in the following section assume the existence of rep_owner.In the Password Confirmation window, re-enter the password rep_owner and click OK.In the Summary window, examine the information and click Finish. An Installation Progress window ap

7、pears. The installation of the repository owner will take several minutes. An Installation Successful window appears. Click OK. The Repository Assistant closes. If the Design Center Logon window is still open, click Cancel to close it. In the Warehouse Builder Warning window, click Yes to quit Wareh

8、ouse Builder. You will be logging in later in this lesson. 3. 执行相关脚本以sys用户登录sqlplus SQL输入:d:newowbdemocreate_users.sql;Exit SQL*Plus.Note: The create_users.sql script will create two users: xsales and eul_from_owb. If you plan to work with xsales source data, you need to import the xsales.dmp file t

9、hat you downloaded and extracted from the xsales.zip file.导入文件：db_1binimp xsales/xsales file=xsales.dmp full=y如：Imp xsales/xsalesorcl file=d:xsale.dmp full=y4、运行一个tcl脚本，创建一个已定好的OWB Project首先编辑owbdemoinit.tcl脚本，符合自己的环境，如下： set owbclient rep_ownerset owbclientpwd rep_ownerset sysuser sysset syspwd sys

10、set host localhostset port 1521set service orclset project OWB_DEMOset sourcedir d:/newowbdemoset dataspace USERSset indexspace USERSset tempspace TEMPset snapspace USERSset sqlpath d:/oracle/10.2.0/db_1/BINset sid orcl5、运行脚本，需要启动OMB Plus环境，有两种方法在Design Center, select OMB Plus from the Window menu.

11、或Start Programs Oracle - OWB10gR2clientHome Warehouse Builder OMB Plus. On the OMB+ prompt, enter the cd command as shown below: (it is case sensitive):cd d:newowbdemoThe source command executes the loadall.tcl script that in turn runs all the other tcl scripts in desired sequence.source loadall.tcl

12、Exit the OMB Plus environment. The scripts have created a partially defined OWB project, OWB_DEMO, in which you will do your work.三、介绍OWB组件You will now examine the components that constitute the OWB installation.1.Select Start Programs Oracle - OWB10gR2clientHome Warehouse Builder Administration. Th

13、is displays the range of components that make up the OWB product.2.Examine the menu choices:AdministrationRepository Assistant Facility for creating and managing OWB repositories and usersStart/Stop Control Center Service Facilities for starting and stopping the OWB Control Center Start/Stop OWB Bro

14、wser ListenerFacilities for starting and stopping the Repository Browser Listener for standalone local browser Design Center The main OWB client in which you design sources, targets, ETL mapping and transformations DocumentationThis will redirect you to Oracle Warehouse Builder documentation on Orac

15、le Technology NetworkOMB Plus The scripting tool you use to execute tcl scripts Repository Browser The reporting environment for examining repository design and control center metadata. 五、Logging In to the Design Center To start the OWB Design Center, perform the following steps:1.Select Start Progr

16、ams Oracle - OWBclientHome Warehouse Builder Design Center. The Design Center Logon window appears. Enter rep_owner as username and password. By default, Connection details option is selected.If you cannot see Connection details option, click Show Details. Enter host as localhost or , port as 1521,

17、and service name as orcl or . Click OK. 2.The Design Center appears. The Design Center is divided into three panels: Project Explorer, Connection Explorer, and Global Explorer.The Project Explorer on the left side contains two projects: MY_PROJECT, an empty project created when OWB is installed, and

18、 OWB_DEMO, a partially defined project that you created with the setup scripts. 3.A project is a container to manage your design work. After you create a project, you can create all the other Warehouse Builder objects. Warehouse Builder contains wizards, object editors, property sheets, and object f

19、inding tools that assist you in designing your business intelligence system. In the Project Explorer panels navigation tree, expand the OWB_DEMO project. Various object types appear in the tree: Databases, Files, Applications, Data Profiles, and so on. Expand the Databases node, and you see various

20、object types that can be included in design of your warehouse: Oracle databases, non-Oracle databases, and transportable modules.Expand the Oracle node, and you see two modules predefined by the setup scripts: SALES_WH and XSALES. Modules are logical groupings of source or target definitions. 4.Expand the SALES_WH module. The various object types appear in the tree: mappings, transformations, dimensions, cubes, tables, and so on. Expand some of these nodes to see the objects that have been predefined by the setup scripts.