2 Create Services with Oracle Analytics Cloud
As Cloud Account Administrator, you can create and set up services in Oracle Analytics Cloud for your organization.
Typical Workflow to Create a Service
If you’re about to create an Oracle Analytics Cloud instance on Oracle Cloud Infrastructure in using Oracle Cloud Infrastructure Console for the first time, follow these tasks as a guide.
Task | Description | More Information |
---|---|---|
Before you start |
||
Activate your order and sign in to your Oracle Cloud account |
As the Cloud Account Administrator, you can complete all setup tasks for Oracle Analytics Cloud. |
|
Determine your service requirements |
Plan your Oracle Analytics Cloud deployment. Think about what you need before you start. |
|
(Optional) Enable other users to set up services |
If you don’t want to set up Oracle Analytics Cloud yourself, give other users permissions to create services. |
Give Another User Permission to Set Up Oracle Analytics Cloud |
(Recommended) Create a compartment for your service | Create a compartment for your Oracle Analytics Cloud deployment. | Create a Compartment |
Create the service | ||
Create a service |
Use Oracle Cloud Infrastructure Console to deploy a new service. |
|
Verify your service |
When your service is ready, check that you can sign in and your service is up and running. |
|
Complete the setup |
||
Set up users and groups |
Set up users and groups for Oracle Analytics Cloud in Oracle Identity Cloud Service and assign them to application roles. |
|
Set service-level options |
Configure service-level options for everyone using the service. |
|
Migrate content |
Leverage your existing content in Oracle Analytics Cloud. |
Before You Create a Service
Before you set up Oracle Analytics Cloud on Oracle Cloud Infrastructure using Oracle Cloud Infrastructure Console, Oracle recommends that you take some time to plan your service.
-
Give Another User Permission to Set Up Oracle Analytics Cloud (Optional)
-
Create a Compartment (Recommended)
Plan Your Service
Take some time to plan your Oracle Analytics Cloud service before you create it. Think about the questions outlined here and decide what you want to do, before you start.
Which Feature Set Do You Need?
When you set up a service you must decide which feature set you want to deploy.
Feature Set | Description |
---|---|
Self-Service Analytics |
Data visualization |
Enterprise Analytics |
Enterprise modeling, reporting, and data visualization |
Where Do You Want to Deploy Your Service?
Oracle Cloud Infrastructure (Gen 2) is hosted in several different geographic areas, called regions. When you sign up for Oracle Analytics Cloud, Oracle creates a tenancy for your company with access to one or more regions. If multiple regions are available to you, decide where you want to deploy your Oracle Analytics Cloud instance.
Note:
Do You Need a Public or Private Endpoint?
When you create an Oracle Analytics Cloud instance, you specify how you want to access your service: through a public internet accessible endpoint or a private endpoint.
After you've created Oracle Analytics Cloud, you can't switch from a public endpoint to a private endpoint (or the other way around). So it's important to decide what type of access your organization needs and complete the required prerequisites before you start. See Prerequisites for a Public Endpoint and Prerequisites for a Private Endpoint.
If you're not sure, see About Public Endpoints and Access Control Rules and About Private Endpoints.
What Sizing Options Are Available to You?
When you create an Oracle Analytics Cloud instance, you either specify the number of Oracle Compute Units (OCPUs) you want to deploy or the number of people you expect to use the service.
How Many OCPUs Do You Think You’ll Need?
Oracle Analytics Cloud offers a range of compute sizes (OCPUs) to suit different scenarios. The larger the compute size, the greater the processing power. If you're not sure which size to use, contact your sales team to discuss sizing guidelines.
The compute size you select also determines some configuration limits for the different types of content that users can create:
-
Data visualization projects
-
Classic analyses and dashboards
-
Classic pixel-perfect reports
For example, limits such as the maximum number of input rows you can return from a data source query or the maximum number of rows you can download from a report to a file (for example, when you export to a CSV file).
Limits Querying Data (Data Visualization Projects, Classic Analyses and Dashboards)
When you query a data source for data visualization projects or classic analyses and dashboards, the compute size determines the maximum number of rows that are returned from the data source.
Which compute size do you think you’ll need? | Limits when querying data for visualizations, analyses, and dashboards | |
---|---|---|
Max input rows returned from any data source query | Query timeout (seconds) | |
1 OCPU (trials only) |
125,000 |
600 |
2 OCPU |
2,000,000 |
600 |
4 OCPU |
2,000,000 |
600 |
6 OCPU |
2,000,000 |
600 |
8 OCPU |
2,000,000 |
600 |
10 OCPU |
2,000,000 |
600 |
12 OCPU |
2,000,000 |
600 |
16 OCPU |
4,000,000 |
600 |
24 OCPU |
4,000,000 |
600 |
36 OCPU |
4,000,000 |
600 |
52 OCPU |
4,000,000 |
600 |
Limits Displaying Data (Data Visualization Projects, Classic Analyses and Dashboards)
When you display data in data visualization projects or classic analyses and dashboards, the compute size determines the maximum number of summarized rows returned from the data source that are displayed.
Which compute size do you think you’ll need? | Limits when displaying data in visualization projects, analyses, and dashboards |
---|---|
Max summarized rows returned from any data source query | |
1 OCPU (trials only) |
125,000 |
2 OCPU |
500,000 |
4 OCPU |
500,000 |
6 OCPU |
500,000 |
8 OCPU |
500,000 |
10 OCPU |
500,000 |
12 OCPU |
500,000 |
16 OCPU |
1,000,000 |
24 OCPU |
1,000,000 |
36 OCPU |
1,000,000 |
52 OCPU |
1,000,000 |
Limits Exporting Data (Data Visualization Projects)
When you export data from a data visualization project, the compute size determines the maximum number of rows you can export.
Which compute size do you think you’ll need? | Limits when exporting data from data visualizations projects |
---|---|
Maximum number of rows | |
1 OCPU (trials only) |
125,000 |
2 OCPU |
500,000 |
4 OCPU |
500,000 |
6 OCPU |
500,000 |
8 OCPU |
500,000 |
10 OCPU |
500,000 |
12 OCPU |
500,000 |
16 OCPU |
1,000,000 |
24 OCPU |
1,000,000 |
36 OCPU |
1,000,000 |
52 OCPU |
1,000,000 |
Limits Exporting Data (Classic Analyses and Dashboards)
When you export data from analyses and dashboards, the compute size determines the maximum number of rows you can export. There are different limits for formatted reports and unformatted reports.
-
Unformatted report limits: formats such as CSV, Excel, XML, and Tab Delimited.
-
Formatted report limits: formats such as PDF, Excel, Powerpoint, and Web Archive/HTML.
Which compute size do you think you’ll need? | Limits when exporting data from analyses and dashboards | |
---|---|---|
Max rows exported to unformatted reports | Max rows exported to formatted reports | |
1 OCPU (trials only) |
125,000 |
1,000 |
2 OCPU |
2,000,000 |
200,000 |
4 OCPU |
2,000,000 |
200,000 |
6 OCPU |
2,000,000 |
200,000 |
8 OCPU |
2,000,000 |
200,000 |
10 OCPU |
2,000,000 |
200,000 |
12 OCPU |
2,000,000 |
200,000 |
16 OCPU |
4,000,000 |
400,000 |
24 OCPU |
4,000,000 |
400,000 |
36 OCPU |
4,000,000 |
400,000 |
52 OCPU |
4,000,000 |
400,000 |
Limits Delivering by Email (Classic Analyses and Dashboards)
When you send analyses and dashboards by email, the compute size determines the maximum number of rows you can deliver in a single email. There are different limits for delivering formatted reports and unformatted reports.
-
Unformatted report limits: formats such as CSV, Excel, XML, and Tab Delimited.
-
Formatted report limits: formats such as PDF, Excel, Powerpoint, and Web Archive/HTML.
Which compute size do you think you’ll need? | Limits when delivering analyses and dashboards by email | |
---|---|---|
Max rows in unformatted reports delivered by email | Max rows in formatted reports delivered by email | |
1 OCPU (trials only) |
1,000 |
1,000 |
2 OCPU |
50,000 |
25,000 |
4 OCPU |
50,000 |
25,000 |
6 OCPU |
50,000 |
25,000 |
8 OCPU |
50,000 |
25,000 |
10 OCPU |
50,000 |
25,000 |
12 OCPU |
50,000 |
25,000 |
16 OCPU |
100,000 |
50,000 |
24 OCPU |
100,000 |
50,000 |
36 OCPU |
100,000 |
50,000 |
52 OCPU |
100,000 |
50,000 |
Data Size Limits (Classic Pixel-Perfect Reports)
The compute size determines several limits associated with generating reports.
Which compute size do you think you’ll need? | Report data size limits when generating pixel-perfect reports | |||
---|---|---|---|---|
Max data size for online reports | Max data size for offline (scheduled) reports | Max data size for bursting reports | Max data size for data generation | |
1 OCPU (trials only) |
200MB |
500MB |
2GB |
500MB |
2 OCPU |
500MB |
2GB |
4GB |
2GB |
4 OCPU |
500MB |
2GB |
4GB |
2GB |
6 OCPU |
500MB |
2GB |
4GB |
2GB |
8 OCPU |
500MB |
2GB |
4GB |
2GB |
10 OCPU |
500MB |
2GB |
4GB |
2GB |
12 OCPU |
500MB |
2GB |
4GB |
2GB |
16 OCPU |
500MB |
4GB |
8GB |
4GB |
24 OCPU |
500MB |
4GB |
8GB |
4GB |
36 OCPU |
500MB |
4GB |
8GB |
4GB |
52 OCPU |
500MB |
4GB |
8GB |
4GB |
Processing Limits (Classic Pixel-Perfect Reports)
The compute size determines several limits associated with processing reports.
Which compute size do you think you’ll need? | Data model and report processing limits when generating pixel-perfect reports | ||||
---|---|---|---|---|---|
SQL Query timeout (seconds) | Max rows for CSV output | Max number of in-memory rows in XPT layout | Max number of concurrent scheduled jobs | Max number of concurrent online reports | |
1 OCPU (trials only) |
1,800 |
1,000,000 |
100,000 |
1 |
2 |
2 OCPU |
1,800 |
4,000,000 |
200,000 |
4 |
16 |
4 OCPU |
1,800 |
4,000,000 |
200,000 |
4 |
32 |
6 OCPU |
1,800 |
4,000,000 |
200,000 |
4 |
48 |
8 OCPU |
1,800 |
4,000,000 |
200,000 |
4 |
64 |
10 OCPU |
1,800 |
4,000,000 |
200,000 |
4 |
80 |
12 OCPU |
1,800 |
4,000,000 |
200,000 |
4 |
96 |
16 OCPU |
3,600 |
6,000,000 |
300,000 |
10 |
320 |
24 OCPU |
3,600 |
6,000,000 |
300,000 |
10 |
480 |
36 OCPU |
3,600 |
6,000,000 |
300,000 |
10 |
720 |
52 OCPU |
3,600 |
6,000,000 |
300,000 |
10 |
1040 |
How Many People Do You Expect to Use the Service?
With Oracle Analytics Cloud, you can opt to specify how many people you expect to use the service. Typically, services have between 10 and 3000 users.
Configuration limits are equivalent to those available with 4 OCPUs. For example, the maximum number of input rows you can return from any data source query is 1,100,000 rows, the maximum number of rows you can export to a formatted report (such as PDF) is 25, 000 rows, and so on.
What Name Do You Want for Your Service?
Think about a suitable name for your service. The name that you specify is displayed in Oracle Cloud Infrastructure Console and the URL for your service.
Name restrictions:
-
Must contain between 1 and 25 characters.
-
Must start with an ASCII letter: a to z or A to Z.
-
Must contain only ASCII letters or numbers.
-
Mustn't contain any other special characters.
-
Must be unique within the identity domain.
Give Another User Permission to Set Up Oracle Analytics Cloud
When you activate your order for Oracle
Analytics Cloud, you get the Cloud Account Administrator role. This role gives you full
administration privileges in Oracle Cloud
Infrastructure so you can complete all aspects of Oracle
Analytics Cloud setup and much more. There’s no need to delegate this responsibility but, if you want to,
you can give someone else privileges to create and manage Oracle
Analytics Cloud instances through the manage analytics-instances
permission.
manage
analytics-instances
permission on a specific compartment or the tenancy
(any compartment in the tenancy). For example, you might create a policy statement that
looks like one of these:
-
allow group MyAdminGroup to manage analytics-instances in tenancy
-
allow group MyAdminGroup to manage analytics-instances in compartment MyOracleAnalytics
Create a Compartment
When you sign up for Oracle Cloud Infrastructure, Oracle creates your tenancy with a root compartment that holds all your cloud resources. You then create additional compartments within the tenancy (root compartment) and corresponding policies to control access to the resources in each compartment. Before you create an Oracle Analytics Cloud instance, Oracle recommends that you set up the compartment where you want the instance to belong.
You create compartments in Oracle Cloud Infrastructure Identity and Access Management (IAM). See Setting Up Your Tenancy and Managing Compartments.
Create a Service
You can create an Oracle Analytics Cloud instance using the Console, API, or command line.
Note:
Required IAM Policy
Verb: manage
Resource Type:
analytics-instance
,
analytics-instances
Custom Permission:
ANALYTICS_INSTANCE_CREATE
See About Permissions to Manage Oracle Analytics Cloud Instances.
Additional IAM Policy Required to Create a Public Endpoint
Verb: read
Resource Type:
virtual-network-family
,
compartment
,
compartments
See Prerequisites for a Public Endpoint.
Additional IAM Policy Required to Create a Private Endpoint
Verb: manage
Resource Type:
virtual-network-family
Verb: read
Resource Type: compartment
,
compartments
To learn about other, more detailed access policy options, see Prerequisites for a Private Endpoint.
Create a Service using the Console
You can use Oracle Cloud Infrastructure Console to set up a service instance with Oracle Analytics Cloud.
Create a Service using the REST API
You can use the CreateAnalyticsInstance
operation to
set up a service instance with Oracle
Analytics Cloud.
Refer to the Oracle Cloud Infrastructure REST API Reference for information about how to use this operation:
After You Create a Service
After creating a service with Oracle Analytics Cloud, you must set up your users and configure additional options for your service. If you’re migrating to Oracle Analytics Cloud from on-premises or another cloud service you might want to migrate your existing content now.
Verify Your Service and Sign In
Oracle sends an email to the designated email address when your Oracle Analytics Cloud service is ready. Navigate to your service in Oracle Cloud Infrastructure Console, click the Analytics Home Page button, and then sign in to verify your Oracle Analytics Cloud service is up and running.
Note:
Required IAM Policy
Verb: read
Resource Types: analytics-instance
,
analytics-instances
Permission: ANALYTICS_INSTANCE_READ
See About Permissions to Manage Oracle Analytics Cloud Instances.
Set Up Users, Groups, and Application Roles
One of the first jobs you do after setting up a service with Oracle Analytics Cloud is to add user accounts in Oracle Identity Cloud Service for everyone you expect to use the service and then assign them suitable permissions in Oracle Analytics Cloud (also known as application roles).
Oracle Identity Cloud Service is available with your Oracle Analytics Cloud account.
-
Add users and groups.
Use Oracle Identity Cloud Service to add users and groups. See Manage Users and Groups in Oracle Identity Cloud Service in Administering Oracle Identity Cloud Service.
-
Assign users and groups permissions in Oracle Analytics Cloud.
Use the Console (Users and Roles page) in your Oracle Analytics Cloud service to give users and groups suitable application roles. See Manage What Users Can See and Do in Configuring Oracle Analytics Cloud.
Configure Options for Your Service
Administrators perform many critical duties; they control user permissions and amend accounts, set up database connections for data modelers, manage data storage to avoid exceeding storage limits, take regular snapshots so users don't risk losing their work, authorize access to external content by registering safe domains, troubleshoot user queries, and much more. After setting up a service with Oracle Analytics Cloud, you can review typical administrator tasks for your service.
See Administrator Task List in Configuring Oracle Analytics Cloud.
Migrate to Oracle Analytics Cloud from Other Environments
Do you have content in an existing on-premise system or another cloud service that you want to leverage in Oracle Analytics Cloud? After setting up your service, you can migrate the content to the new environment.
Migrate From... | More Information |
---|---|
Other Oracle Analytics Cloud deployments on Oracle Cloud Infrastructure |
|
Oracle Analytics Cloud - Classic deployed on Oracle Cloud Infrastructure Classic |
Migrating Oracle Analytics Cloud - Classic Instances to Oracle Cloud Infrastructure |
Oracle BI Cloud Service |
Migrating Oracle Business Intelligence Cloud Service Instances to Oracle Cloud Infrastructure |
Oracle Data Visualization Cloud Service |
Migrating Oracle Data Visualization Cloud Service Instances to Oracle Cloud Infrastructure |
Oracle BI Enterprise Edition |
Migrating Oracle Business Intelligence Enterprise Edition to Oracle Analytics Cloud |