1. Administering Oracle Fusion Analytics Warehouse
  2. Set Up Oracle Fusion Analytics Warehouse
  3. Update the Data Source Connection Details

Update the Data Source Connection Details

Update your data source connection details such as the URL for the Oracle Applications Cloud instance that you specified while creating your Oracle Fusion Analytics Warehouse instance and the password for the FAWService user.

You can update the source URL to point to another source environment for Oracle Applications Cloud. You can update the password for the FAWService user when your source Oracle Applications Cloud instance has been refreshed with data from another environment, for example, due to a Production to Test refresh. You also update the password for the FAWService user if the passwords differ between environments or if the password for the FAWService user has expired. Prior to entering the new password, ensure that you have reset the password for the FAWService user in Oracle Applications Cloud. See Reset Passwords.
  1. Sign in to the Oracle Cloud Infrastructure Console.
  2. In Oracle Cloud Infrastructure Console, click the Navigation menu icon in the top left corner.
  3. Click Analytics & AI. Under Analytics, click Fusion Analytics Warehouse.
    You see the service instances page.
  4. On the Instances page, click the instance for which you want to update the Oracle Applications Cloud password.
  5. On the instance details page, click Update Fusion Connection.
  6. Select the type of authentication you want to use: JWT Based or Password Based.
    • If you choose JWT Based, upload or copy and paste the private key and public certificate files, then select Keys have been uploaded to Fusion Source.

      Note:

      See Configure JWT Authentication Provider.

      Ensure that the generated RSA encryption private key contains at least 2048 characters and that you wait at least 15 minutes for the uploaded public certificate to become effective in your Oracle Applications Cloud instance.

    • If you choose Password Based, then enter and confirm the password of the default FAWService user from your Oracle Applications Cloud instance.
  7. Enter the new URL and password.
  8. Click Test Connection to verify the updated connection details.
  9. Click Save Changes.