3 Administer Services with Oracle Analytics Cloud

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

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

Whitelist 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, whitelist the IP addresses for any Oracle Analytics Cloud instances you want to connect to.

Configure a Database on Oracle Cloud to Accept Connections from Oracle Analytics Cloud

Whitelist your Oracle Analytics Cloud instance in your Oracle Cloud database Configure your Oracle Cloud database to accept connections from Oracle Analytics Cloud. Configure a Database on Oracle Cloud to Accept Connections from Oracle Analytics Cloud
Connect to Oracle Database Cloud Service deployed on Oracle Cloud Infrastructure

Connect to Oracle Database 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 Cloud Service deployed on Oracle Cloud Infrastructure Classic Connect to Oracle Database 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

    Preparing Data in 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.

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 (ServiceAdminsitrator, ServiceUser, ServiceViewer) that map to a set of predefined application roles in Oracle Analytics Cloud.

Description of app-roles.jpg follows
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 an administrator, you can grant application roles to users with Oracle Identity Cloud Service.

  1. Sign in to your Oracle Cloud account.
  2. In Oracle Cloud Infrastructure Console, click Navigation menu icon Navigation menu icon in the top left corner.
  3. Under More Oracle Cloud Services, go to Platform Services, and click Analytics.

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

    If you have a fixed subscription, you create services with Oracle Analytics Cloud Subscription. To access these services, click the Navigation menu icon Navigation menu icon again, and then click Analytics Subscription.

  4. On the Instances page, click the name of the service you want to manage.
  5. On the Instance Overview page, click the name of the IDCS Application that is associated with this Oracle Analytics Cloud instance.
  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 whitelisting 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

Preparing Data in 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

Oracle Analytics Cloud - Classic deployed on Oracle Cloud Infrastructure Classic

Oracle Business Intelligence Cloud Service

Oracle Data Visualization Cloud Service

Oracle BI Enterprise Edition 12c

Oracle BI Enterprise Edition 11g

Oracle Essbase

Scale a Service

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

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 Navigation menu icon Navigation menu icon in the top left corner.
  2. Under More Oracle Cloud Services, go to Platform Services, and click Analytics.
  3. 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.

  4. 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).

    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.

  5. 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).

    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.

  6. 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).
    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 Navigation menu icon Navigation menu icon in the top left corner.
  2. Under More Oracle Cloud Services, go to Platform Services, and click Analytics.
  3. To temporarily pause a service:
    1. Click Manage this instance for the service you want to pause, and then click Stop.

      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.

  4. 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 download the snapshot to your local system in case you want to restore the content in the future.
  2. In Oracle Cloud Infrastructure Console, click Navigation menu icon Navigation menu icon in the top left corner.
  3. Under More Oracle Cloud Services, go to Platform Services, and click Analytics.

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

    If you have a fixed subscription, you create services with Oracle Analytics Cloud Subscription. To access these services, click the Navigation menu icon Navigation menu icon again, and then click Analytics Subscription.

  4. Click Manage this instance for the service you want to delete, and then click Delete.

    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.
  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. Under Governance and Administration, go to Identity and click Federation.
    2. Click your Oracle Identity Cloud Service federation. For most tenancies, the federation is named OracleIdentityCloudService.
    3. Click Create IDCS 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.

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.

Manage Access to Oracle Analytics Cloud

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 can connect to data sources such as Oracle Autonomous Data Warehouse, and Oracle Cloud databases deployed on Oracle Cloud Infrastructure or 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 all the data sources that Oracle Analytics Cloud can connect to, see Supported Data Sources.

Configure a Database on Oracle Cloud to Accept Connections from Oracle Analytics Cloud

If you want your Oracle Analytics Cloud instance to connect to database on Oracle Cloud, you must ensure that the database instance has a public IP address and is configured to accept connections from your Oracle Analytics Cloud instance.

Before you try to connect, ask the database administrator to whitelist the IP address (or addresses) for the region where your Oracle Analytics Cloud instance is deployed. The database administrator must add a security rule on the target Oracle Cloud database that allows TCP/IP traffic from this region on a specific database port.
  1. Make a note of the IP address (or addresses) of your Oracle Analytics Cloud instance that you or your database administrator must whitelist.
  2. In your database on Oracle Cloud, whitelist the IP addresses that you made a note of in Step 1.

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

IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances

If you want to connect to an Oracle Database Cloud Service instance, you whitelist the IP address, IP Ranges, or Gateway IPs for your Oracle Analytics Cloud instance.

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

If you want to connect to Oracle Database Cloud Service, you whitelist the IP Ranges or Gateway IPs of the Region where your Oracle Analytics Cloud instance is located.

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 whitelist IP Ranges or Gateway IPs, 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 you want to whitelist IP Ranges, you whitelist 192.29.9.64/26 and 192.29.13.240/28. Alternatively, if your Oracle Analytics Cloud instance is in ca-toronto-1, and you want to whitelist Gateway IPs, you whitelist 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 to connect to an Oracle Database Cloud Service instance, you whitelist the IP Address of your Oracle Analytics Cloud instance.

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 BI Publisher reports.

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 Note Important Information

Set up Oracle Analytics Cloud

Deploy Oracle Analytics Cloud.

Region

Availability Domain

Set up a VCN on Oracle Cloud Infrastructure

Set up a Virtual Cloud Network (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 system

  • Deploy DB systemOracle Database Cloud Service on the Virtual Cloud Network in Oracle Cloud Infrastructure

  • Populate the database with data

  • Set up a database user with permissions to read database tables

Deploy a DB system on the Virtual Cloud Network 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 the navigation icon Hamburger icon for toggling navigation options.
  2. Under Database, click Bare Metal, VM, and Exadata, and then click DB Systems.
  3. Locate the database you want to connect to and record the Public IP address.
    Description of uc1_databases.jpg follows
    Description of the illustration uc1_databases.jpg
  4. Click the name of the database you want to connect to and record the values in these fields: Database Unique Name, Host Domain Name, Virtual Cloud Network, Client Subnet, and Port.
    Description of uc1_database.jpg follows
    Description of the illustration uc1_database.jpg
  5. Find out the username and password of a database user with permissions to read from this database, and make a note of these. 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 IP addresses that you have to whitelist for your Oracle Analytics Cloud instance. See IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances.
  2. In the Oracle Cloud Infrastructure home page, click the navigation icon Hamburger icon for toggling navigation options, then under Databases, click Bare Metal, VM, and Exadata, and then DB Systems.
  3. Click the database that you want to connect to.
  4. Click the Virtual Cloud Network link.
    Description of uc1_database_vcn.jpg follows
    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 uc1_vnc.jpg follows
    Description of the illustration uc1_vnc.jpg
    The Security List page is displayed.
  6. Click Add Ingress Rules.
    Description of uc1_securitylist.jpg follows
    Description of the illustration uc1_securitylist.jpg
  7. For each IP address that you have to whitelist, 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 noted down in Step 1.

    • IP PROTOCOL: TCP

    • SOURCE PORT RANGE: All

    • DESTINATION PORT RANGE: 1521

    • Allows: TCP traffic for ports: 1521

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. The way you connect to the database depends on what you want to do with the data.

  • Visualize the data.

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

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

  • Publish the data in pixel perfect reports.

Connect to Your Database for Data Visualization
In Oracle Analytics Cloud, create an Oracle Database connection for data visualizations in the usual way. See Create Database Connections.
Use the database details you recorded earlier to fill in the Create Connection dialog.
Specify these values:
  • New Connection Name: Any name to identify the database you want to connect to.

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

  • Port: 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: Concatenate Database Unique Name and Host Domain Name and separate the values 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 New Connection dialog.
Specify these values:
  • Name and Description: Any name to identify 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: Port number that enables access to the database. For example, 1521.

  • Service Name: Concatenate Database Unique Name and Host Domain Name and separate the values 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 Oracle Analytics Cloud Developer Client Tool
In Oracle Analytics Cloud Developer Client tool, click File, then Open, then In the Cloud to open your data model. See Edit a Data 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 connpool-gif.bmp follows
Description of the illustration connpool-gif.bmp

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, Bare Metal, VM, and Exadata, 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.

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 Note Important Information

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 Cloud.
  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 using Data Visualization.

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

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

  • Publish the data in pixel perfect reports.

Connect to Autonomous Data Warehouse for Data Visualization
In Oracle Analytics Cloud, create an Autonomous Data Warehouse connection for data visualization. See Create Connections to Oracle Autonomous Data Warehouse Cloud.
Create Connection dialog.
In Data Visualization, you can now create a new project and data set 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 New Connection dialog.
Specify these values:
  • Name and Description: Specify a short name and description to identify this connection in Oracle Analytics Cloud.

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

  • Host: The hostname 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 Oracle Analytics Cloud Developer Client Tool
You can use Oracle Analytics Cloud Client Tool to edit a data model connected to Autonomous Data Warehouse.
  1. On the machine where you installed Oracle Analytics Cloud Developer Client Tool, 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
  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 Oracle Analytics Cloud Developer Client tool, click File, then Open, then In the Cloud to open your data model. See Edit a Data Model in the Cloud.
    When you log in, use connection information for your Oracle Analytics Cloud 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 Cloud.
    1. Click File, then Import Metadata to start the Import Metadata wizard, and follow the on-screen instructions.Description of uc6_imp_md-gif.gif follows
      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 suitably provisioned Autonomous Data Warehouse Cloud user.
You’re now ready to model the data in Oracle Analytics Cloud Developer Client Tool, publish the data 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 Cloud Service deployed on Oracle Cloud Infrastructure Classic so that end users can analyze that data in visualizations, analyses, and BI Publisher reports.

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 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 Cloud Service

  • Deploy Oracle Database Cloud Service on the Virtual Cloud Network in Oracle Cloud Infrastructure Classic.

  • Populate Oracle Database Cloud Service with data.
  • Set up a database user with permissions to read database tables.

Deploy Oracle Database 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 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 Navigation menu icon Navigation menu icon in the top left corner.
  2. Under More Oracle Cloud Services, go to Classic Data Management Services, and 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 make a note of these.  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 Navigation menu icon Navigation menu icon in the top left corner.
  2. Under More Oracle Cloud Services, go to Classic Data Management Services, and 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.
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 using Data Visualization.

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

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

Connect to Your Database for Data Visualization
In Oracle Analytics Cloud, create an Oracle Database connection for data visualizations in the usual way. See Create Database Connections.
Use the database details you recorded earlier to fill in the Create Connection dialog.
Specify these values:
  • Connection Name: Any name to identify the Oracle Database Cloud Service you want to connect to.

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

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

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

  • Password: The password for the specified database user.

  • Service Name: Use the Database Classic page to locate the service name. For example, PDB1.587075508.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.
Specify these values:
  • Name and Description: Any name to identify the Oracle Database Cloud Service you want to connect to.

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

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

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

  • Service Name: Use the Database Classic page to locate the service name. For example, PDB1.587075508.oraclecloud.internal. For example, PDB1.587075508.oraclecloud.internal.

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

  • Password: The password for the specified database user.

Connect to Your Database in Oracle Analytics Cloud Developer Client Tool
In Oracle Analytics Cloud Developer Client tool, click File, Open, and then In the Cloud to open your data model in the usual way. See Edit a Data 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 connpool-gif.bmp follows
Description of the illustration connpool-gif.bmp

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 Oracle Analytics Cloud Developer Client Tool, publish the data model to Oracle Analytics Cloud, and create analyses and data visualizations using data from Autonomous Data Warehouse.