Set Up an AWS RDS SQL Server Connection

Set up the AWS RDS SQL Server 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.
  • Ensure your SQL Server is publicly accessible.

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

  2. Under Configuration, select Connectors.

  3. Click New.

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

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

  6. For Username, enter the username configured to access your database.

  7. For Password, enter the password to authenticate the user.

  8. For Connection URL, enter a Connection URL in this format: {section1}.{section2}.{section3}.rds.amazonaws.com{:port}

    1. Section 1 is 1–63 lowercase letters (a–z), numbers (0–9), or hyphens (-).
    2. Section 2 is 1–20 characters, including uppercase (A–Z) or lowercase letters (a–z), numbers (0–9), underscores (_), or hyphens (-).
    3. Section 3 is 1–100 characters, including uppercase (A–Z) or lowercase letters (a–z), numbers (0–9), underscores (_), or hyphens (-).
    4. The port is optional. If included, the port is 4–5 numbers (0–9) and prefixed with a colon (:).

  9. For Schema, enter the database schema that the user's access is limited to for this connection.

  10. For Database, enter the SQL Server database that the user's credentials are authorized to authenticate to.

  11. To review your configuration, click Test Connection.

  12. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors.

Create an AWS RDS SQL Server Data Stream