Create an Oracle Fusion Analytics Warehouse Subscription Instance

Create a service instance to manage your cloud resources.

1. Sign in to the Oracle Cloud Infrastructure Console.
   If you've provisioned Oracle Fusion Analytics Warehouse with single sign-on, then sign in using the federated Oracle Identity Cloud Service. See Set Up Provisioning with Single Sign-On.
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 Create Instance.

   Note:

   If you haven't purchased a subscription, then the Create Instance button isn't active.
5. Optional: Select a compartment if you want to place the service instance in a compartment other than the default root compartment that Oracle created for you.

   Note:

   Ensure that you have created a compartment before you select it here. See Managing Compartments.
6. Provide a display name for the service.
   This name needn't be unique and can contain alphanumeric and special characters.
7. Provide a name for the instance.
   This name should be unique in your tenancy (only names of deleted services can be reused). Also, this name can contain only alphanumeric characters without spaces.
8. Provide a description for the service.
   The description is optional and can contain as many as 255 alphanumeric and special characters.
9. Select Development/Test as your first instance.
10. Under Offerings, enable Subscription Configuration.
    Oracle Fusion Analytics Warehouse automatically configures the offerings based on your subscription details. For example, if you've subscribed for 20 ERP users, then you see the number of users for the instance automatically configured to 20 ERP users.
11. In Fusion Application Connection, provide the Oracle Applications Cloud URL (not the Login URL).
    The FAWService user is a predefined user provisioned in Oracle Applications Cloud and is used by the data pipeline functionality in Oracle Fusion Analytics Warehouse. This user account has the appropriate data security privileges granted on the Oracle Applications Cloud view objects to bulk extract data from Oracle Applications Cloud into the data warehouse.

    Note:

    Ensure that you have reset the password for the FAWService user in Oracle Applications Cloud prior to entering the new password. See Reset Passwords.
12. Select the type of authentication you want to use: Oracle recommended JWT Based or Password Based.
    • If you choose JWT Based (JSON web token), then upload or copy and paste the private key and public certificate files. Ensure that you select Keys have been uploaded to Fusion Source to enable Test Connection.

      Note:

      See Configure JWT Authentication Provider.
    • If you choose Password Based, enter the credentials of the default FAWService user from your Oracle Applications Cloud instance.
13. Optional: Click Test Connection to check the connection to the Oracle Applications Cloud instance and confirm whether the credentials are valid.
14. In Autonomous Data Warehouse Administrator Credentials, provide an administrator password for the Oracle Autonomous Data Warehouse that's provisioned in your tenancy to store the transformed data.
15. The email address for notification is pre-populated from the user name. If the user name isn't an email address, then provide a valid email address for notifications.
    You receive an email notification, for example, when your Oracle Applications Cloud password is invalid.
16. Optional: Add tags to your instance.
17. Click Create Instance.

Oracle sends an email to the designated email address when your service is ready. Alternatively, you can display the Activity page to check the current status. When the status changes from CREATING to ACTIVE, the service is ready to use.

Navigate to the Details page for the new service to access the Oracle Fusion Analytics Warehouse URL and associated Oracle Autonomous Data Warehouse. From here, you can also view or modify details such as the password for your Oracle Applications Cloud instance and the administrator password for the Oracle Autonomous Data Warehouse. You can also delete the service instance that's no longer required.

If you had set up provisioning of Oracle Fusion Analytics Warehouse with single sign-on, then your service is associated with the federated Oracle Identity Cloud Service instance. If you hadn’t set up single sign-on for Oracle Fusion Analytics Warehouse, then your service is associated with the default Oracle Identity Cloud Service instance that you received with your Oracle Cloud account.

Verify Your Instance and Sign In

Oracle sends an email to the designated email address when your Oracle Fusion Analytics Warehouse service instance is ready.

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. Navigate to your service instances page.
5. Navigate to the Analytics Application URL to verify that your Oracle Fusion Analytics Warehouse service instance is up and running.