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 may want to update the source URL if you want to point to another source environment for Oracle Applications Cloud. You may want to update the password for the FAWService user when your source Oracle Applications Cloud instance has been refreshed 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.

   • Note:

     See Configure JWT Authentication Provider.
     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.
   • If you choose Password Based, enter the credentials of the default FAWService user from your Oracle Applications Cloud instance.
7. Enter the new URL and password .
8. Optional: Select the Enable Username check box and update the default FAWService user name.

   Note:

   The FAWService user is a predefined user provisioned in Oracle Applications Cloud and is used by the data pipeline functionality. Update the user name only if you have a specific reason for doing so.
9. Click Test Connection to verify the updated connection details.
10. Click Save Changes.