Manage Database Connections for Data Models

Administrators create and manage cloud database connections for Data Modeler. 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 for Data Models

Data Modeler in Oracle Analytics Cloud can handle data stored in Oracle Cloud databases. Simply connect Oracle Analytics Cloud to your cloud data sources to start modeling the data.

It doesn't matter if your business data is stored in several different locations. You can connect Oracle Analytics Cloud to multiple cloud databases, so business analysts can model and then analyze their data wherever it is stored.

Administrators create, manage, and test database connections for Data Modeler through the Console. Business modelers can see connected databases through Data Modeler and build business models from the data.

You can connect Data Modeler to Oracle Cloud databases. The target database must be Oracle Database Cloud Service or Oracle Autonomous Data Warehouse.

You don't have to re-enter database connection information for data models pre-built with Oracle BI Enterprise Edition. Connection information for these models is often already defined in the data model file (.rpd) that you upload to Oracle Analytics Cloud. See About Uploading Oracle BI Enterprise Edition Data Models to the Cloud.

If you’re using Oracle Analytics Developer Client Tool to edit your data models and upload them to Oracle Analytics Cloud, you can refer to any database connections you define in the Console “by name” in the Connection Pool dialog. You don’t need to re-enter the connection details in Developer Client Tool . See Connect to a Data Source using a Connection Defined Through Console.

Connect to Data in an Oracle Cloud Database

Administrators create database connections for Data Modeler so business analysts can analyze data stored in Oracle Cloud databases.

  1. Click Console.
  2. Click Connections.
  3. Click Create.
  4. Enter a meaningful Name and Description that you’ll remember and business modelers will recognize.
  5. For Connect Using, select which properties you want to use to connect to the database.
  6. Enter database connection information for your Oracle Database Cloud Service or Oracle Autonomous Data Warehouse.

    Ask the database administrator to provide the connection details.

    Connection Parameter Description

    Host

    Host name of the database or the IP address of the database you want to connect to.

    Port

    Port number on which the database is listening for incoming connections.

    Service Name

    Network service name of the database.

    SID

    Name of the Oracle database instance.

    TNS Descriptor

    TNS connect descriptor that provides the location of the database and the name of the database service.

    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.example.om)(PORT=1521))(CONNECT_DATA=(SERVICE NAME=sales.example.om))

  7. For Connect As, enter the name of a user with read access to database and then enter the Password.
  8. Select Enable SSL, to secure this connection using SSL.
    If you haven’t done so already, you must upload a wallet containing your SSL certificates.
  9. Click Test to verify the connection.
  10. Click OK.
Business modelers see the new connection in Data Modeler right away and can start to model the data.

Secure Database Connections with SSL

Use SSL to secure communication between Oracle Analytics Cloud and an Oracle database with SSL configured, Oracle Autonomous Data Warehouse, or Oracle Autonomous Transaction Processing. You must obtain and upload a wallet that contains SSL certificates, to enable SSL on your Oracle Database Cloud Service connections.

  1. Click Console.
  2. Click Connections.
  3. If you’ve not done so already, upload a wallet file containing SSL certificates to Oracle Analytics Cloud:
    1. Click the Action menu, then 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.