---
schema_version: "1"
id: 853dd27ca204a43b8dcb8d85151cd298803b5b61e138f16da40b0f9fd1e1d9da
title: Amazon RDS Connection
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_amazon_aws_rds_settings.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_amazon_aws_rds_settings.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 15242224a00c9fca0913e4da658b201f488245442bfad1af65e6c10745b8450d
description: Create a remote connection using one of the Amazon RDS connectors to bring data managed on the Amazon Relational Database Service into CRM Analytics.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Amazon RDS Connection

Create a remote connection using one of the Amazon RDS connectors to bring data managed on the Amazon Relational Database Service into CRM Analytics.

## Available Amazon RDS Connectors

- AWS RDS Aurora MySQL
- AWS RDS Aurora PostgreSQL
- AWS RDS MariaDB
- AWS RDS MySQL
- AWS RDS PostgreSQL
- AWS RDS SQL Server

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note Only SSL-enabled Amazon RDS instances are supported.

## Create the Connection

1. On the Data Manager Connections tab, click **New Connection**.
2. Click the name of the connector, and click **Next**.
3. Enter the connector settings.
4. To validate your settings and attempt to connect to the source, click **Save & Test**. If the connection fails, CRM Analytics shows possible reasons.

All settings require a value, unless otherwise indicated.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:66.66666666666666%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d169752e103">Setting</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d169752e106">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">Connection Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">Identifies the connections. Use a convention that lets you easily distinguish
              between different connections.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">Developer Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">API name for the connection. This name can’t include spaces. The API name is
              used in your recipes to reference data extracted through this connection. You can’t
              change the developer name after you create the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">Description of the connection for internal use.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">Database</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">Name of the database that you’re connecting to.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">JDBC Connection URL</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">
              <p>URL schema for the database. The port isn’t optional. If no port is specified,
                the default port is used. Enter in the format:
                <kbd>&lt;prefix&gt;.&lt;hostname&gt;.&lt;cluster&gt;.rds.amazonaws.com:&lt;port&gt;</kbd>
              </p>
              <div>
                <p>For
                  example:
                </p>
                <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>analyticsaws.csg5yuelzxbf.us-west-2.rds.amazonaws.com:5407</code></pre>
              </div>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">Username</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">User name to connect to the database.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">
              <p>Schema</p>
              <p style="margin-bottom:0;">This setting is available for MariaDB and MySQL
                connections.</p>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">
              <p>Schema name for the database. Required if the JDBC connection URL doesn’t
                provide enough context. Otherwise, this setting is optional.</p>
              <ul>
                <li>Microsoft SQL Server—Use the schema name to specify the correct
                  object.</li>
                <li>PostgreSQL—Use the schema name to specify the correct object.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e103 ">Password</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d169752e106 ">Password to connect to the database.</td>

          </tr>
        </tbody>
      </table>

## Filter Data Synced to CRM Analytics

Exclude unnecessary or sensitive data from syncing to CRM Analytics with data sync filters. Filters run on the source object and speed up data sync by pulling only the data you need into CRM Analytics.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note If you plan to use excluded data in the future, use a recipe filter to limit the data written to a dataset instead of a data sync filter.

1. From Data Manager, click the **Connections** tab.
2. Select the connection associated with the object to filter.
3. Click the name of the object to filter.
4. Click **Data Sync Filter**.
5. Enter the filter.
6. Click **Save**.

To filter an Amazon AWS RDS connector, enter a filter using the syntax described in its help.

- [AWS RDS Aurora MySQL Help](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraMySQL.html)
- [AWS RDS Aurora PostgreSQL Help](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.html)
- [AWS RDS MariaDB Help](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MariaDB.html)
- [AWS RDS MySQL Help](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html)
- [AWS RDS PostgreSQL Help](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html)
- [AWS RDS SQL Server Help](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html)

## Amazon RDS Connector Considerations

Keep these behaviors in mind when working with an Amazon RDS connector.

- Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
- Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
- The connector can sync up to 20 million rows or 10 GB per object, whichever limit is reached first. When using the connector, Salesforce Government Cloud org data is protected in transit with advanced encryption and can sync up to 10 million rows or 5 GB for each connected object, whichever limit is reached first.
- The AWS RDS SQL Server connector isn’t available to sync Salesforce Government Cloud org data.
- Columns of datatype JSON are not supported.

#### See Also

- [Amazon RDS Connector Known Issues and Knowledge Articles](https://sfdc.co/amzrdsconnsearch)
- [Add and Remove Remote Objects and Fields from Data Sync](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_replicate_connection.htm&release=264.0.0&type=5 "Update data sync for connected external data sources to keep up with your changing business by adding objects, removing objects, and managing which fields are synced. Synced data is stored in CRM Analytics as objects that can be used in recipes.")