Editing a Connection

• Console
• CLI
• API

• Note
  
  Support for using passwords will be deprecated soon. We recommend that you use the OCI Vault option. For information, see OCI Vault Secrets and Oracle Wallets.

  1. On the Data assets page, select the name of the data asset that you want to work in. If you need help finding the Data assets page, see Listing Data Assets.
  2. In the Connections section of the data asset details page, select Edit from the Actions menu () of the connection.
  3. In the Edit connection panel, edit the fields as needed. For information about the fields, see the applicable page for the data asset at Data Assets.

     If the data asset has only one connection, you cannot clear the Make this the default connection checkbox.

  4. (Optional) Select Test connection to ensure that a connection can be established.

     A success or failure message appears to indicate the result of the test. A successful test isn't required to edit the connection.

     If the test fails because of missing policies, a list of policies that must be added appears in an information box.

     • If you're using a cross-tenancy OCID in an OCI Object Storage data asset, cross-tenancy policies are required to connect to the data asset. For information about the required policies and the process to create them, select View documentation in the information box that appears when you enter a cross-tenancy OCID.
     • For an autonomous database data asset, a list of policies appears only if you have selected Use vault secret OCID as the option to provide the login credentials for the autonomous database.
  5. Select Save connection.

     If applicable, select Continue to continue using a password.

     A notification appears informing you that the connection is saved successfully.

• Use the oci data-integration connection update command and required parameters to update a connection:

  oci data-integration connection update [OPTIONS]

  For a complete list of flags and variable options for CLI commands, see the Command Line Reference.

• Run the UpdateConnection operation to update a connection.