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:
- Log in to ODI Studio using the Oracle BI Applications Administrator credentials.
- In the navigation pane, go to Topology, and expand Technologies, and then expand File.
- Double-click BIAPPS_DW_FILE.
- 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