Importing Connection Details Which Configures the Data Servers

Use this procedure to perform post-import configurations.

  1. Launch the ODI Studio client and connect to the ODI repository.
  2. Navigate to the Topology tab. From the Connect Navigator (Topology icon dropdown on the top right side of the navigator pane), select Import.
    As part of the procedures described below, you will import the file created by exporting the ’Global’ context in topic Exporting Topology Settings from Original ODI Repository.
  3. In the Import Selection dialog, select Smart Import.
  4. In the File Selection screen, specify the export file created in topic Exporting Topology Settings from Original ODI Repository .
  5. The default behavior of Smart Import is to Merge details in the target repository. Ensure that no issues are reported – if issues are reported, resolve them to ensure that the existing details are replaced by the details being imported. Select the BIAPPS_DW and BIAPPS_BIACOMP Data Servers, select the Overwrite option, and continue.
  6. Verify the imported details.
    Verify that the following logical schemas have the correct data source Num ID value set in the DATASOURCE_NUM_ID flex field:

    If you do not see 999 values for all these logical schemas, then set it with 999 values.

  7. In ODI Studio, navigate to Topology > Physical Architecture. Open the BIAPPS_DW physical server.
  8. Verify that the User and Password is correctly populated under the Definition tab.
  9. On the JDBC tab, verify that the JDBC URL is correctly set. If you used the default Merge action during the Smart Import, then the User and Password will be updated but the JDBC URL will remain unchanged.
  10. Repeat steps 1-4 for the BIAPPS_BIACOMP physical server.
  11. Verify that the Physical schema for BIACOMP and DW are set as defaults. If they are not set as defaults, then the load plans will fail.
    1. In ODI Studio, navigate to Topology > Physical Architecture.

    2. Open the physical schema under the BIAPPS_BIACOMP physical server.

    3. Verify that the Default check box is selected on the Definition tab.

    4. Select the Default check box if it is not checked. Save changes.

  12. Repeat steps 2 to 4 for the physical schema under the BIAPPS_DW physical server.