Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Connecting Braintree

Braintree Info
This integration was created by Stitch for Singer, an open-source, composable ETL platform. Check out & contribute to the repo on GitHub.

Braintree is currently in Open Beta. The info in this article is subject to change.

Connecting Stitch to Braintree is a four (sometimes five)-step process:

  1. Whitelist Stitch’s IP addresses in Braintree *
  2. Retrieve your Braintree API credentials
  3. Add Braintree as a Stitch data source
  4. Define the Historical Sync
  5. Define the Replication Frequency

* This step is only required if you restrict IP access to your Braintree account.

Prerequisites

To successfully complete the setup in Stitch, you must have:

  1. Access to a Production Braintree account. Stitch does not currently support connecting to Sandbox accounts.
  2. Super Admin and API Access permissions in Braintree. This is required to create the API access token in Braintree. You can find info on Braintree user roles and permissions here.

Additionally, our Braintree integration will only replicate transactions for the default merchant account in your Braintree instance. You can verify the merchant account set as the default by going to Settings > Processing > Merchant Accounts when signed into Braintree.

Whitelisting Stitch’s IP Addresses in Braintree

This step is only required if you restrict IP access to your Braintree account. If you don’t use this feature, skip to the next section.

If you use Braintree’s IP restriction feature, you’ll need to whitelist Stitch’s IP addresses before you can successfully connect Braintree to Stitch.

  1. Sign into your Braintree account.
  2. Click Settings > Security.
  3. In the Security Options page, click Edit in the IP and Hostname Restrictions section.
  4. In the IP Address or Hostname field, paste one of the IP addresses from the following list:
    • 52.23.137.21/32
    • 52.204.223.208/32
    • 52.204.228.32/32
    • 52.204.230.227/32
  5. Check the Allow API Access box.
  6. Click Add Allowed Host.
  7. Repeat steps 4-6 for each Stitch IP address in the list above.
  8. After all of Stitch’s IP addresses have been added, click Enable Restrictions.

Retrieving Your Braintree API Credentials

  1. If you haven’t already, sign into your Braintree account.
  2. Click Account > My User.
  3. Scroll down to the API Keys, Tokenization Keys, Encryption Keys section and click View Authorizations.
  4. In the API Keys section, click Generate New API Key.
  5. After the key has been generated, click the View link in the Private Key column.
  6. This will display the Client Library Key page, which contains your Braintree API credentials:

    braintree-api-credentials.png

Leave the Braintree Client Library Key page open for now - you’ll need the Public Key, Private Key, and Merchant ID to complete the setup in Stitch.

Adding Braintree as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Braintree icon.
  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch Braintree” would create a schema called stitch_braintree in the data warehouse. This schema is where all the tables for this integration will be stored.
  4. In the Merchant ID field, paste your Braintree Merchant ID.
  5. In the Public Key field, paste your Braintree Public Key.
  6. In the Private Key field, paste your Braintree Private Key.

Defining the Historical Sync

The Sync Historical Data setting will define the starting date for your Braintree integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to sync data beyond Braintree’s default setting of 1 year. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Defining the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your Braintree integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Note that the more often Braintree is set to replicate, the higher your row count will be. Even if all the tables in your Braintree integration use Incremental Replication, replicating data frequently will increase your usage.

Stitch & Replicating Braintree Data
Before setting the Replication Frequency, we recommend checking out the structure & Replication Methods for this integration’s tables. Tables that contain nested structures and/or use Full Table Replication will lead to a higher number of replicated rows.<

To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes.

For more tips on reducing your row count, check out the Reducing Your Row Count article.

After setting the Replication Frequency, click Save Integration to wrap things up.

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!