Set Up an AWS RDS Oracle Connection
Set up the AWS RDS Oracle connection to start the flow of data into Data 360.
| User Permissions Needed | |
|---|---|
| To create a connection: | System Admin profile or Data Cloud Architect permission set |
Before you begin:
- Verify your admin has enabled firewalls on the system you want Data 360 to connect to by including these IP addresses to your allowlists.
-
In Salesforce, click Setup, and select Data Cloud Setup.
-
Under External Integrations, select Other Connectors.
-
Click New.
-
On the Source tab, select AWS RDS Oracle and click Next.
-
Enter a connection name and connection API name, and provide the authentication and connection details.
-
For Username and Password, enter the credentials to authenticate the user.
-
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.
-
Enter a Schema value.
-
Enter a Database value.
To learn more about connecting your RDS for Oracle DB instance, review the AWS documentation.
-
To review your configuration, click Test Connection.
-
Click Save.
After the connector details are accepted, the connection is created and listed under Connectors.