---
schema_version: "1"
id: e0bf6f55f947eb549479e5693bcc5a801b177c3efd7904c6a412729fd01a337b
title: Heroku Postgres 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_heroku_postgres_settings.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_heroku_postgres_settings.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8aa2dcebb34c4a065ad79a1e9ec1b2a86ab6750f9e8abb8caaf7ab5b044c1c58
description: Create a remote connection using the Heroku Postgres connector to sync Heroku Postgres data to CRM Analytics.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Heroku Postgres Connection

Create a remote connection using the Heroku Postgres connector to sync Heroku Postgres data to CRM Analytics.

## Connection Requirements

To access Heroku Postgres in Heroku Private Spaces, complete these steps before you create the connection.

1. Contact Heroku Support to activate Trusted IP ranges for data services in the space. Trusted IP ranges for data services is a beta feature.
2. Although allowing designated IPs isn’t usually the preferred or recommended practice, in most cases, you must add the Salesforce IP ranges to the Trusted IP ranges in the space. See the [Salesforce Core Services - IP Addresses and Domains to Allow](https://help.salesforce.com/s/articleView?id=000384438&type=1&language=en_US) knowledge article for a list of first-party Salesforce IP ranges. To use this connector with Hyperforce, use the IPs listed in [Hyperforce IPs to Allow - Sales, Service, Industries, and Tableau Clouds](https://help.salesforce.com/s/articleView?id=003876184&type=1&language=en_US).

## 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. Go to the database in Heroku and click **View Credentials...** to access the values for the connection settings.

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191907e104 ">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="Connection Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d191907e101 ">Description</td>

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191907e104 ">
              <p>URL schema for the database. Enter in the format:
                <kbd>jdbc:postgresql://&lt;host&gt;:&lt;port&gt;/&lt;database&gt;</kbd>
              </p>
              <div>
                <p>Look
                  for the host, port, and database details in the database credentials. 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>jdbc:postgresql://ec1-23-45-67-89.compute-2.amazonaws.com:5112/a1b2c3</code></pre>
              </div>
            </td>

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191907e104 ">The database user, found in the database credentials.</td>

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191907e104 ">The name of the schema you want to use for the database. If no schema names
              have been specified for the database, you can enter
              <kbd>public</kbd>.
            </td>

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191907e104 ">The database password, found in the database credentials.</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. 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**.

For the Heroku Postgres connector, enter a filter using the syntax described in the [Heroku Postgres Help](https://devcenter.heroku.com/categories/postgres-basics) and your version of [Postgres’s Help](https://www.postgresql.org/docs/current/sql-select.html).

## Heroku Postgres Connector Considerations

Keep these behaviors in mind when working with the Heroku Postgres 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 100 million rows or 50 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 data available for sync is determined by the security settings of the user that you use to connect.
- This connector is available to Heroku Private Spaces users that are also Hyperforce customers.

#### See Also

- [Heroku Postgres Connector Known Issues and Knowledge Articles](https://sfdc.co/hpconnsearch)
- [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.")