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

Databases Data Modeler Can Connect To

You can connect Data Modeler 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 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 Cloud 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 Connecting to a Data Source Using an External Connection.

Connecting 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 Service Administration - Manage 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.

    Service Name

    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

    Connect as

    Database user name.

    Password

    User’s password to access the database.

    Enable SSL

    Enables SSL on the database connection. See Securing Database Connections with SSL.

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