Additional Administration Tasks

This chapter provides information administration topics related to Oracle BI Applications ETL processes.
This chapter contains the following topics:

1.    Creating ETL Tables for Siebel Sources

2.    Generating DDL Warehouse Scripts

3.    Logging and Diagnostics

1.    Creating ETL Tables for Siebel Sources

If your source system is Siebel and you are deploying one of the following offerings, you need to create S_ETL tables in the Siebel database:

·        Oracle Marketing Analytics

·        Oracle Price Analytics

·        Oracle Sales Analytics

·        Oracle Service Analytics

To create the S_ETL tables, you generate a DDL script, which then must be provided to the Siebel DBA, who will need to create the necessary tables in the Siebel database.
Note that the DB user used for the ETL connection will require all DML privileges (SELECT, INSERT, DELETE, UPDATES) and DDL (TRUNCATE) privileges to S_ETL tables.
To generate a DDL script to create S_ETL tables for Siebel sources:

1)   Launch ODI Studio, and display the Designer navigator.

2)   In the Projects editor, expand the following folders: BIApps Project, Components, Sources, Siebel, Oracle, Generate Siebel DDL, Packages, Generate Siebel DDL, Scenarios.

3)   Right-click GENERATE_SIEBEL_DDL Version 001, and then click Execute.

4)   Select the Context, ODI Agent, and Log Level, and then click OK.

5)   Specify the following information:

Option	Description
CREATE_SCRIPT_FILE	Select Latest Value and Enter Y in the Value field.
REFRESH_MODE	Enter FULL.
CHAR_CLAUSE	Provided for Unicode support. If set to Y, the CHAR clause will be included in the DDL.
RUN_DDL	Enter N.
SCRIPT_LOCATION	Enter the path where you want the script to be created. The file name will be similar to BIA_Siebel_Schema_DDL_<run ID>.sql.
TABLE_MASK	The default value % will compare all tables.

6)    

2.    Generating DDL Warehouse Scripts

The Business Analytics Warehouse tables are automatically deployed during the installation process when the Business Analytics Applications Suite Repository Creation Utility (RCU) executes a shipped DDL script. The RCU does not prompt for which tablespace to assign to the individual tables and related indexes nor does it provide a mechanism for you to alter the shipped DDL. To introduce changes to the Business Analytics Warehouse data model, you use ODI to generate a new DDL script.
For instructions on generating DDL scripts and assigning tablespaces to tables and indexes, see the topic "Generating DDL and Assigning Tablespaces to Tables and Indexes," in Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence Applications.

3.    Logging and Diagnostics

Oracle BI Applications Configuration Manager uses Oracle Diagnostic Logging. For information about managing log files and diagnostic data, see Oracle Fusion Middleware Administrator's Guide.