7 Manage Database Connections for Data Modeler

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 Semantic 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 Classic Cloud Service or Oracle Autonomous Data Warehouse.

You don't have to re-enter database connection information for semantic models pre-built with Oracle Analytics Server. Connection information for these models is often already defined in the semantic model that you upload to Oracle Analytics Cloud. See About Uploading Semantic Models from Oracle Analytics Server.

If you’re using Model Administration Tool to edit your semantic 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 Model Administration Tool. See Connect to a Data Sources using a Connection Defined In 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. Specify database connection information.
    1. In Host, specify the host name or IP address of the database you want to connect to.
    2. In Port, specify the port number on which the database is listening for incoming connections.
    3. In Service Name, specify the network service name of the database.
    4. In SID, specify the name of the Oracle database instance.
    5. In TNS Descriptor, specify the 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 user name of the schema owner and then enter the Password.

    You must connect to the database as the schema owner to access and display the tables in Data Modeler.

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

Delete the SSL Wallet Uploaded for Database Connections

If a database connection you configure for your data model requires SSL certification you must upload a wallet containing the required SSL certificates through the Console (Connections page). You can delete a wallet that you previously uploaded and no longer need.

For example, you might need to remove an existing wallet file if the Oracle Autonomous Data Warehouse that your data model connects to is set up to allow wallet-less connections.

  1. Click Console.
  2. Click Connections.
  3. Click the Action menu, then Delete Wallet.
    Delete Wallet menu option
  4. To confirm, click Delete.