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
            Database Connectors

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Database Connectors

            Use these connectors to sync data from your external database services to CRM Analytics.

            Connector Name Authorization Options/Auth Types Additional Information
            Amazon Athena Connection
            • Standard authentication (Root)
            • AWS Identity Access Management (IAM)
            		 For Root authentication, the connector uses AwsRootKeys for the AuthSchema value. For granular access to AWS data, use IAM authentication, setting up IAM users and roles in AWS.
            Amazon RDS Connection (Oracle) Username and password

            Available connectors:

            • AWS RDS Aurora MySQL
            • AWS RDS Aurora PostgreSQL
            • AWS RDS MariaDB
            • AWS RDS MySQL
            • AWS RDS PostgreSQL
            • AWS RDS SQL Server
            Amazon Redshift Connection Username and password Before you create an Amazon Redshift connection, make sure that the Redshift cluster that you’re connecting to is SSL enabled.
            Databricks Connection Personal access token (PAT) M2M (OAuth) is scheduled for Winter '26 release.
            Google BigQuery Standard SQL Connection Private key and client email Use the Google BigQuery for Legacy SQL Connection instead of this connector if using legacy SQL.
            Google BigQuery for Legacy SQL Connection Private key and client email Use the Google BigQuery Standard SQL Connection instead of this connector if using standard SQL or when querying partitioned tables.
            Google Cloud Spanner Connection Private key and client email  
            Heroku Postgres Connection Username and password  
            Microsoft Azure Synapse Analytics Connection Azure DW JDBC username and password  
            Microsoft Azure SQL Database Connection Username and password To connect to Microsoft Azure Synapse Analytics or a dedicated SQL pool (formerly SQL DW), add a Microsoft Azure Synapse Analytics Connection instead of this one.
            SAP HANA Cloud Connection Username and password  
            Snowflake Connection
            • Username and password
            • OAuth
            • Username, private key, and private key passphrase
            		 To use the Snowflake connector with an OAuth connection, you must configure Snowflake, Salesforce, CRM Analytics, and an external OAuth authorization server. You can’t use a custom authorization provider.
            Snowflake VPC Connection
            • Username and password
            • OAuth
            		 To use the Snowflake VPC connector, in Setup, configure an outbound network connection, external credential, and named credential. This connector supports OAuth 2.0 for authentication, which requires additional setup steps in Snowflake and the Salesforce credentials. You must configure your Snowflake for Private Link.
            Zendesk Connection Username and password  
            • Amazon Athena Connection
              Sync Amazon Athena to CRM Analytics by creating a remote connection.
            • 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.
            • Amazon Redshift Connection
              Create a remote connection using the Amazon Redshift connector to sync data from Amazon Redshift to CRM Analytics.
            • Databricks Connection
              Sync Databricks to CRM Analytics by creating a remote connection..
            • Google BigQuery Standard SQL Connection
              Bring your large volumes of Google BigQuery data with standard SQL support into CRM Analytics using the Google BigQuery Standard SQL connector.
            • Google BigQuery for Legacy SQL Connection
              Create a remote connection using the Google BigQuery connector to sync data from Google BigQuery to CRM Analytics.
            • Google Cloud Spanner Connection
              Create a remote connection using the Google Spanner connector to sync data from Google Cloud Spanner to CRM Analytics.
            • Heroku Postgres Connection
              Create a remote connection using the Heroku Postgres connector to sync Heroku Postgres data to CRM Analytics.
            • Microsoft Azure Synapse Analytics Connection
              Create a remote connection using the Microsoft Azure Synapse Analytics connector to sync data from Azure Synapse Analytics or dedicated SQL pool (formerly SQL DW) to CRM Analytics. To connect to SQL databases on Azure, add an Azure SQL Database Connection instead of this one.
            • Microsoft Azure SQL Database Connection
              Create a remote connection using the Microsoft Azure SQL Database connector to sync data from Microsoft Azure SQL Database to CRM Analytics. To connect to Microsoft Azure Synapse Analytics or a dedicated SQL pool (formerly SQL DW), add a Microsoft Azure Synapse Analytics connection instead of this one.
            • SAP HANA Cloud Connection
              Create a remote connection using the SAP HANA Cloud connector to sync data from cloud-based SAP HANA to CRM Analytics.
            • Snowflake Connection
              Create a remote connection using the Snowflake connector to sync data from Snowflake to CRM Analytics. This connector supports private key or OAuth 2.0 for authentication. Using OAuth 2.0 requires additional setup steps in Snowflake and the Salesforce credentials.
            • Zendesk Connection
              Create a remote connection using the Zendesk connector to sync data from Zendesk to CRM Analytics.
             
            Loading
            Salesforce Help | Article