Oracle Cloud Infrastructure Documentation

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 credentials of an applicable user, such as MyFAWExtractUser.

Tutorial icon LiveLabs Sprint

See Create a User in Oracle Fusion Cloud Applications to Extract Data.

You can update the source URL to point to another source environment for Oracle Fusion Cloud Applications. You can update the applicable user credentials 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 user credentials if the passwords differ between environments or if the password for the applicable user has expired. Prior to entering the new password, ensure that you have reset the password for the applicable user, such as MyFAWExtractUser, 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 the credentials of an applicable user, such as MyFAWExtractUser from your Oracle Fusion Cloud Applications instance in Username and Password.
    Description of fawag_update_fa.png follows
  7. Click Test Connection to verify the updated connection details.
  8. Click Save Changes.