Administrators create and manage cloud database connections for Oracle BI Cloud Service. Your business data doesn't have to be in one place. Connect to multiple cloud databases so business modelers and analysts can analyze company data wherever it is stored.
About Database Connections
Oracle BI Cloud Service can handle data stored in Oracle Cloud databases. Simply connect Oracle BI Cloud Service to your cloud data sources to start analyzing the data. It doesn't matter if your business data is stored in several different locations. As you can connect Oracle BI Cloud Service to multiple cloud databases, business analysts can analyze all their data wherever it is stored.
Administrators create, manage, and test database connections for Oracle BI Cloud Service. Business modelers can see connected databases through Data Modeler and build business models from the data.
About the Default Database Connection
Your Oracle BI Cloud Service connects to Database Schema Service through the Default Connection. You can’t delete this connection. The Default Connection is always available.
Database Schema Service is the single schema-based service integrated with Oracle BI Cloud Service. You don't have to create a connection to use this database.
Databases You Can Connect To
You can connect Oracle BI Cloud Service to Oracle Cloud databases. The target database must be Oracle Database Cloud Service.
Database Connections for Data Models Uploaded from Oracle BI Enterprise Edition
You don't need to enter database connection information for data models pre-built with Oracle BI Enterprise Edition. Connection information for these models is in the data model file (.rpd) that you upload to Oracle BI Cloud Service. See About Uploading Oracle BI Enterprise Edition Data Models to the Cloud.
Connecting to Data in an Oracle Cloud Database
Administrators create database connections so business analysts can analyze data stored in Oracle Cloud.
- Click Console.
- Click Connections.
- Click New Connection.
- Enter a meaningful Name and Description that you’ll remember and business modelers will recognize.
- Enter database connection information for your Oracle Database Cloud Service.
Ask the database administrator to provide the connection details.
Option Description Connect Using Select how you want to connect to the database.
Address of the database server or the host’s name.
Port number on which the database server is listening for incoming connections.
SID or Service Name
SID — Name of the Oracle database instance.
Service Name — Network service name of the database.
TNS connect descriptor that provides the location of the database and the name of the database service. You must select this option if you want to connect to an Oracle Real Application Cluster (RAC) database.
Use the format:
DESCRIPTION=(ADDRESS=(PROTOCOL=protocol)(HOST=host) (PORT=port)) (CONNECT_DATA=(SERVICE_NAME=service name))
To connect to an Oracle Real Application Cluster (RAC) database, use the format:
Database user name.
User’s password to access the database.
- Click Test to verify the connection.
- Click OK.