Here are some administration topics related to Oracle Business Intelligence Applications ETL processes.
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 Data Definition Language (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 Oracle Data Integrator (ODI) to generate a new DDL script.
To generate DDL scripts and assign tablespaces to tables and indexes, see Generating DDL and Assigning Tablespaces to Tables and Indexes in Oracle Business Intelligence Applications Installation Guide.
Logging and Diagnostics
Oracle BI Applications Configuration Manager uses Oracle Diagnostic Logging. See Managing Log Files and Diagnostic Data in Oracle Fusion Middleware Administrator's Guide.
Creating ETL Tables for Siebel Sources
If your source system is Siebel and you are deploying one of the following offerings, you must 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 database administrator, who must create the necessary tables in the Siebel database.
Note:
The database user used for the ETL connection requires all Data Manipulation Language (DML) privileges (SELECT, INSERT, DELETE, UPDATES) and DDL (TRUNCATE) privileges to S_ETL tables.To create the S_ETL tables: