Set Up a SQL Server Connection (Beta)

Set up the SQL Server 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:System Administrator

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.
  • Ensure your SQLServer 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 or Azure 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, provide the SQL Server hostname and port (optional).

    The expected connection URL format for AWS RDS is {section1}.{section2}.{section3}.rds.amazonaws.com:{port}. The sections support lowercase letters, numbers, underscores, and dashes.

    The expected connection URL format for Azure is {subdomain}.database.windows.net:{port}. The subdomain supports lowercase letters, numbers, and dashes.

  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. You can now create data streams.