Typical Workflow to Administer Oracle Fusion Analytics Warehouse
If you’re setting up Oracle Fusion Analytics Warehouse for the first time, then follow these tasks as a guide.
Task | Description | More Information |
---|---|---|
Place and activate the order for an Oracle Cloud account with universal credits. | Before you place an order for Oracle Fusion Analytics Warehouse, you need an Oracle Cloud account with universal credits in one of the regions where Oracle Fusion Analytics Warehouse is available. | Place and Activate the Order for an Oracle Cloud Account with Universal Credits |
Place and activate the order for Oracle Fusion Analytics Warehouse. | Contact your Oracle sales representative to place an order for Oracle Fusion Analytics Warehouse. Your sales representative places an order for the specific SKU, for example, Oracle Fusion ERP Analytics or Oracle Fusion HCM Analytics. | Place and Activate the Order for Oracle Fusion Analytics Warehouse |
Sign into the Oracle Cloud Infrastructure Console. | After you activate the service, use the cloud account credentials to access your services.
If you're the first user on the account and were invited by Oracle Cloud, then you're automatically added to the Administrators group. You can invite other members of the organization by adding users in Oracle Cloud Infrastructure Identity and Access Management. If you are planning to use single sign-on to access Oracle Fusion Analytics Warehouse, then Set Up Provisioning with Single Sign-On before proceeding with this and the subsequent tasks. |
Sign In to the Oracle Cloud Infrastructure Console |
Use the Oracle Cloud Infrastructure Console to access the service pages. | When you sign in to the Console, you'll see the home page. Use the navigation menu in the upper left to navigate to the service pages where you create, manage, and view your cloud resources. | Access Your Service |
(Optional) Add a user with administrator permissions for the service. | Add a user with full administrator permissions of the default administrator of the service. | Add Users with Administrator Permissions |
Set up user access to Oracle Fusion Analytics Warehouse using single sign-on. | You can set up how users from Oracle Applications Cloud access Oracle Fusion Analytics Warehouse using single sign-on. This setup eases the management of various user names and passwords. It enables you to synchronize users and roles in Oracle Applications Cloud with Oracle Identity Cloud Service and then enable these users to access Oracle Fusion Analytics Warehouse. | Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On |
Create an instance for Oracle Fusion Analytics Warehouse. | Use the Console to create an instance.
If you’ve set up provisioning with single sign-on, which federates your tenancy with Oracle Identity Cloud Service, then you create the Fusion Analytics Warehouse instance in the federated Oracle Identity Cloud Service instance. If your tenancy isn’t federated with an identity provider, then you create the Fusion Analytics Warehouse instance in the default Oracle Identity Cloud Service instance that is available with your Oracle Fusion Analytics Warehouse subscription. |
Create an Oracle Fusion Analytics Warehouse Subscription Instance |
Verify the Oracle Fusion Analytics Warehouse instance. | You receive an email when your instance is ready. Check that you can sign in and that your instance is up and running. | Verify Your Instance and Sign In |
Create and associate users and groups. | When you set up provisioning with single sign-on, you enable synchronization of users and their associated roles from Oracle
Applications Cloud to your federated Oracle Identity Cloud
Service instance. After the initial synchronization, if you add users in your Oracle
Applications Cloud instance, they are automatically available in your federated Oracle Identity Cloud
Service instance because you've enabled synchronization. See Set Up Provisioning with Single Sign-On. You can also add additional users in your federated Oracle Identity Cloud
Service instance through Oracle Fusion
Analytics Warehouse using the User Management option in the Console.
When you set up provisioning without single sign-on, to access Oracle Fusion Analytics Warehouse, manually create Oracle Applications Cloud users and groups (these are the equivalent of job roles in Oracle Applications Cloud) in Oracle Identity Cloud Service and then assign the groups (job roles) to users in |
Assign Users to a Group and Assign Groups to Users. |
Configure data security. | Ensure that users have appropriate access to use Oracle Fusion Analytics Warehouse. Access to subject areas and data depends on the roles assigned to the users. | Manage Users, Groups, Application Roles, and Data Access |
Configure Oracle Fusion Analytics Warehouse data. | Set up global and reporting configurations and create data pipelines for functional areas to copy your Oracle Applications Cloud data to the data warehouse. | Configure Oracle Fusion Analytics Warehouse Data |