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. |
|
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. |
|
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.
|
|
Migrate content |
Leverage your existing content in Oracle Analytics Cloud. |
|
Scale a service up or down |
Increase or decrease the number of Oracle Compute Units (OCPUs) allocated to your service. |
|
Pause or resume a service |
Pause a service to temporarily prevent users from accessing the service. |
|
Delete a service |
Delete services that you don’t want anymore. |
|
Note down the IP address of Oracle Analytics Cloud | Determine the IP address of your Oracle Analytics Cloud instance. | |
Give your database access to Oracle Analytics Cloud |
In your database, add the IP addresses for any Oracle Analytics Cloud instances you want to connect to. |
Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists |
Add the IP address of your Oracle Analytics Cloud instance to the allowlist in your Oracle Cloud database | Configure your Oracle Cloud database to accept connections from Oracle Analytics Cloud. | Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists |
Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure |
Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure with a public IP address. |
Connect to a Database Deployed on Oracle Cloud Infrastructure with a Public IP Address |
Connect to Oracle Autonomous Data Warehouse | Connect to Oracle Autonomous Data Warehouse with a public IP address. | Connect to Oracle Autonomous Data Warehouse with a Public IP Address |
Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure Classic | Connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure Classic. | Connect to a Database Deployed on Oracle Cloud Infrastructure Classic with a Public IP Address |
Reset credentials | Reset credentials and passwords for services and databases, for example, Oracle Cloud Storage. | Manage Credentials |
Set Up Users and Application Roles
One of the first jobs you do after setting up a service with Oracle Analytics Cloud is to add user accounts in Oracle Identity Cloud Service for everyone you expect to use the service and assign them suitable permissions in the service (also known as application roles).
Oracle Identity Cloud Service is available with your Oracle Analytics Cloud account.
-
Users and Group — Use Oracle Identity Cloud Service to add users and groups.
Alternatively, use Oracle Identity Cloud Service to integrate directly with your existing directories and identity management systems. See About Oracle Identity Cloud Service in Administering Oracle Identity Cloud Service.
-
Application Roles — The way you assign users to application roles depends on the feature profile you chose when you set up your service.
Feature Profile Assigning Application Roles Book -
Business Intelligence
-
Data Visualization
Configuring Oracle Analytics Cloud
-
Essbase
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 (ServiceAdministrator, ServiceUser, ServiceViewer) that map to a set of predefined application roles in Oracle Analytics Cloud.
Description of the illustration app-roles.jpg
To understand more about the predefined Oracle Analytics Cloud application roles, see About Application Roles.
Configure Options for Your Service
Administrators have many critical duties; they control user permissions and amend accounts, set up database connections for data modelers, manage data storage to avoid exceeding storage limits, taking regular snapshots so users don't risk losing their work, authorize access to external content by registering safe domains, troubleshoot user queries, and so much more. After setting up a service with Oracle Analytics Cloud, you can review typical administrator tasks for your service.
Administration tasks depend on the feature profile you chose when you set up your service.
Feature Profile | Tasks Performed by Administrators | Book |
---|---|---|
|
Configuring Oracle Analytics Cloud |
|
|
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.
Topics:
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:
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.
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.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.
The user you just added receives an email inviting them to activate their account and provide a password. When they sign in to their Cloud Account they have all the required permissions to set up Oracle Analytics Cloud and administrative access the Console for Oracle Cloud Infrastructure.
About Access Into and Out from Analytics Cloud Instances
You can manage access into and out from Oracle Analytics Cloud deployments on Oracle Cloud Infrastructure through public IP addresses.
All incoming connections access Oracle Analytics Cloud over the public internet and any connections you set up in Oracle Analytics Cloud to your data sources must be accessible through the public internet.
For example, you connect your Oracle Analytics Cloud deployment to data sources such as Oracle Autonomous Data Warehouse, Oracle Cloud databases deployed on Oracle Cloud Infrastructure, and Oracle Cloud databases deployed on Oracle Cloud Infrastructure Classic through public IPs. If you're not familiar with setting up public IP access for these data sources, use the information here as a guide.
For a complete list of the data sources that Oracle Analytics Cloud can connect to, see Supported Data Sources.
Add the IP Address of Your Oracle Analytics Cloud Instance to Allowlists
Before you try to connect Oracle Analytics Cloud to an Oracle Cloud database, ask the database administrator to add the IP address (or address range) for your Oracle Analytics Cloud instance to the target database's allowlist. The database administrator must add a security rule on the target Oracle Cloud database that allows TCP/IP traffic from Oracle Analytics Cloud on a specific database port.
This topic describes how to add Oracle Analytics Cloud to the allow list for an Oracle Cloud database. If you want to connect to other data sources, follow similar steps, as required.
Public IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances
If you want your Oracle Analytics Cloud to connect to an Oracle Cloud database, you must add the IP address, IP Ranges, or Gateway IPs associated with your Oracle Analytics Cloud instance to the database's allowlist.
Note:
The IP Ranges and Gateway IPs are different if your Oracle Analytics Cloud environment is deployed on Oracle Cloud Infrastructure Gen 2. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).For Oracle Analytics Cloud Instances Created After 9/8/18
If you want Oracle Analytics Cloud to connect to an Oracle Cloud database, add the IP ranges or Gateway IPs associated with the region where you deployed Oracle Analytics Cloud to your database's allowlist.
To verify the created date and region of your instance, refer to the Created On and Region values in Instance Details menu in Oracle Cloud Infrastructure Console.
Using this table, make a note of either:
- All IP addresses in the IP Ranges column for your region.
OR
- All IP addresses in the Gateway IPs column for your region.
When deciding on whether to add IP ranges or Gateway IPs to the allowlist, choose whichever method satisfies the security policy enforced by your company or organization.
For example, if your Oracle
Analytics Cloud instance is in ca-toronto-1, and your security policy requires an IP ranges, you add
192.29.9.64/26
and 192.29.13.240/28
to the
allowlist. Alternatively, if your Oracle
Analytics Cloud instance is in ca-toronto-1, and your security policy requires Gateway IPs, you add
192.29.9.73
and 192.29.9.106
and
192.29.13.247
.
Region | IP Ranges | Gateway IPs |
---|---|---|
us-ashburn-1 |
130.35.100.240/28 130.35.200.160/28 147.154.18.112/28 147.154.24.0/28 147.154.26.128/27 147.154.4.160/28 147.154.7.240/28 |
130.35.100.247 130.35.200.170 147.154.18.118 147.154.24.13 147.154.26.144 147.154.4.164 147.154.7.253 |
us-phoenix-1 |
130.35.129.112/28 130.35.2.32/28 147.154.107.176/28 147.154.109.240/28 147.154.110.176/28 147.154.96.160/28 147.154.98.128/26 |
130.35.129.125 130.35.2.34 147.154.107.186 147.154.109.248 147.154.110.181 147.154.96.171 147.154.98.159 |
eu-frankfurt-1 |
138.1.64.128/28 138.1.65.0/26 138.1.66.48/28 147.154.129.32/28 147.154.138.0/24 |
138.1.64.139 138.1.65.32 138.1.66.60 147.154.129.37 147.154.138.198 |
uk-london-1 |
138.1.18.192/27 138.1.83.208/28 138.1.83.64/27 147.154.230.32/28 |
138.1.18.208 138.1.83.211 138.1.83.221 138.1.83.80 147.154.230.44 |
ca-toronto-1 |
192.29.9.64/26 192.29.13.240/28 |
192.29.9.73 192.29.9.106 192.29.13.247 |
For Oracle Analytics Cloud Instances Created Before 9/8/18
If you want Oracle Analytics Cloud to connect to an Oracle Cloud database, add the IP address of your Oracle Analytics Cloud instance to the database's allowlist.
To verify the creation date of your instance, refer to the Created On date in Oracle Cloud Infrastructure Console.
Using this table, for your region, make a note of the IP address in the IP Addresses column.
Region | IP Address |
---|---|
us-ashburn-1 |
130.35.0.0/16 |
us-phoenix-1 |
130.35.0.0/16 |
eu-frankfurt-1 |
138.1.0.0/17 |
uk-london-1 |
138.1.0.0/17 |
Connect to a Database Deployed on Oracle Cloud Infrastructure with a Public IP Address
Configure Oracle Analytics Cloud to connect to a database deployed on Oracle Cloud Infrastructure with a public IP address, so that end users can analyze that data in visualizations, analyses, and pixel-perfect reports.
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. |
|
Record database information |
Record connection information for database. |
|
Enable database access |
Add an ingress rule to give Oracle Analytics Cloud access to the database. |
|
Connect to the database |
Create and test your connections. |
Prerequisites
Before you start, make sure you have the required environment.
Step | Description | Important Information to Note |
---|---|---|
Set up Oracle Analytics Cloud |
Deploy Oracle Analytics Cloud. |
Region Availability Domain |
Set up a Virtual Cloud Network (VCN) on Oracle Cloud Infrastructure |
Set up a VCN for the database deployment on Oracle Cloud Infrastructure. Note: The VCN must be in the same Region and Availability Domain as Oracle Analytics Cloud. |
Virtual Cloud Network Subnet Same:
|
Deploy a database:
|
Deploy a database on the VCN in Oracle Cloud Infrastructure. Note: The database must be in the same Region and Availability Domain as the VCN. |
Public IP Database Unique Name Host Domain Name Database User/Password Same:
|
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.
- In Oracle Cloud Infrastructure Console, click in the top left corner.
- Click Databases. Under MySQL, click DB Systems.
- Locate the database you want to connect to and record the Public IP address.
Description of the illustration uc1_databases.jpg - Click the name of the database you want to connect to and write down the values in these
fields: Database Unique Name, Host Domain
Name, Virtual Cloud Network,
Client Subnet, and Port.
Description of the illustration uc1_database.jpg - Find out the user name and password of a database user with permissions to read from this database, and write them down as you need these later. For example, the user SYSTEM.
Enable Database Access Through Port 1521
Add an ingress rule that enables Oracle Analytics Cloud to access the database through port 1521.
Connect to Your Database from Oracle Analytics Cloud
After enabling access to the database, use the database connection information you wrote down earlier to connect Oracle Analytics Cloud to the database. The way you connect to the database depends on what you want to do with the data.
-
Visualize the data.
-
Model the data using Semantic Modeler or Data Modeler, then generate analyses and dashboards.
-
Model the data with Oracle Analytics Cloud Model Administration Tool, then generate analyses and dashboards.
-
Publish the data in pixel-perfect reports.
Connect to Your Database for Data Visualization or Semantic Modeler
-
New Connection Name: A name for the database you want to connect to.
-
Host: The Public IP address for the database instance. For example, 123.213.85.123.
-
Port: The port number that enables access to the database. For example, 1521.
-
Username: The name of a user with read access to the database.
-
Password: The password for the specified database user.
-
Service Name: A concatenated name comprising Database Unique Name and Host Domain Name, separated with a period. For example,
CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com
.
Connect to Your Database for Data Modeler
-
Name and Description: A name for the database you want to connect to.
-
Connect using: Select Host, Port, and Service Name.
-
Host: The Public IP address for the database. For example, 123.213.85.123.
-
Port: The port number that enables access to the database. For example, 1521.
-
Service Name: A concatenated name comprising Database Unique Name and Host Domain Name, separated with a period. For example,
CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com
. -
Connect as: The name of a user with read access to the database.
-
Password: The password for the specified database user.
Connect to Your Database in Model Administration Tool
-
Call interface: Select Default (Oracle Call Interface (OCI)).
-
Data Source Name: Specify the connection details. For example:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=129.213.85.177)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com))
For SERVICE_NAME, specify the concatenated Database Unique Name and Host Domain Name separated by a period, for example, db1_phx1tv.mycompany.com. To find both these names in Oracle Cloud Infrastructure Console, click Databases, under MySQL click DB Systems, and then click the name of your database.
Connect to Oracle Autonomous Data Warehouse with a Public IP Address
Configure Oracle Analytics Cloud to connect to Autonomous Data Warehouse over a public IP address so that end users can analyze that data in visualizations, analyses, dashboards, and pixel-perfect reports.
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. |
|
Enable access to Autonomous Data Warehouse |
Upload your Autonomous Data Warehouse Client Credentials file (wallet file) to Oracle Analytics Cloud. |
|
Connect to Autonomous Data Warehouse |
Create and test your connections. |
Prerequisites
Before you start, make sure you have the required environment.
Step | Description | Important Information to Note |
---|---|---|
Set up Oracle Analytics Cloud |
Deploy Oracle Analytics Cloud. |
Region Availability Domain |
Set up Oracle Autonomous Data Warehouse |
Deploy Autonomous Data Warehouse.
|
Host Name Port Number Service Name (Obtain these details from |
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.
Connect to Oracle Autonomous Data Warehouse
After enabling access to Oracle Autonomous Data Warehouse, use the connection details you recorded earlier to connect Oracle Analytics Cloud to Autonomous Data Warehouse. The way you connect depends on what you want to do with the data.
-
Visualize the data
-
Model the data using Semantic Modeler or Data Modeler, then generate analyses and dashboards.
-
Model the data with Oracle Analytics Model Administration Tool, then generate analyses and dashboards.
-
Publish the data in pixel-perfect reports.
Connect to Autonomous Data Warehouse for Data Visualization or Semantic Modeler
Connect to Autonomous Data Warehouse for Data Modeler
-
Name and Description: A short name and description to identify this connection in Oracle Analytics Cloud.
-
Connect Using: Select Host, Port, and Service Name.
-
Host: The host name of the Autonomous Data Warehouse instance that you obtained from the downloaded
tnsnames.ora
file. For example,adwc.example.oraclecloud.com
. -
Port: The port number that you obtained from the downloaded
tnsnames.ora
file. For example, 1522. -
Service Name: The service name that you obtained from the downloaded
tnsnames.ora
file. For example,adwc1_high.adwc.oraclecloud.com
. -
Connect as: The name of a user with read access to Autonomous Data Warehouse. For example, ADMIN.
-
Password: The password for the specified database user.
-
Enable SSL: Select this option.
Connect to Autonomous Data Warehouse in Model Administration Tool
Connect to a Database Deployed on Oracle Cloud Infrastructure Classic with a Public IP Address
Configure Oracle Analytics Cloud to connect to Oracle Database Classic Cloud Service deployed on Oracle Cloud Infrastructure Classic so that end users can analyze that data in visualizations, analyses, and pixel-perfect reports.
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. |
|
Record database information |
Record connection information for Oracle Database Classic Cloud Service. |
|
Enable database access |
Add access rules to enable Oracle Analytics Cloud access to the database. |
|
Connect to the database |
Create and test your connections. |
Prerequisites
Before you start, make sure you have the required environment.
Step | Description | Note Important Information |
---|---|---|
Set up Oracle Analytics Cloud |
Deploy Oracle Analytics Cloud. |
Region Availability Domain |
Deploy Oracle Database Classic Cloud Service
|
Deploy Oracle Database Classic Cloud Service on the Virtual Cloud Network in Oracle Cloud Infrastructure Classic. |
Public IP Service Name Host Domain Name Database User/Password Same:
|
Record Database Information
All the information you need to connect to Oracle Database Classic Cloud Service is available in Oracle Cloud Infrastructure Console. Record the information now, so you have the required details when you set up the connection in Oracle Analytics Cloud.
- In Oracle Cloud Infrastructure Console, click in the top left corner.
- Click OCI Classic Services. Under Classic Data Management Services, click Database Classic.
- 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
. - Extract and record the Service Name of the database from the connect string value. For example,
PDB1.504988564.oraclecloud.internal
. - Record the IP address of the database displayed in the Resources section.
- Find out the user name and password of a database user with permissions to read from this database, and write them down. For example, the user SYSTEM.
Enable Database Access Through Port 1521
Add an access rule that enables Oracle Analytics Cloud to access the database through port 1521.
Connect to Your Database from Oracle Analytics Cloud
After enabling access to the database, use the database connection information you recorded earlier to connect Oracle Analytics Cloud to the database deployed in Oracle Cloud Infrastructure Classic. The way you connect to the database depends on what you want to do with the data.
-
Visualize the data.
-
Model the data using Semantic Modeler or Data Modeler, then generate analyses and dashboards.
-
Model the data with Oracle Analytics Model Administration Tool, then generate analyses and dashboards.
Connect to Your Database for Data Visualization or Semantic Modeler
-
Connection Name: The name of the Oracle Database Classic Cloud Service you want to connect to.
-
Host: The Public IP address for Oracle Database Classic Cloud Service. For example, 123.213.85.123.
-
Port: The port number that enables access to Oracle Database Classic Cloud Service. For example, 1521.
-
Username: The name of a user with read access to Oracle Database Classic Cloud Service.
-
Password: The password for the specified database user.
-
Service Name: The service name on the Database Classic page. For example, PDB1.123456789.oraclecloud.internal.
Connect to Your Database for Data Modeler
-
Name and Description: The name of the Oracle Database Classic Cloud Service you want to connect to.
-
Connect Using: Select Host, Port, and Service Name.
-
Host: The Public IP address for Oracle Database Classic Cloud Service. For example, 123.213.85.123.
-
Port: The port number that enables access to Oracle Database Classic Cloud Service. For example, 1521.
-
Service Name: The service name from the Database Classic page. For example, PDB1.123456789.oraclecloud.internal.
-
Connect as: The name of a user with read access to Oracle Database Classic Cloud Service.
-
Password: The password for the specified database user.
Connect to Your Database in Oracle Analytics Model Administration Tool
-
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
.