Setting the Business Analytics Warehouse Connection in Oracle Data Integrator

Use Oracle Data Integrator (ODI) Studio to set the connection properties in the ODI Repository of the physical schema associated with the BIAPPS_DW_FILE physical server.

To set the Oracle Business Analytics Warehouse physical schema connection in ODI:
  1. Log in to ODI Studio using the Oracle BI Applications Administrator credentials.
  2. In the navigation pane, go to Topology, and expand Technologies, and then expand File.
  3. Double-click BIAPPS_DW_FILE.
  4. In the Definition pane, for the Directory (Schema) and Directory (Work Schema) properties, specify the directory where you copied source files to in Copying Source Files, and include the sub-folders data_files/src_files/BIA_11.

    For example:

    SOURCE_FILE_HOME/biapps/etl/data_files/src_files/BIA_11