Skip to main content

​
Intro

You can connect your data from Oracle Cloud to Domo using Cloud Amplifier native integrations. Provide connection parameters and select the tables you want to see as Domo DataSets. Follow the steps in this article to configure your Oracle-Domo read and write connections with Cloud Amplifier.

​
Architectural Overview

Oracle architecture diagram.png

​
Start and Manage Your Oracle Integrations

To access the integration management interface, please follow these steps:
  1. Navigate to the Data tab located at the top of the Domo platform.
  2. Elect Connect Data.
  3. Choose Oracle Cloud from the list of Cloud Integrations.
    The Domo on Oracle appears.
  4. Select Connect Oracle Cloud to initiate the process of creating a new integration or Manage Integrations to modify existing integrations. Available integrations display. To set up your integration, see Create Your Oracle Integration.
  5. Select the wrench icon on your integration to access additional integration options, such as edit, select tables to connect, enable write access, and delete.
    Note: You may see different options based on your access level.

​
Create Your Oracle Integration

Important: To create an Oracle integration, you must have an account with either NetSuite Analytics Warehouse or Oracle Autonomous Data Warehouse.
Note: This Oracle integration setup enables Domo to read data from Oracle. You must determine which Oracle tables are connected and configure access and privileges to the integration.
After you have started your Oracle integration, follow these steps to get more value from your data:
  1. Name your Oracle integration. This name helps you identify an Oracle integration within Domo and doesn’t need to match any names already set in Oracle or Netsuite. You can change the name of your integration at any time.
    Tip: Use specific naming to create more than one Oracle integration within a single Domo instance so you can connect different tables or better manage access.
  2. Describe your Oracle integration. Adding a description to your Oracle integration helps other users understand why you created it and how it is used.
    Note: To view the description, you must inspect the details of the Oracle integration itself.
  3. Select your Oracle service account within Domo or select Add account to create a new one.
    Important: Although the Oracle service account can be changed later, you must take care when switching the associated service account, as there is potential for DataSet and ETL remapping and Domo user access interference.
Important: Three levels of Oracle-Domo architecture exist. This means that a many-to-one relationship can exist between Oracle service accounts, as defined by Domo and the Oracle instance, and multiple Oracle integrations can also make use of a single service account. The three levels of Oracle-Domo architecture are:
  • Oracle instances , which exist independently of Domo.
  • Oracle service accounts , which connect to the Oracle instance from inside Domo.
  • Oracle integrations , which use the service account inside Domo and add a layer of settings that specify connections between Oracle tables and Domo DataSets, define caching behavior, and determine write-back enablement.
Best Practices:You can create multiple service accounts in Domo referencing the same Oracle instance to delineate functional differences.
  • Example A: You want to manage user access to two Oracle integrations separately.
  • Example B: You want to configure separate settings for caching TTL while preserving a shared definition for Domo user access.

​
Configure Writeback Support for Oracle Cloud (Beta)

You can configure a Cloud Amplifier integration to write outputs from Domo into Oracle tables. Follow these instructions to add writeback capabilities to a read-only Oracle integration:
  1. Navigate to the Domo Data Center.
  2. (Conditional) If you’re not already there, use the sidebar to go to the Data Warehouse (cube icon).
  3. Select Manage Cloud Connections.
  4. In the Native Integration section, select See More to see the rest of the options.
    see more.jpg
  5. Select Oracle to view your existing Oracle-Cloud Amplifier integrations.
  6. Hover over an existing integration with read-only permissions and select (wrench icon) > Configure write access. If you do not have any existing integrations, follow the read-only integration steps.
    Screenshot 2024-10-09 at 8.57.32 AM.png
  7. Enter your credential name you want to create on Oracle for the integration and select Generate SQL.
  8. Follow the instructions; there are two sets of statements that need to be executed in Oracle:
    • Those with an ACCOUNTADMIN role have to execute the first set of instructions to grant the credentials in the Oracle instance.
    • The account user (configured when you set up your read integration ) must execute the second set of instructions to create the write credentials.
  9. After successfully executing both sets of instructions in your Oracle instance, copy the ID and ARN values and select Next.
    2.png
  10. In the next step, confirm that you understand that Domo can make changes to your Oracle environment and select Next. A message confirming that your write integration was successfully configured displays.