ADW Data Server "Use Credential File" Becomes Unchecked After Save and "Credential Details" are Reset in ODI (Doc ID 2694043.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Symptoms

In Oracle Data Integrator on Marketplace Studio, and Oracle Data Integrator (ODI) 12.2.1.4 Studio > Topology, define an ADW Data Server, and have the "Use Credential File" box checked.

In the "Credential Details" section, chose the credential file, and the connection details.

Apply the changes, and test the connection.
Note that the result of test is irrelevant to the issue.

• Behavior observed:
  
  Close the ADW Data Server, and re-open. Observe that the "Use Credential File" box is unchecked. On the JDBC tab however, the information previously auto-filled is maintained.

  Close ODI Studio, and re-connect.

  Edit the ADW Data Server. Observe that the "Use Credential File" box now is checked, and the "Credential File" information set.

• Expected behavior:
  
  ODI should not un-set the "Use Credential File" box and related credential information.

The issue can be reproduced at will with the following steps:

1. Set an ADW Data server, and check "Use Credential File". Pick the .zip file to use, and the "Connection Details" desired.
2. Test the connection (irrelevant if it fails or succeeds).
3. Close the Data Server.
4. Re-open the Data Server, and observe that the "Use Credential File" is unckecked, and the file and instance chosen do no longer display. The info on JDBC tab still is there / valid.
5. Close ODI Studio and reconnect to the Repositories.
6. Edit the above Data Server, and observe that now "Use Credential File" is checked, and the .zip and instance chosen are shown.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.