Managing Database Connections

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.

  1. Click Console.
  2. Click Connections.
  3. Click New Connection.
  4. Enter a meaningful Name and Description that you’ll remember and business modelers will recognize.
  5. 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.

    Host

    Address of the database server or the host’s name.

    Port

    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.

    Enable SSL

    Select to secure this connection using SSL. If you haven’t done so already, upload a wallet with SSL certificates. See Securing Database Connections with SSL

    TNS Descriptor

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

    For example:

    DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost.company.com)(PORT=1521))(CONNECT_DATA=(SERVICE NAME=sales.company.com))

    To connect to an Oracle Real Application Cluster (RAC) database, use the format:

    DESCRIPTION=

    (ADDRESS=(PROTOCOL=protocol)(HOST=host1) (PORT=port))

    (ADDRESS=(PROTOCOL=protocol)(HOST=host2) (PORT=port))

    (CONNECT_DATA=(SERVICE_NAME=service name))

    For example:

    (DESCRIPTION=

    (ADDRESS=(PROTOCOL=tcp)(HOST=myhost1.company.com)(PORT=1521))

    (ADDRESS=(PROTOCOL=tcp)(HOST=myhost2.company.com)(PORT=1521))

    (CONNECT_DATA=(SERVICE NAME=sales.company.com)))

    Connect as

    Database user name.

    Password

    User’s password to access the database.

  6. Click Test to verify the connection.
  7. Click OK.
Business modelers see the new connection in Data Modeler right away and can start to model the data. See Creating a Data Model.

Securing Database Connections with SSL

Use SSL to secure communication between Oracle BI Cloud Service and any database you connect to. You must obtain and upload a wallet that contains SSL certificates, to enable SSL on your Oracle Database Cloud Service connections.

  1. Open the Console.
  2. Click Connections.
  3. If you’ve not done so already, upload a wallet file containing SSL certificates to Oracle BI Cloud Service:
    1. Click Upload Wallet.
      To update an existing wallet file, click Replace Wallet.
    2. Click Browse and locate the wallet file.
      Select a valid cwallet.sso file.
    3. Click OK.
  4. Enable SSL security on a database connection:
    1. Create or edit a database connection.
    2. In the Connection dialog, select Enable SSL.
    3. Click OK.