starting with oracle warehouse builder 10g release 2

5/16/2018 Starting With Oracle Warehouse Builder 10g Release 2 - slidepdf.com

http://slidepdf.com/reader/full/starting-with-oracle-warehouse-builder-10g-release-2

Starting with Oracle Warehouse Builder 10 Release 2

Purpose

I , O W B 10g R 2 (OWB 1Y W B .

Time to Complete

A 15

Topics

T :

O

P

R M

Setting up the Project Environment

Introducing the OWB Program Group Components

Logging in to the Design Center

S

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: Because this action loadsscreenshots simultaneously, response time may be slow depending on your Internet connection.)

Note: A, .

Overview

I , W B . Y OWB R A O W B .

B

Prerequisites

I , :

1. C O D10g (E E). I orcl . O, O S N orcl .

Note:T - OWB 10g R 2 O D 10g R 2. Y - O D 10g R 1 2.

T , W B .F , W B .

2. C O W B 10g R 2

Note:W B :

ETL Core features: T ETL S E, S



E O E E. T ETL C ETL . T 10g R 1 W B "E" .

Enterprise ETL Option: T E ETL O E/T/L (ETL) . S 2 3 , , I A - .

Data Quality Option: T D Q O .

Connectors: C ( ) / CRM ERP . T : SAP, O EB S

P 8/9

F , P L OWB FAQ OTN.

B

Reference Material

T :

O W B 10g R 2: D LO T N (OTN): OWB C L

O U (5 I L ): Oracle Warehouse Builder 10 : Implementation Part 1 (3 ) Oracle Warehouse Builder 10 : Implementation Part 2 (2 )

V O U , .

B

Setting Up the Project Environment

I , :

D S S

C D C U R

R S S

B

Download the Setup Scripts

1. D owbdemo_files.zip - here Save Target As - .D ' .

2. O owbdemo_files.zip , , ' d:\ , .

Note: I WZ, "Use folder names" .

I d:\ , :

D:\\_.D:\\.D:\\.D:\\_.D:\\_.D:\\_.D:\\_.



D:\\_.D:\\_.D:\\_.D:\\_.D:\\_.D:\\_.D:\\_.D:\\.D:\\.D:\\.D:\\.D:\\.

D:\\.D:\\\.D:\\\_.

M . _. "sourcefiles" "newowbdemo". M d:\ .

3. Y optionall xsales.zip here.

S . ' . E . ..

Note:T -. T

XSALES - .

B

Create the Design Center User and Repository

1. W OWB D C , W B . Y , , , W B .

S Start > Programs > {your Oracle - OWB10 R2clientHome > Warehouse Builder > Design Center .

T Design Center Logon .

I Get Started , Show Details. C Get Started. T Welcome R A W . C Next.

2. I Install Type , Basic Install. C Next.

3. I Repository User and Connection Information , rep_user , :

R U N rep_user

R U P rep_user

SYSDBA U N ss

SYSDBA P <our SYSDBA password>

H N localhost <or our machine name>



P N 1521

O S N orcl <or our database service name>

C Next.

4. I P C , - rep_user , OK.

5. I Repository Owner Information , , W B ( OWB_10_1_2_3_31) W B ).

I, . T WB . E rep_owner . C Next.

Note: I , Cancel R A rep_owner R A :

1. S Start > Programs > {your Oracle - OWBclientHome> Warehouse Builder > Administration >Repository Assistant. C Next W P.

2. C Advanced Setup , rep_owner .T 1 5.

T following _.

I Password Confirmation , - rep_owner OK.

6. I Summary , Finish.

7. A Installation Progress . T .

8. A Installation Successful . C OK. T R A .

I Design Center Logon , Cancel . I Warehouse Builder Warning

, Yes W B. Y .

B

Run the Setup Scripts

1. B , owbdemo_files.zip .

L SQL*P sys _. D:\.

T , SQL> :

@d:\newowbdemo\create_users.sql;



E SQL*P.

Note:T _ . : __. I , . . .

T , DOS :

<ORACLE_HOME>\_1\\ /@< > =<PATH>\.=

S <ORACLE_HOME> O <PATH> . .

N . optional .

2. N OWB . F, owbdemoinit.tcl . T owbdemoinit.tcl ; ' :

e bcie rep_ownere bcied rep_ownere e sse d sse h localhoste 1521e eice orcle jec OWB_DEMOe cedi d:/newowbdemoe daaace USERSe ideace USERSe eace TEMPe aace USERSe ah d:/oracle/10.2.0/db_1/BINe id orcl

Y , W B .

Note:T . I

-. I .

3. T , OMB P . T OMB P. W DC, OMB Plus Window . O Start > Programs > [Oracle - OWB10 R2clientHome]> Warehouse Builder > OMB Plus.

O OMB+> , cd : ( ):

cd d:\\newowbdemo\\

T cd . A , OMB+> . T

. .



source loadall.tcl

E OMB P .

T OWB , OWB_DEMO, .

B

Introduction to the OWB Program Group Components

Y OWB .

1. S Start > Programs > [Oracle - OWB10 R2clientHome] > Warehouse Builder > Administration. T OWB .

2. E :

A Repository AssistantF OWB

Start/Stop Control Center ServiceF OWB CC

Start/Stop OWB Browser Listener F R B L

Design Center T OWB , , ETL

DocumentationT O W B O TN

OMB Plus T

Repository Browser T .

B

Logging In to the Design Center

T OWB D C, :

1. S Start > Programs > [Oracle - OWBclientHome] > Warehouse Builder > Design Center .

T Design Center Logon . E rep_owner . B , Connectiondetails .

I C , Show Details.

E localhost < >, 1521, orcl < >. C OK.

2. T D C . T D C : P E, C E, G E.



T P E : MY_PROJECT, OWB , OWB_DEMO, .

3. A . A , W B .

W B , , , .

I P E ' , OWB_DEMO . V : D , F, A, D P, .

E Databases , :O , -O , .

E Oracle , modules : SALES_WH XSALES.M .

4. E SALES_WH . T : , ,

, , , . E .

B

Summary

I , :

D W B

C OWB D C U R

L OWB D C OWB

B

Place he co oe hi icon o hide all ceenho.

starting with oracle warehouse builder 10g release 2

Documents