Setting the Business Analytics Warehouse Connection in Oracle Data Integrator

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

To set the Business Analytics Warehouse physical schema connection in Oracle Data Integrator:
  1. Log in to ODI Studio using the 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