3 Administer Services with Oracle Analytics Cloud

As Cloud Account Administrator, you can administer all aspects of Oracle Analytics Cloud for your organization.

Topics

• Typical Workflow to Administer a Service

• Set Up Users and Application Roles

• Configure Options for Your Service

• Migrate to Oracle Analytics Cloud from Other Environments

• Scale a Service

• Pause and Resume a Service

• Delete a Service

• Give Another User Permission to Set Up Oracle Analytics Cloud

• Manage Credentials
• About Access Into and Out from Analytics Cloud Instances

Typical Workflow to Administer a Service

After you create a service with Oracle Analytics Cloud for the first time, follow these tasks as a guide.

Task	Description	More Information
Complete the set up	Verify that your service is up and running and that you can sign in.	Verify Your Service and Sign In
Manage users and application roles	Add users for Oracle Analytics Cloud in Oracle Identity Cloud Service and assign them to groups. Give users permissions in your service through application roles.	Set Up Users and Application Roles
Enable other users to create Oracle Analytics Cloud services	Give other users permissions to create services and access to Oracle Cloud Infrastructure.	Give Another User Permission to Set Up Oracle Analytics Cloud
Configure more options for your service	Configure service-level options for your service. The options available depend on the features that you chose to deploy. Data Visualization Business Intelligence — Enterprise Modeling Essbase — Collaborative Data Collection, Scenarios, What If Analysis	Configure Options for Your Service
Migrate content	Leverage your existing content in Oracle Analytics Cloud.	Migrate to Oracle Analytics Cloud from Other Environments
Scale a service up or down	Increase or decrease the number of Oracle Compute Units (OCPUs) allocated to your service.	Scale a Service
Pause or resume a service	Pause a service to temporarily prevent users from accessing the service.	Pause and Resume a Service
Delete a service	Delete services that you don’t want anymore.	Delete a Service Delete a Service with Oracle Cloud Stack
Note down the IP address of Oracle Analytics Cloud	Determine the IP address of your Oracle Analytics Cloud instance.	For Oracle Analytics Cloud Instances Created After 9/8/18 For Oracle Analytics Cloud Instances Created Before 9/8/18
Give your database access to Oracle Analytics Cloud	In your database, add the IP addresses for any Oracle Analytics Cloud instances you want to connect to.	Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists
Add the IP address of your Oracle Analytics Cloud instance to the allowlist in your Oracle Cloud database	Configure your Oracle Cloud database to accept connections from Oracle Analytics Cloud.	Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists
Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure	Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure with a public IP address.	Connect to a Database Deployed on Oracle Cloud Infrastructure with a Public IP Address
Connect to Oracle Autonomous Data Warehouse	Connect to Oracle Autonomous Data Warehouse with a public IP address.	Connect to Oracle Autonomous Data Warehouse with a Public IP Address
Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure Classic	Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure Classic.	Connect to a Database Deployed on Oracle Cloud Infrastructure Classic with a Public IP Address
Reset credentials	Reset credentials and passwords for services and databases, for example, Oracle Cloud Storage.	Manage Credentials

Set Up Users 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 assign them suitable permissions in the service (also known as application roles).

Oracle Identity Cloud Service is available with your Oracle Analytics Cloud account.

• Users and Group — Use Oracle Identity Cloud Service to add users and groups.

  Alternatively, use Oracle Identity Cloud Service to integrate directly with your existing directories and identity management systems. See About Oracle Identity Cloud Service in Administering Oracle Identity Cloud Service.

• Application Roles — The way you assign users to application roles depends on the feature profile you chose when you set up your service.

  Feature Profile	Assigning Application Roles	Book
  Business Intelligence Data Visualization	Manage What Users Can See and Do	Configuring Oracle Analytics Cloud
  Essbase	Manage Users and Roles	Using Oracle Analytics Cloud - Essbase

Assign Users to Application Roles with Oracle Identity Cloud Service

As administrator, you can assign users certain permissions in Oracle Analytics Cloud through Oracle Identity Cloud Service.

Topics

• About Application Role Assignment with Oracle Identity Cloud Service
• Grant Application Roles with Oracle Identity Cloud Service

About Application Role Assignment with Oracle Identity Cloud Service

When you set up an Oracle Analytics Cloud instance, an application dedicated to that instance is automatically created in Oracle Identity Cloud Service.

If you want to, you can assign user permissions through this application.

Note:

You don’t have to use Oracle Identity Cloud Service. You might prefer to assign user permissions to application roles through the Console. See Configure What Users Can See and Do Using the Console.

The Oracle Identity Cloud Service application for your Oracle Analytics Cloud instance includes several predefined application roles (ServiceAdministrator, ServiceUser, ServiceViewer) that map to a set of predefined application roles in Oracle Analytics Cloud.

Description of the illustration app-roles.jpg

To understand more about the predefined Oracle Analytics Cloud application roles, see About Application Roles.

Grant Application Roles with Oracle Identity Cloud Service

As administrator, you can grant users to application roles in Oracle Analytics Cloud using Oracle Identity Cloud Service.

1. Sign in to your Oracle Cloud account.
2. In Oracle Cloud Infrastructure Console, click in the top left corner.
3. Click Analytics & AI. Under Analytics, click Analytics Cloud. Click Other Analytics, and then click Manage Services.

   If you subscribe through Universal Credits, your services are listed on theOracle Analytics Cloud page that is displayed.

   Note:

   If you have a fixed subscription, you create services with Oracle Analytics Cloud Subscription. To access these services, click the Profile icon in the top right corner, click Service User Console, and then click Oracle Analytics Cloud Subscription.
4. On the Instances page, click the name of the service you want to manage.
   
   Description of the illustration oac-instances-page.jpg
5. On the Instance Overview page, click the name of the IDCS Application that is associated with this Oracle Analytics Cloud instance.
   
   Description of the illustration oac-idcs-app.jpg
6. On the Oracle Identity Cloud Service application page, click Application Roles.
7. Select an application role, and click the Menu for the specific role.
8. From the menu list, select Assign Users.
9. On the Assign Users page, select the users, and click OK.

Configure Options for Your Service

Administrators have 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, taking regular snapshots so users don't risk losing their work, authorize access to external content by registering safe domains, troubleshoot user queries, and so much more. After setting up a service with Oracle Analytics Cloud, you can review typical administrator tasks for your service.

Administration tasks depend on the feature profile you chose when you set up your service.

Feature Profile	Tasks Performed by Administrators	Book
Business Intelligence Data Visualization	Administrator Task List	Configuring Oracle Analytics Cloud
Essbase	Administrator Task List	Using Oracle Analytics Cloud - Essbase

Migrate to Oracle Analytics Cloud from Other Environments

Do you have content in your existing on-premises 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
Oracle Analytics Cloud deployed on Oracle Cloud Infrastructure	BI Enterprise and Data Visualization services See Migrate Oracle Analytics Cloud Using Snapshots in Configuring Oracle Analytics Cloud. Essbase services See Migrate Cloud Service Applications in Using Oracle Analytics Cloud - Essbase.
Oracle Analytics Cloud - Classic deployed on Oracle Cloud Infrastructure Classic	BI Enterprise and Data Visualization Services See Migrating Oracle Analytics Cloud - Classic Instances to Oracle Cloud Infrastructure. Essbase services See Migrating Essbase Instances from Oracle Analytics Cloud – Classic to Oracle Cloud Infrastructure.
Oracle Business Intelligence Cloud Service	BI Enterprise Services See Migrating Oracle Business Intelligence Cloud Service Instances to Oracle Cloud Infrastructure.
Oracle Data Visualization Cloud Service	Data Visualization Services See Migrating Oracle Data Visualization Cloud Service Instances to Oracle Cloud Infrastructure.
Oracle BI Enterprise Edition 12c	BI Enterprise services Migrate semantic models, dashboards and analyses, and application roles. See Migrate Snapshots from Oracle BI Enterprise Edition in Configuring Oracle Analytics Cloud. Migrate semantic models. See Migrate Semantic Models Files from Oracle BI Enterprise Edition in Configuring Oracle Analytics Cloud. Migrate catalog objects, such as dashboards and analyses. See Migrate Catalog Content from Oracle BI Enterprise Edition in Visualizing Data and Building Reports in Oracle Analytics Cloud.
Oracle BI Enterprise Edition 11g	BI Enterprise services See Migrate From Oracle BI Enterprise Edition 11g in Configuring Oracle Analytics Cloud
Oracle Essbase	Essbase services See Migrate On-Premises Applications in Using Oracle Analytics Cloud - Essbase.

Scale a Service

Add more Oracle Compute Units (OCPUs) to improve performance (scale up) or scale down if your workload reduces.

Topics:

• About Scaling

• Scale Up or Down

About Scaling

You can scale services within the OCPU range available to your service. Users don't experience any downtime when you scale a service up or down; your service stays up and running.

Scale options aren't available if you have a fixed Oracle Analytics Cloud Subscription. If you want to scale services created with Oracle Analytics Cloud Subscription, you must create a new service instance with the OCPUs (or users) that you want and migrate your existing content to the new service.

Data Visualization and Business Intelligence Services

• Scale the Number of OCPUs

  You can either scale between 2 and 8 OCPUs or between 10 and 12 OCPUs. If you want to scale across these ranges (for example, scale up from 8 to 12 OCPUs or scale down from 12 to 6 OCPUs), you must create a service instance with the OCPUs that you want and migrate your content to the new service.

  Current OCPUs	OCPU Range	Scale Up within Range?	Scale Down within Range?
  		(Incremental + increase)	(Incremental - decrease)
  1	1	No (not applicable for trials)	No (not applicable for trials)
  2	2 - 8	Yes (+2, +4, +6)	No (minimum for this range)
  4	2 - 8	Yes (+2, +4)	Yes (-2)
  6	2 - 8	Yes (+2)	Yes (-2, -4)
  8	2 - 8	No (maximum for this range)	Yes (-2, -4, -6)
  10	10 - 12	Yes (+2)	No (minimum for this range)
  12	10 - 12	No (maximum for this range)	Yes (-2)
  16	16	No	No
  24	24	No	No
  36	36	No	No
  52	52	No	No

Essbase Services

• Scale the Number of OCPUs

  You can either scale between 6 and 8 OCPUs or between 10 and 16 OCPUs. If you want to scale across these ranges (for example, scale up from 8 to 16 OCPUs or scale down from 12 to 8 OCPUs), you must create a service instance with the OCPUs that you want and migrate your content to the new service.

  Current OCPUs	OCPU Range	Scale Up within Range?	Scale Down within Range?
  		(Incremental + increase)	(Incremental - decrease)
  1	Not applicable	No	No
  2	Not applicable	No	No
  4	Not applicable	No	No
  6	6 - 8	Yes (+2)	No (minimum for this range)
  8	6 - 8	No (maximum for this range)	Yes (-2)
  10	10 - 12 - 16	Yes (+2, +4)	No (minimum for this range)
  12	10 - 12 - 16	Yes (+2, +4)	Yes (-2)
  16	10 - 12 - 16	No (maximum for this range)	Yes (-2, -4)
  24	24	No	No
  36	36	No	No
  52	52	No	No

Scale Up or Down

Scale options are available if you subscribe to Oracle Analytics Cloud through Universal Credits. If your service performs poorly, you can scale up the number of Oracle Compute Units (OCPUs) allocated to the service to improve performance. To save costs or if your workload is reduced, you might scale down.

Note:

Scale options aren't available if you have a fixed Oracle Analytics Cloud Subscription. If you want to scale services created with Oracle Analytics Cloud Subscription, you must create a new service instance with the OCPUs (or users) that you want and migrate your existing content to the new service.

To scale up or scale down:

1. In Oracle Cloud Infrastructure Console, click in the top left corner.
2. Click Analytics & AI. Under Analytics, click Analytics Cloud.
3. Click Other Analytics, and then click Manage Services.
4. Note how many OCPUs your service currently uses.

   The current OCPU value is displayed on the Instances page, next to the Created On date for your service.

5. Click Manage this instance for the service you want to scale, and then click Scale Instance.

   The Scale Instance menu displays if scale options are available for your environment (see tables).

   
   Description of the illustration oaac_scale.jpg

   You can scale services listed on the Analytics Cloud Instances page.

   Services that you created with early versions of Oracle Analytics Cloud (18.2.1.xxxx or earlier) don't appear in the Instances list; you manage these services through Oracle Cloud Stack.

6. To scale up the service:
   1. For Scale Up or Down, select Increase.

      The Increase option isn’t displayed if your service currently uses the maximum number of OCPUs available for your service (see table).

   2. For Increase or Decrease OCPUs By, select how many OCPUs you want to add.

      The values available to you depend on how many OCPUs your service currently uses. Remember, you can add OCPUs only within the OCPU range of your service (see table).

      
      Description of the illustration oaac_scaleup.jpg
   3. Click Scale Instance to confirm.

      The scale-up operation takes a few minutes to complete. While in progress, the status of the service changes to Service Maintenance.

7. To scale down the service:
   1. For Scale Up or Down, select Decrease.

      The Decrease option isn’t displayed if your service currently uses the minimum number of OCPUs available (see table).

   2. For Increase or Decrease OCPUs By, select how many OCPUs you want to remove.
      The values available to you depend on the number of OCPUs your service currently uses. Remember that you can reduce the number of OCPUs only within the OCPU range of your service (see table).

      
      Description of the illustration oaac_scaledown.jpg
   3. Click Scale Instance to confirm.

      The scale-down operation takes a few minutes to complete. While in progress, the status of the service changes to Service Maintenance.

      You can't scale up or down while your service is being backed up, restored, or undergoing similar administrative operations. If you see the message System is not in a READY state. Current state is CONFIGURING, wait a few minutes for the current operation to complete and try again.

Pause and Resume a Service

You can pause a service if you want to temporarily prevent anyone accessing the service. This option is available if you subscribe to Oracle Analytics Cloud through Universal Credits.

For information about metering and billing implications when you pause a service, see Oracle PaaS and IaaS Universal Credits Service Descriptions.

Note:

The pause option isn't available if you have a fixed Oracle Analytics Cloud Subscription. With Oracle Analytics Cloud Subscription, you're billed at a constant monthly rate irrespective of usage; it's not necessary to pause these services. See About Oracle Analytics Cloud Products.

1. In Oracle Cloud Infrastructure Console, click in the top left corner.
2. Click Analytics & AI. Under Analytics, click Analytics Cloud.
3. Click Other Analytics, and then click Manage Services.
4. To temporarily pause a service:
   1. Click Manage this instance for the service you want to pause, and then click Stop.
      
      Description of the illustration oaac_pause.jpg

      You can pause and resume services listed on the Analytics Cloud Instances page.

      Services that you created with early versions of Oracle Analytics Cloud (18.2.1.xxxx or earlier) don't appear in the Instances list; you manage these services through Oracle Cloud Stack.

   2. Click OK to confirm.

      After a few minutes, the service status changes to Service Stopped.

5. To resume the service, click Manage this instance for the service you want to resume, and then click Start.

   The resume operation takes a few minutes to complete. While in progress, the status of the service changes to Service Maintenance.

   When complete, users can sign in to the service and billing resumes.

Delete a Service

You can delete services you created but don't need anymore.

1. (Business Intelligence and Data Visualization services only) Take a snapshot of your content and export the snapshot to your local system in case you want to restore the content in the future.
   See Take a Snapshot and Export a Snapshot.
2. In Oracle Cloud Infrastructure Console, click in the top left corner.
3. Click Analytics & AI. Under Analytics, click Analytics Cloud. Click Other Analytics, and then click Manage Services.

   If you subscribe through Universal Credits, your services are listed on theOracle Analytics Cloud page that is displayed.

   Note:

   If you have a fixed subscription, you create services with Oracle Analytics Cloud Subscription. To access these services, click the Profile icon in the top right corner, click Service User Console, and then click Oracle Analytics Cloud Subscription.
4. Click Manage this instance for the service you want to delete, and then click Delete.
   
   Description of the illustration oaac_delete.jpg

   Services that you created with early versions of Oracle Analytics Cloud (18.2.1.xxxx or earlier) don't appear in the Instances list. You must use Oracle Cloud Stack to delete these services.

5. Enter your administrator credentials, and then click Delete again to confirm.
   Select Force service deletion if you want to delete a service, regardless of whether there are processes running and any other warnings and messages you might see.

Delete a Service with Oracle Cloud Stack

Early versions of Oracle Analytics Cloud used Oracle Cloud Stack to create and manage services. If you want to delete a service that was created using Oracle Cloud Stack, use the Oracle Cloud Stack console to delete it.

1. Sign in to the Oracle Cloud Stack console and navigate to the Stacks page.

   See Accessing Oracle Cloud Stack.

2. Select the Manage this stack icon for the service stack you want to delete.
3. Click Delete.
4. Select Force Service Deletion.
5. Click OK.

Give a User Permission to Access Oracle Cloud Infrastructure Console

Oracle Analytics Cloud is deployed on Oracle Cloud Infrastructure (OCI). Sometimes, administrators for Oracle Analytics Cloud might need administrative access to Oracle Cloud Infrastructure Console.

1. Sign-in to your Cloud Account as Cloud Account Administrator.
2. In Oracle Cloud Infrastructure Console, add the user and assign the user to the OCI_Administrators group through Oracle Identity Cloud Service federated with your tenancy.
   1. Open the navigation menu. Click Identity & Security. Under Identity, click Federation.
   2. Click your Oracle Identity Cloud Service federation. For most tenancies, the federation is named OracleIdentityCloudService.
   3. Click Create User, enter information about the user, and click Create.
   4. To give the user administrative access to Oracle Cloud Infrastructure Console, click the name of the user you just created (on the Identity Provider Details page), and click Add to IDCS Group.
   5. Select the OCI_Administrators group.

      Users in the OCI Administrators group can access and configure services using Oracle Cloud Infrastructure Console.

3. Give the user permission to create and manage Oracle Analytics Cloud.
   See Give Another User Permission to Set Up Oracle Analytics Cloud.

The user you just added receives an email inviting them to activate their account and provide a password. When they sign in to their Cloud Account they have all the required permissions to set up Oracle Analytics Cloud and administrative access the Console for Oracle Cloud Infrastructure.

About Access Into and Out from Analytics Cloud Instances

You can manage access into and out from Oracle Analytics Cloud deployments on Oracle Cloud Infrastructure through public IP addresses.

All incoming connections access Oracle Analytics Cloud over the public internet and any connections you set up in Oracle Analytics Cloud to your data sources must be accessible through the public internet.

For example, you connect your Oracle Analytics Cloud deployment to data sources such as Oracle Autonomous Data Warehouse, Oracle Cloud databases deployed on Oracle Cloud Infrastructure, and Oracle Cloud databases deployed on Oracle Cloud Infrastructure Classic through public IPs. If you're not familiar with setting up public IP access for these data sources, use the information here as a guide.

For a complete list of the data sources that Oracle Analytics Cloud can connect to, see Supported Data Sources.

Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists

Before you try to connect Oracle Analytics Cloud to an Oracle Cloud database, ask the database administrator to add the IP address (or address range) for your Oracle Analytics Cloud instance to the target database's allowlist. The database administrator must add a security rule on the target Oracle Cloud database that allows TCP/IP traffic from Oracle Analytics Cloud on a specific database port.

This topic describes how to add Oracle Analytics Cloud to the allow list for an Oracle Cloud database. If you want to connect to other data sources, follow similar steps, as required.

1. Make a note of the IP Address or Gateway IP Address of your Oracle Analytics Cloud instance that you or your database administrator must allow access to.
   See IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances.

   Note:

   The IP Ranges and Gateway IPs are different if your Oracle Analytics Cloud environment is deployed on Oracle Cloud Infrastructure Gen 2. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).
2. Include the IP address information that you made a note of in Step 1 in the security list for your Oracle Cloud database.

   The way you register the IP address or CIDR address of your Oracle Analytics Cloud instance depends on whether the database you're trying to connect to is deployed on Oracle Cloud Infrastructure or Oracle Cloud Infrastructure Classic:

   • Database on Oracle Cloud Infrastructure
     1. Add an ingress rule.
        
        Description of the illustration uc1_securitylist.jpg
        
     2. Specify the IP address in the SOURCE CIDR field.
        
        Description of the illustration uc1_ingressrules.jpg
        
   • Database on Oracle Cloud Infrastructure Classic
     1. Add an access rule.
        Description of the illustration access_rules_ocic1-png.png
     2. Specify the IP address in the field below the Source field
        Description of the illustration access_rules_ocic2-png.png

Public IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances

If you want your Oracle Analytics Cloud to connect to an Oracle Cloud database, you must add the IP address, IP Ranges, or Gateway IPs associated with your Oracle Analytics Cloud instance to the database's allowlist.

Note:

The IP Ranges and Gateway IPs are different if your Oracle Analytics Cloud environment is deployed on Oracle Cloud Infrastructure Gen 2. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

For Oracle Analytics Cloud Instances Created After 9/8/18

If you want Oracle Analytics Cloud to connect to an Oracle Cloud database, add the IP ranges or Gateway IPs associated with the region where you deployed Oracle Analytics Cloud to your database's allowlist.

To verify the created date and region of your instance, refer to the Created On and Region values in Instance Details menu in Oracle Cloud Infrastructure Console.

Using this table, make a note of either:

• All IP addresses in the IP Ranges column for your region.

  OR

• All IP addresses in the Gateway IPs column for your region.

When deciding on whether to add IP ranges or Gateway IPs to the allowlist, choose whichever method satisfies the security policy enforced by your company or organization.

For example, if your Oracle Analytics Cloud instance is in ca-toronto-1, and your security policy requires an IP ranges, you add 192.29.9.64/26 and 192.29.13.240/28 to the allowlist. Alternatively, if your Oracle Analytics Cloud instance is in ca-toronto-1, and your security policy requires Gateway IPs, you add 192.29.9.73 and 192.29.9.106 and 192.29.13.247.

Region	IP Ranges	Gateway IPs
us-ashburn-1	130.35.100.240/28 130.35.200.160/28 147.154.18.112/28 147.154.24.0/28 147.154.26.128/27 147.154.4.160/28 147.154.7.240/28	130.35.100.247 130.35.200.170 147.154.18.118 147.154.24.13 147.154.26.144 147.154.4.164 147.154.7.253
us-phoenix-1	130.35.129.112/28 130.35.2.32/28 147.154.107.176/28 147.154.109.240/28 147.154.110.176/28 147.154.96.160/28 147.154.98.128/26	130.35.129.125 130.35.2.34 147.154.107.186 147.154.109.248 147.154.110.181 147.154.96.171 147.154.98.159
eu-frankfurt-1	138.1.64.128/28 138.1.65.0/26 138.1.66.48/28 147.154.129.32/28 147.154.138.0/24	138.1.64.139 138.1.65.32 138.1.66.60 147.154.129.37 147.154.138.198
uk-london-1	138.1.18.192/27 138.1.83.208/28 138.1.83.64/27 147.154.230.32/28	138.1.18.208 138.1.83.211 138.1.83.221 138.1.83.80 147.154.230.44
ca-toronto-1	192.29.9.64/26 192.29.13.240/28	192.29.9.73 192.29.9.106 192.29.13.247

For Oracle Analytics Cloud Instances Created Before 9/8/18

If you want Oracle Analytics Cloud to connect to an Oracle Cloud database, add the IP address of your Oracle Analytics Cloud instance to the database's allowlist.

To verify the creation date of your instance, refer to the Created On date in Oracle Cloud Infrastructure Console.

Using this table, for your region, make a note of the IP address in the IP Addresses column.

Region	IP Address
us-ashburn-1	130.35.0.0/16
us-phoenix-1	130.35.0.0/16
eu-frankfurt-1	138.1.0.0/17
uk-london-1	138.1.0.0/17

Connect to a Database Deployed on Oracle Cloud Infrastructure with a Public IP Address

Configure Oracle Analytics Cloud to connect to a database deployed on Oracle Cloud Infrastructure with a public IP address, so that end users can analyze that data in visualizations, analyses, and pixel-perfect reports.

Topics

• Typical Workflow to Connect to a Database Deployed on Oracle Cloud Infrastructure

• Prerequisites

• Record Database Information

• Enable Database Access Through Port 1521

• Connect to Your Database from Oracle Analytics Cloud

Typical Workflow to Connect to a Database Deployed on Oracle Cloud Infrastructure

If you’re connecting to an database deployment on Oracle Cloud Infrastructure for the first time, follow these tasks as a guide.

Task	Description	More Information
Verify the prerequisites	Verify that your environment satisfies the prerequisites required for this configuration.	Prerequisites
Record database information	Record connection information for database.	Record Database Information
Enable database access	Add an ingress rule to give Oracle Analytics Cloud access to the database.	Enable Database Access Through Port 1521
Connect to the database	Create and test your connections.	Connect to Your Database from Oracle Analytics Cloud

Prerequisites

Before you start, make sure you have the required environment.

Step	Description	Important Information to Note
Set up Oracle Analytics Cloud	Deploy Oracle Analytics Cloud.	Region Availability Domain
Set up a Virtual Cloud Network (VCN) on Oracle Cloud Infrastructure	Set up a VCN for the database deployment on Oracle Cloud Infrastructure. Note: The VCN must be in the same Region and Availability Domain as Oracle Analytics Cloud.	Virtual Cloud Network Subnet Same: Region Availability Domain
Deploy a database: Deploy the database on the VCN in Oracle Cloud Infrastructure Populate the database with data Set up a database user with permissions to read database tables	Deploy a database on the VCN in Oracle Cloud Infrastructure. Note: The database must be in the same Region and Availability Domain as the VCN.	Public IP Database Unique Name Host Domain Name Database User/Password Same: Region Availability Domain Virtual Cloud Network Client Subnet

Record Database Information

All the information you need to connect to a database is available in the Oracle Cloud Infrastructure Console. Record the information now, so you have the required details when you set up the connection in Oracle Analytics Cloud.

1. In Oracle Cloud Infrastructure Console, click in the top left corner.
2. Click Databases. Under MySQL, click DB Systems.
3. Locate the database you want to connect to and record the Public IP address.
   
   Description of the illustration uc1_databases.jpg
   
4. Click the name of the database you want to connect to and write down the values in these fields: Database Unique Name, Host Domain Name, Virtual Cloud Network, Client Subnet, and Port.
   
   Description of the illustration uc1_database.jpg
   
5. Find out the user name and password of a database user with permissions to read from this database, and write them down as you need these later. For example, the user SYSTEM.

Enable Database Access Through Port 1521

Add an ingress rule that enables Oracle Analytics Cloud to access the database through port 1521.

1. Make a note of the Oracle Analytics Cloud IP addresses that you want to allow access to.
   See IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances.
2. In Oracle Cloud Infrastructure Console, click in the top left corner, and click Databases. Under MySQL, click DB Systems.
3. Click the database that you want to connect to.
4. Click the Virtual Cloud Network link.
   
   Description of the illustration uc1_database_vcn.jpg
   
5. Navigate to the appropriate subnet, and under Security Lists, click Default Security List For <VCN>.
   
   Description of the illustration uc1_vnc.jpg
   
6. Click Add Ingress Rules.
   
   Description of the illustration uc1_securitylist.jpg
   
7. For each IP address that you want to give access to, add an ingress rule to allow any incoming traffic from the public internet to reach port 1521 on this database node, with the following settings:

   • SOURCE CIDR: Enter the IP address that you wrote down in Step 1.

   • IP PROTOCOL: TCP

   • SOURCE PORT RANGE: All

   • DESTINATION PORT RANGE: 1521

   • Allows: TCP traffic for ports: 1521

   
   
   Description of the illustration uc1_ingressrules.jpg
   

Connect to Your Database from Oracle Analytics Cloud

After enabling access to the database, use the database connection information you wrote down earlier to connect Oracle Analytics Cloud to the database. The way you connect to the database depends on what you want to do with the data.

• Visualize the data.

• Model the data using Semantic Modeler or Data Modeler, then generate analyses and dashboards.

• Model the data with Oracle Analytics Cloud Model Administration Tool, then generate analyses and dashboards.

• Publish the data in pixel-perfect reports.

Connect to Your Database for Data Visualization or Semantic Modeler

In Oracle Analytics Cloud, create an Oracle Database connection for data visualizations in the usual way. See Create Database Connections.

Description of the illustration uc1_conns.png

Use the database details you recorded earlier to fill in the Create Connection dialog.

Description of the illustration uc1_cconnection.png

Specify these values:

• New Connection Name: A name for the database you want to connect to.

• Host: The Public IP address for the database instance. For example, 123.213.85.123.

• Port: The port number that enables access to the database. For example, 1521.

• Username: The name of a user with read access to the database.

• Password: The password for the specified database user.

• Service Name: A concatenated name comprising Database Unique Name and Host Domain Name, separated with a period. For example, CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com.

Connect to Your Database for Data Modeler

In Oracle Analytics Cloud Console, create a connection in the usual way. See Connect to Data in an Oracle Cloud Database.

Use the database details you recorded earlier to fill in the Create Connection dialog.

Description of the illustration uc1_console1.jpg

Specify these values:

• Name and Description: A name for the database you want to connect to.

• Connect using: Select Host, Port, and Service Name.

• Host: The Public IP address for the database. For example, 123.213.85.123.

• Port: The port number that enables access to the database. For example, 1521.

• Service Name: A concatenated name comprising Database Unique Name and Host Domain Name, separated with a period. For example, CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com.

• Connect as: The name of a user with read access to the database.

• Password: The password for the specified database user.

Connect to Your Database in Model Administration Tool

In Model Administration Tool for Oracle Analytics Cloud, click File, then Open, then In the Cloud to open your semantic model. See Edit a Semantic Model in the Cloud.

When you sign in, use connection information for your Oracle Analytics Cloud to fill in the Open in the Cloud dialog.

Create a connection pool for your database. In the Physical pane, expand the DBaaS node, right-click the database icon, and click Properties to display the Connection Pool dialog. Use the database details you recorded earlier to specify Call Interface, Data Source Name, User Name, and Password.

Description of the illustration connpool-gif.gif

Specify these values:

• Call interface: Select Default (Oracle Call Interface (OCI)).

• Data Source Name: Specify the connection details. For example:

  (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=129.213.85.177)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com))

  For SERVICE_NAME, specify the concatenated Database Unique Name and Host Domain Name separated by a period, for example, db1_phx1tv.mycompany.com. To find both these names in Oracle Cloud Infrastructure Console, click Databases, under MySQL click DB Systems, and then click the name of your database.

Connect to Oracle Autonomous Data Warehouse with a Public IP Address

Configure Oracle Analytics Cloud to connect to Autonomous Data Warehouse over a public IP address so that end users can analyze that data in visualizations, analyses, dashboards, and pixel-perfect reports.

Topics

• Typical Workflow to Connect to Oracle Autonomous Data Warehouse with a Public IP Address

• Prerequisites

• Enable Access to Oracle Autonomous Data Warehouse

• Connect to Oracle Autonomous Data Warehouse

Typical Workflow to Connect to Oracle Autonomous Data Warehouse with a Public IP Address

If you’re connecting Oracle Analytics Cloud to Autonomous Data Warehouse over a public IP address for the first time, follow these tasks as a guide.

Task	Description	More Information
Verify the prerequisites	Verify that your environment satisfies the prerequisites required for this configuration.	Prerequisites
Enable access to Autonomous Data Warehouse	Upload your Autonomous Data Warehouse Client Credentials file (wallet file) to Oracle Analytics Cloud.	Enable Access to Oracle Autonomous Data Warehouse
Connect to Autonomous Data Warehouse	Create and test your connections.	Connect to Oracle Autonomous Data Warehouse

Prerequisites

Before you start, make sure you have the required environment.

Step	Description	Important Information to Note
Set up Oracle Analytics Cloud	Deploy Oracle Analytics Cloud.	Region Availability Domain
Set up Oracle Autonomous Data Warehouse	Deploy Autonomous Data Warehouse. Deploy Autonomous Data Warehouse on Oracle Cloud Infrastructure. Populate Autonomous Data Warehouse with data. Set up a database user with permissions to read database tables on Autonomous Data Warehouse	Host Name Port Number Service Name (Obtain these details from tnsnames.ora in the Autonomous Data Warehouse Client Credentials file.)

Enable Access to Oracle Autonomous Data Warehouse

To enable secure communication between Oracle Analytics Cloud and Autonomous Data Warehouse, you upload trusted SSL certificates to Oracle Analytics Cloud.

1. In Autonomous Data Warehouse Console, obtain the Client Credentials file.
   The Client Credentials file is a ZIP file containing the files cwallet.sso and tnsnames.ora. See Download Client Credentials (Wallets) in Using Oracle Autonomous Data Warehouse.
2. Extract the cwallet.sso file from the Client Credentials file.
3. Upload the cwallet.sso file to Oracle Analytics Cloud.
   1. Sign in to Oracle Analytics Cloud, open the Console and click Connections.
   2. Click Upload Wallet to upload a wallet for the first time or Replace Wallet to update an existing wallet.
   3. Click Browse and locate the wallet file (cwallet.sso) you downloaded from Autonomous Data Warehouse.
   4. Select the file and click Open.
   5. Click Update and OK to update the existing wallet file.

Connect to Oracle Autonomous Data Warehouse

After enabling access to Oracle Autonomous Data Warehouse, use the connection details you recorded earlier to connect Oracle Analytics Cloud to Autonomous Data Warehouse. The way you connect depends on what you want to do with the data.

• Visualize the data

• Model the data using Semantic Modeler or Data Modeler, then generate analyses and dashboards.

• Model the data with Oracle Analytics Model Administration Tool, then generate analyses and dashboards.

• Publish the data in pixel-perfect reports.

Connect to Autonomous Data Warehouse for Data Visualization or Semantic Modeler

In Oracle Analytics Cloud, create an Autonomous Data Warehouse connection for data visualization. See Create Connections to Oracle Autonomous Data Warehouse.

Description of the illustration uc6_connectionadwc-gif.png

Now create a new workbook and dataset to visualize data from your Autonomous Data Warehouse.

Connect to Autonomous Data Warehouse for Data Modeler

In Oracle Analytics Cloud Console, create a connection in the usual way. See Connect to Data in an Oracle Cloud Database.

Use the database details you recorded earlier to fill in the Create Connection dialog.

Description of the illustration uc6_conn_console-gif.jpg

Specify these values:

• Name and Description: A short name and description to identify this connection in Oracle Analytics Cloud.

• Connect Using: Select Host, Port, and Service Name.

• Host: The host name of the Autonomous Data Warehouse instance that you obtained from the downloaded tnsnames.ora file. For example, adwc.example.oraclecloud.com.

• Port: The port number that you obtained from the downloaded tnsnames.ora file. For example, 1522.

• Service Name: The service name that you obtained from the downloaded tnsnames.ora file. For example, adwc1_high.adwc.oraclecloud.com.

• Connect as: The name of a user with read access to Autonomous Data Warehouse. For example, ADMIN.

• Password: The password for the specified database user.

• Enable SSL: Select this option.

In Data Modeler, you can now model data from your Autonomous Data Warehouse using this connection.

Connect to Autonomous Data Warehouse in Model Administration Tool

You can use Model Administration Tool for Oracle Analytics Cloud to edit a semantic model connected to Autonomous Data Warehouse.

1. On the machine where you installed Oracle Analytics Cloud Client Tools, copy the cwallet.sso, sqlnet.ora, and tnsnames.ora from the zip file that you downloaded from Autonomous Data Warehouse to the folder:
   <Developer Client Tool installation folder>\domains\bi\config\fmwconfig\bienv\core
   
   Description of the illustration uc6_admintool-gif.gif
2. Edit sqlnet.ora so that the wallet location points to:
   <Developer Client Tool installation folder>\domains\bi\config\fmwconfig\bienv\core
   For example:
   WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="C:\ade\admintoolOAC18.2.1\domains\bi\config\fmwconfig\bienv\core"))) SSL_SERVER_DN_MATCH=yes
3. In Model Administration Tool, click File, then Open, then In the Cloud to open your semantic model. See Edit a Semantic Model in the Cloud.
   When you log in, use the connection information for your Oracle Analytics Cloud instance to fill in the Open in the Cloud dialog.

   • For Port, specify 443.

   • For Host name, specify the host domain name of your Oracle Analytics Cloud instance.

   • Select SSL. For Trust Store and Password, point to a local JDK/JRE cacerts keystore that trusts certificates signed by well-known CAs.

4. Connect to Autonomous Data Warehouse.
   1. Click File, then Import Metadata to start the Import Metadata wizard, and follow the on-screen instructions.
      Description of the illustration uc6_imp_md-gif.gif
   2. On the Select Data Source page, for the Data Source Name value, specify a long TNS connection string from the downloaded tnsnames.ora file. Include the entire description, enclosed in brackets.

      For example:

      (description=(address=(protocol=tcps)(port=1522)(host=adwc.example.oraclecloud.com))(connect_data=(service_name=adwc1_high.adwc.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.example.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) )

   3. For User Name and Password, enter the credentials for the ADMIN user or another suitable Autonomous Data Warehouse user.

You’re now ready to model the data in Model Administration Tool, publish the semantic model to Oracle Analytics Cloud, and create analyses and data visualizations using data from Autonomous Data Warehouse.

Connect to a Database Deployed on Oracle Cloud Infrastructure Classic with a Public IP Address

Configure Oracle Analytics Cloud to connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure Classic so that end users can analyze that data in visualizations, analyses, and pixel-perfect reports.

Topics

• Typical Workflow to Connect to a Database Deployed on Oracle Cloud Infrastructure Classic

• Prerequisites

• Record Database Information

• Enable Database Access Through Port 1521

• Connect to Your Database from Oracle Analytics Cloud

Typical Workflow to Connect to a Database Deployed on Oracle Cloud Infrastructure Classic

If you’re connecting Oracle Analytics Cloud to a database deployed on Oracle Cloud Infrastructure Classic for the first time, follow these tasks as a guide.

Task	Description	More Information
Verify the prerequisites	Verify that your environment satisfies the prerequisites required for this configuration.	Prerequisites
Record database information	Record connection information for Oracle Database Classic Cloud Service.	Record Database Information
Enable database access	Add access rules to enable Oracle Analytics Cloud access to the database.	Enable Database Access Through Port 1521
Connect to the database	Create and test your connections.	Connect to Your Database from Oracle Analytics Cloud

Prerequisites

Before you start, make sure you have the required environment.

Step	Description	Note Important Information
Set up Oracle Analytics Cloud	Deploy Oracle Analytics Cloud.	Region Availability Domain
Deploy Oracle Database Classic Cloud Service Deploy Oracle Database Classic Cloud Service on the Virtual Cloud Network in Oracle Cloud Infrastructure Classic. Populate Oracle Database Classic Cloud Service with data. Set up a database user with permissions to read database tables.	Deploy Oracle Database Classic Cloud Service on the Virtual Cloud Network in Oracle Cloud Infrastructure Classic.	Public IP Service Name Host Domain Name Database User/Password Same: Region

Record Database Information

All the information you need to connect to Oracle Database Classic Cloud Service is available in Oracle Cloud Infrastructure Console. Record the information now, so you have the required details when you set up the connection in Oracle Analytics Cloud.

1. In Oracle Cloud Infrastructure Console, click in the top left corner.
2. Click OCI Classic Services. Under Classic Data Management Services, click Database Classic.
3. Click the name of the database you want to connect to and from the Instance Overview section, record the Service Name from the Connect String. For example, ucmdb906:1521/PDB1.504988564.oraclecloud.internal.
4. Extract and record the Service Name of the database from the connect string value. For example, PDB1.504988564.oraclecloud.internal.
5. Record the IP address of the database displayed in the Resources section.
6. Find out the user name and password of a database user with permissions to read from this database, and write them down.  For example, the user SYSTEM.

Enable Database Access Through Port 1521

Add an access rule that enables Oracle Analytics Cloud to access the database through port 1521.

1. In Oracle Cloud Infrastructure Console, click in the top left corner.
2. Click OCI Classic Services. Under Classic Data Management Services, click Database Classic.
3. Select the database you want to connect to.
4. Click the Manage service icon and select Access Rules.
5. For port 1521, click Actions and select Enable to enable the port for the default Oracle listener.
   
   Description of the illustration enable1521.png

Connect to Your Database from Oracle Analytics Cloud

After enabling access to the database, use the database connection information you recorded earlier to connect Oracle Analytics Cloud to the database deployed in Oracle Cloud Infrastructure Classic. The way you connect to the database depends on what you want to do with the data.

• Visualize the data.

• Model the data using Semantic Modeler or Data Modeler, then generate analyses and dashboards.

• Model the data with Oracle Analytics Model Administration Tool, then generate analyses and dashboards.

Connect to Your Database for Data Visualization or Semantic Modeler

In Oracle Analytics Cloud, create an Oracle Database connection for data visualizations in the usual way. See Create Database Connections.

Description of the illustration classicdb1.png

Use the database details you recorded earlier to fill in the Create Connection dialog.

Description of the illustration classicdb2.png

Specify these values:

• Connection Name: The name of the Oracle Database Classic Cloud Service you want to connect to.

• Host: The Public IP address for Oracle Database Classic Cloud Service. For example, 123.213.85.123.

• Port: The port number that enables access to Oracle Database Classic Cloud Service. For example, 1521.

• Username: The name of a user with read access to Oracle Database Classic Cloud Service.

• Password: The password for the specified database user.

• Service Name: The service name on the Database Classic page. For example, PDB1.123456789.oraclecloud.internal.

Connect to Your Database for Data Modeler

In Oracle Analytics Cloud Console, create a connection in the usual way. See Connect to Data in an Oracle Cloud Database.

Use the database details you recorded earlier to fill in the Create Connection dialog.

Description of the illustration classicdb3.png

Specify these values:

• Name and Description: The name of the Oracle Database Classic Cloud Service you want to connect to.

• Connect Using: Select Host, Port, and Service Name.

• Host: The Public IP address for Oracle Database Classic Cloud Service. For example, 123.213.85.123.

• Port: The port number that enables access to Oracle Database Classic Cloud Service. For example, 1521.

• Service Name: The service name from the Database Classic page. For example, PDB1.123456789.oraclecloud.internal.

• Connect as: The name of a user with read access to Oracle Database Classic Cloud Service.

• Password: The password for the specified database user.

Connect to Your Database in Oracle Analytics Model Administration Tool

In Model Administration tool for Oracle Analytics Cloud, click File, Open, and then In the Cloud to open your semantic model in the usual way. See Edit a Semantic Model in the Cloud.

When you sign in, use connection information for your Oracle Analytics Cloud to fill in the Open in the Cloud dialog.

Create a connection pool for your database. In the Physical pane, expand the database node, right-click the database icon, and click Properties to display the Connection Pool dialog. Use the database details you recorded earlier to specify Call Interface, Data Source Name, User Name, and Password.

Description of the illustration connpool-gif.gif

Specify these values:

• Call interface: Select Default (Oracle Call Interface (OCI).

• Data Source Name: Specify the connection details. For example:

  (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=123.213.85.123)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PDB1.587075508.oraclecloud.internal))

  For SERVICE_NAME, use the Database Classic page to locate the service name. For example, PDB1.587075508.oraclecloud.internal.

You’re now ready to model the data in Model Administration Tool, publish the semantic model to Oracle Analytics Cloud, and create analyses and data visualizations using data from Oracle Database Classic Cloud Service.