Set Up an AWS RDS Oracle Connection (Beta)

Set up the AWS RDS Oracle connection to start the flow of data into Data Cloud.

This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data Cloud Connector team at datacloud-connectors-beta@salesforce.com.
User Permissions Needed 
To create a connection:Data Cloud admin OR Data Cloud Marketing admin

Before you begin:

  • Enable the Beta connector through the feature manager. See Enable Data Cloud Features.
  • Verify your admin has enabled firewalls on the system you want Data Cloud to connect to by including these IP addresses to your allowlists.

  1. In Salesforce, click Setup, and select Data Cloud Setup.

  2. Under External Integrations, select Other Connectors.

  3. Click New.

  4. On the Source tab, select AWS RDS Oracle and click Next.

  5. Enter a connection name and connection API name, and provide the authentication and connection details.

  6. For Username and Password, enter the credentials to authenticate the user.

  7. Enter a Connection URL.

    The URL follows this format: {section1}.{section2}.{section3}.rds.amazonaws.com:{optional port}

    Section 1 is 1–63 lowercase letters, numbers, or a dash.

    Section 2 is 1–20 characters including lowercase letters, numbers, underscores, or a dash.

    Section 3 is 1–100 characters including letters, numbers, underscores, or a dash.

    Port is optional and 4–5 numbers.

  8. Enter a Schema value.

  9. Enter a Database value.

    To learn more about connecting your RDS for Oracle DB instance, review the AWS documentation.

  10. To review your configuration, click Test Connection.

  11. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.