Loading
Salesforce now sends email only from verified domains. Read More
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Amazon RDS Connection

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            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
            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.

            Setting Description
            Connection Name Identifies the connections. Use a convention that lets you easily distinguish between different connections.
            Developer Name 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.
            Description Description of the connection for internal use.
            Database Name of the database that you’re connecting to.
            JDBC Connection URL

            URL schema for the database. The port isn’t optional. If no port is specified, the default port is used. Enter in the format: <prefix>.<hostname>.<cluster>.rds.amazonaws.com:<port>

            For example: 

            analyticsaws.csg5yuelzxbf.us-west-2.rds.amazonaws.com:5407
            Username User name to connect to the database.

            Schema

            This setting is available for MariaDB and MySQL connections.

            Schema name for the database. Required if the JDBC connection URL doesn’t provide enough context. Otherwise, this setting is optional.

            • Microsoft SQL Server—Use the schema name to specify the correct object.
            • PostgreSQL—Use the schema name to specify the correct object.
            Password Password to connect to the database.

            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
            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.

            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

             
            Loading
            Salesforce Help | Article