---
schema_version: "1"
id: e2d786a319d5ed7785c5e00d99c69b91aa51b3fb5af276307b527deb93e82b78
title: Database Connectors
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_database_group.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_database_group.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f62c3bafdd71694735045a782073d7ad227d9fc500917e0a993763b3a558b5e7
description: Use these connectors to sync data from your external database services to CRM Analytics.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Database Connectors

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

<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:33.33333333333333%">
        <col style="width:33.33333333333333%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d201343e36">Connector Name</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d201343e39">Authorization Options/Auth Types</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d201343e42">Additional Information</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_amazon_athena.htm&amp;release=264.0.0&amp;type=5" title="Sync Amazon Athena to CRM Analytics by creating a remote connection.">Amazon Athena
              Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">
            <ul>
              <li>Standard authentication (Root)</li>

              <li>AWS Identity Access Management (IAM)</li>

            </ul>
          </td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">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.
          </td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_amazon_aws_rds_settings.htm&amp;release=264.0.0&amp;type=5" title="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 RDS Connection (Oracle)</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">
            <p>Available connectors:
            </p>
            <ul>
              <li>AWS RDS Aurora MySQL</li>

              <li>AWS RDS Aurora PostgreSQL</li>

              <li>AWS RDS MariaDB</li>

              <li>AWS RDS MySQL</li>

              <li>AWS RDS PostgreSQL</li>

              <li>AWS RDS SQL Server</li>

            </ul>
          </td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_redshift_settings.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the Amazon Redshift connector to sync data from Amazon Redshift to CRM Analytics.">Amazon Redshift Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">Before you create an Amazon Redshift connection, make sure that the Redshift
            cluster that you’re connecting to is SSL enabled.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_databricks.htm&amp;release=264.0.0&amp;type=5" title="Sync Databricks to CRM Analytics by creating a remote connection..">Databricks Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Personal access token (PAT)</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">M2M (OAuth) is scheduled for Winter '26 release.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_standard_sql.htm&amp;release=264.0.0&amp;type=5" title="Bring your large volumes of Google BigQuery data with standard SQL support into CRM Analytics using the Google BigQuery Standard SQL connector.">Google BigQuery Standard SQL Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Private key and client email</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">Use the <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_settings.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the Google BigQuery connector to sync data from Google BigQuery to CRM Analytics.">Google BigQuery for Legacy SQL Connection</a> instead of this connector if using legacy SQL.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_settings.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the Google BigQuery connector to sync data from Google BigQuery to CRM Analytics.">Google BigQuery for Legacy SQL Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Private key and client email</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">Use the <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_standard_sql.htm&amp;release=264.0.0&amp;type=5" title="Bring your large volumes of Google BigQuery data with standard SQL support into CRM Analytics using the Google BigQuery Standard SQL connector.">Google BigQuery Standard SQL Connection</a> instead of this connector if using standard SQL or when querying partitioned tables.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlecloudspanner_settings.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the Google Spanner connector to sync data from Google Cloud Spanner to CRM Analytics.">Google Cloud Spanner Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Private key and client email</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">&nbsp;</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_heroku_postgres_settings.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the Heroku Postgres connector to sync Heroku Postgres data to CRM Analytics.">Heroku Postgres Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">&nbsp;</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_microsoft_azure_sql_dw_settings.htm&amp;release=264.0.0&amp;type=5" title="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 Synapse Analytics Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Azure DW JDBC username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">&nbsp;</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_microsoft_azure_sql_db_settings.htm&amp;release=264.0.0&amp;type=5" title="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.">Microsoft Azure SQL Database Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">To connect to Microsoft Azure Synapse Analytics or a dedicated SQL pool (formerly SQL DW), add a <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_microsoft_azure_sql_dw_settings.htm&amp;release=264.0.0&amp;type=5" title="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 Synapse Analytics Connection</a> instead of this one.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_sap_hana_cloud.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the SAP HANA Cloud connector to sync data from cloud-based SAP HANA to CRM Analytics.">SAP HANA Cloud Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">&nbsp;</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_snowflake_settings.htm&amp;release=264.0.0&amp;type=5" title="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.">Snowflake Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">
            <ul>
              <li>Username and password</li>

              <li>OAuth</li>

              <li>Username, private key, and private key passphrase</li>

            </ul>
          </td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">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.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_snowflakevpc.htm&amp;release=264.0.0&amp;type=5" title="Pull your data securely from Snowflake into Data Manager using the Virtual Private Connection (VPC) for Snowflake input connector for CRM Analytics. To use the Snowflake VPC connector, you configure an outbound network connection, external credential, and named credential. 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.">Snowflake VPC Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">
            <ul>
              <li>Username and password</li>

              <li>OAuth</li>

            </ul>
          </td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">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.</td>

        </tr>
        <tr class="">
          <td data-label="Connector Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e36 "><a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_zendesk.htm&amp;release=264.0.0&amp;type=5" title="Create a remote connection using the Zendesk connector to sync data from Zendesk to CRM Analytics.">Zendesk Connection</a></td>

          <td data-label="Authorization Options/Auth Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e39 ">Username and password</td>

          <td data-label="Additional Information" class="slds-cell-wrap" style="vertical-align:top;" headers="d201343e42 ">&nbsp;</td>

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

- **[Amazon Athena Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_amazon_athena.htm&release=264.0.0&type=5)**  
    Sync Amazon Athena to CRM Analytics by creating a remote connection.
- **[Amazon RDS Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_amazon_aws_rds_settings.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_redshift_settings.htm&release=264.0.0&type=5)**  
    Create a remote connection using the Amazon Redshift connector to sync data from Amazon Redshift to CRM Analytics.
- **[Databricks Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_databricks.htm&release=264.0.0&type=5)**  
    Sync Databricks to CRM Analytics by creating a remote connection..
- **[Google BigQuery Standard SQL Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_standard_sql.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_settings.htm&release=264.0.0&type=5)**  
    Create a remote connection using the Google BigQuery connector to sync data from Google BigQuery to CRM Analytics.
- **[Google Cloud Spanner Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlecloudspanner_settings.htm&release=264.0.0&type=5)**  
    Create a remote connection using the Google Spanner connector to sync data from Google Cloud Spanner to CRM Analytics.
- **[Heroku Postgres Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_heroku_postgres_settings.htm&release=264.0.0&type=5)**  
    Create a remote connection using the Heroku Postgres connector to sync Heroku Postgres data to CRM Analytics.
- **[Microsoft Azure Synapse Analytics Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_microsoft_azure_sql_dw_settings.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_microsoft_azure_sql_db_settings.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_sap_hana_cloud.htm&release=264.0.0&type=5)**  
    Create a remote connection using the SAP HANA Cloud connector to sync data from cloud-based SAP HANA to CRM Analytics.
- **[Snowflake Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_snowflake_settings.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_zendesk.htm&release=264.0.0&type=5)**  
    Create a remote connection using the Zendesk connector to sync data from Zendesk to CRM Analytics.