7 Manage Database Connections for Model Administration Tool

Administrators create and manage cloud database connections for Model Administration Tool. 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

When you use 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.

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.

Connect to Data in an Oracle Cloud Database

Administrators create database connections for Model Administration Tool 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.
Data modelers see the new connection in Model Administration Tool 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.