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.