Use this procedure to perform post-import configurations.
- Log in to ODI Studio using the BI Applications Administrator user.
- Configure the BIAPPS_DW data server:
- In ODI Studio, navigate to Topology, Physical Architecture, Oracle, BIAPPS_DW.
- On the Definition tab, in the Connection area, enter this information:
- On the JDBC tab, enter the JDBC URL for the <prefix>_DW schema.
For example: jdbc:oracle:thin:@myhost:1521/orcl
- In the Physical Architecture pane, expand the BIAPPS_DW data server and double-click BIAPPS_DW.BIAPPS_DW.
- Enter the DW schema user for both Schema(Schema) and Schema(Work) fields.
- Configure the BIAPPS_BIACOMP data server:
- In ODI Studio, navigate to Topology, Physical Architecture, Oracle, BIAPPS_BAICOMP.
- On the Definition tab, in the Connection area, enter this information:
- On the JDBC tab, enter the JDBC URL for BIACM_IO (the same as that for <prefix>_BIACOMP).
For example: jdbc:oracle:thin:@myhost:1521/orcl
- In the Physical Architecture pane, expand the BIAPPS_BIACOMP data server and choose the Physical Schema under it, and double-click BIAPPS_DW.BIAPPS_DW.
- Enter <prefix>_BIACM_IO user for both Schema(Schema) and Schema(Work) fields.