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 Up or Down

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 Your Database 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 Your Database 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 Oracle Database Cloud Service Deployed on Oracle Cloud Infrastructure
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 Oracle Database Cloud Service Deployed on Oracle Cloud Infrastructure Classic
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. In My Services, open the dashboard.
  2. Navigate to the Analytics tile (or Analytics Subscription), click Action Menu, and then select Open Service Console.
  3. On the Instances page, click the name of the instance you want to manage.
  4. On the Instance Overview page, click the name of the IDCS Application that is associated with this Oracle Analytics Cloud instance.
  5. On the Oracle Identity Cloud Service application page, click Application Roles.
  6. Select an application role, and click the Menu for the specific role.
  7. From the menu list, select Assign Users.
  8. 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 BI Enterprise Edition 12c

Oracle BI Enterprise Edition 11g

Oracle Essbase

Scale Up or Down

Not Oracle Analytics Cloud – EssbaseThis topic does not apply to Oracle Analytics Cloud – Essbase.

If a service you deployed with business intelligence or data visualization features 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.

Users don't experience any downtime when you scale a service up or down; your service stays up and running.

You can scale only within the OCPU range available to your service. 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? (Incremental + increase) Scale Down within Range? (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

To scale up or scale down:

  1. In My Services, open the dashboard.
  2. Navigate to the Analytics tile, click Action Menu, and then select Open Service Console.
    You can't scale services that you create with Analytics Subscription.
  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.

    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 OCPUs.

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

    2. For Number of OCPUs, 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 OCPUs.

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

    2. For Number of OCPUs, 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 for a few minute for the current operation to complete and try again.

Pause and Resume a Service

Pause a service if you want to temporarily prevent anyone accessing the service.

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

Note:

You can pause and resume services that you create with Oracle Analytics Cloud. Services you create with Oracle Analytics Subscription are billed at a constant monthly rate irrespective of usage; it's not necessary to pause or resume these services. See About Oracle Analytics Cloud Products.
  1. In My Services, open the dashboard.
  2. Navigate to the Analytics tile, click Action Menu, and then select Open Service Console.
  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 My Services, open the dashboard.
  3. Navigate to the Analytics tile (or Analytics Subscription), click Action Menu, and then select Open Service Console.
  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. In My Services, open the dashboard.
  2. Click the Navigation menu, and select Cloud Stack.
  3. Select the Manage this stack icon for the service stack you want to delete.
  4. Click Delete.
  5. Select Force Service Deletion.
  6. 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 access to Oracle Cloud Infrastructure Console.

  1. In My Services, open the dashboard.
  2. Add a user in Identity Cloud, and assign them the required permissions for Oracle Cloud Infrastructure.
    You must give the user access to the Oracle Cloud Infrastructure Console (OCI Integration) and add the user to the OCI_Administrators group.
    1. Click Users.
    2. Click Identity Console.
    3. Click Add and enter details about the user.
    4. Click Access, click Assign Applications, and then select OCI Integration.

      OCI Integration enables you to navigate from My Services dashboard to the Oracle Cloud Infrastructure Console. With this permission, if you navigate to the Compute service, click the Action Menu, and select Open Service Console, you can access theOracle Cloud Infrastructure Console.

    5. Click Groups, click Assign Groups, and then select OCI_Administrators.

      Users in the OCI Administrators group can configure options using Oracle Cloud Infrastructure Console.

  3. Add the same user, as a local user in Oracle Cloud Infrastructure, and assign them to the Administrators group in Oracle Cloud Infrastructure.
    1. In My Services, open the dashboard.
    2. Navigate to the Compute service, click the Action Menu, and then select Open Service Console.

      The Oracle Cloud Infrastructure home page is displayed.

    3. Click the navigation menu Navigation menu , and then click Users.
    4. Click Create User and enter the same user information that you entered in My Services.
    5. Click Groups, click Administrators, and then click Add User to Group.
    6. Select the user you just added, and click Add.
  4. Give the user permission to create and manage Oracle Cloud services in My Services (including Oracle Analytics Cloud).
    1. Navigate to your My Services dashboard.
    2. Click Users, and then click the name of the user you added.
    3. Click Roles, and then click Add Admin Roles.

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

Manage Access to Oracle Analytics Cloud

You manage access into and out from Oracle Analytics Cloud 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 Oracle Autonomous Data Warehouse, and Oracle Cloud databases deployed on Oracle Cloud Infrastructure and 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 too, see Supported Data Sources.

Configure Your Database to Accept Connections from Oracle Analytics Cloud

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

Before you 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 adds security rules on the Oracle Database Cloud Service target that allows TCP/IP traffic from the region on a specific database port. The database administrator needs to know your service version and when your instance was created. To check this information, review your Oracle Analytics Cloud instance details in My Services.
  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 your Oracle Database Cloud Service instance, whitelist the IP addresses that you made a note of in Step 1.

    The way you whitelist the CIDR address or IP address of your OAC depends on 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 Service Details Menu in My Services.

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 Gateway IPs, you whitelist 192.29.9.73 and 192.29.9.106.

Region IP Ranges Gateway IPs
us-ashburn-1

130.35.0.0/16 (To be retired from service on 5/23/19)

130.35.200.160/28

147.154.26.128/27

147.154.7.240/28

147.154.18.112/28

147.154.4.160/28

147.154.24.0/28

130.35.77.108 (To be retired from service on 5/23/19)

130.35.50.107 (To be retired from service on 5/23/19)

130.35.212.131 (To be retired from service on 5/23/19)

147.154.26.144

130.35.200.170

147.154.7.253

147.154.18.118

147.154.4.164

147.154.24.13

us-phoenix-1

130.35.128.0/17 (To be retired from service on 5/23/19)

138.1.128.0/17 (To be retired from service on 5/23/19)

130.35.129.112/28

147.154.109.240/28

147.154.96.160/28

147.154.107.176/28

147.154.98.128/26

147.154.110.176/28

138.1.152.88 (To be retired from service on 5/23/19)

130.35.241.50 (To be retired from service on 5/23/19)

138.1.141.63 (To be retired from service on 5/23/19)

147.154.109.248

130.35.129.125

147.154.96.171

147.154.107.186

147.154.98.159

147.154.110.181

eu-frankfurt-1

138.1.128.0/17 (To be retired from service on 5/23/19)

147.154.129.32/28

147.154.138.0/24

138.1.65.0/26

138.1.64.128/28

138.1.182.148 (To be retired from service on 5/23/19)

138.1.163.12 (To be retired from service on 5/23/19)

138.1.202.36 (To be retired from service on 5/23/19)

147.154.129.37

147.154.138.198

138.1.65.32

138.1.64.139

uk-london-1

138.1.0.0/17 (To be retired from service on 5/23/19)

138.1.223.0/25 (To be retired from service on 5/23/19)

138.1.83.64/27

147.154.230.32/28

138.1.83.208/28

138.1.223.86 (To be retired from service on 5/23/19)

138.1.94.24 (To be retired from service on 5/23/19)

138.1.91.169 (To be retired from service on 5/23/19)

138.1.83.221

138.1.83.80

147.154.230.44

138.1.83.211

ca-toronto-1 192.29.9.64/26

192.29.9.73

192.29.9.106

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 value in My Services.

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 Oracle Database Cloud Service Deployed on Oracle Cloud Infrastructure

Configure Oracle Analytics Cloud to connect to Oracle Database Cloud Service 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 Oracle Database Cloud Service 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 Oracle Database Cloud Service.

Record Database Information

Enable database access

Add an ingress rule 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

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

Client Subnet

Same:

  • Region

  • Availability Domain

Deploy Oracle Database Cloud Service

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

  • 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.

Note: Oracle Database Cloud Service 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 Oracle Database Cloud Service 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 My Services, open the dashboard.
  2. Navigate to the Oracle Cloud Infrastructure Console. Do one of the following:
    The Oracle Cloud Infrastructure home page is displayed.
  3. Click the navigation icon Hamburger icon for toggling navigation options, then under Databases click DB Systems.
  4. 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
  5. 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
  6. 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 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 <Target Database>.
    Description of uc1_vnc.jpg follows
    Description of the illustration uc1_vnc.jpg
    The Security List page is displayed.
  6. Click Edit All 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 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 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 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: 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 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: 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 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, 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 the Console, click Database, then click DB System name for details.

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, and BI Publisher 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, click Service Administration, and then 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 Oracle Database Cloud Service Deployed on Oracle Cloud Infrastructure Classic

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 My Services. Record the information now, so you have the required details when you set up the connection in Oracle Analytics Cloud.

  1. In My Services, open the dashboard.
  2. Navigate to the Database Classic tile.
  3. Click the Action MenuHamburger icon for toggling navigation options, and then select Open Service Console.
  4. 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.
  5. Extract and record the Service Name of the database from the connect string value. For example, PDB1.504988564.oraclecloud.internal.
  6. Record the IP address of the database displayed in the Resources section.
  7. 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 My Services, navigate to the Database Classic tile.
  2. Click the Action Menu, and select Open Service Console.
  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: In My Services, use the Database Classic tile 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: In My Services, use the Database Classic tile 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 tile in My Services 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.