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 Fusion Cloud Applications 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 Fusion Cloud Applications. You can update the password for the FAWService user when your source Oracle Fusion Cloud Applications 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 Fusion Cloud Applications. 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.
  4. On the Instances page, click the instance for which you want to update the Oracle Fusion Cloud Applications password.
  5. On the instance details page, click Update Fusion Connection.
  6. In Update Fusion Application Credentials, enter the new URL and 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. While configuring the token-based authentication, ensure that you enter FAWServiceJWTIssuer as the trusted issuer.

      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 Fusion Cloud Applications instance.

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