Skip to content

Fivetran

Fivetran is a globally recognized brand whose analyst-focused products and fully managed pipelines enable data-backed decisions by delivering ready-to-query data into your cloud warehouse.

The Braze and Fivetran integration allows users to create a zero-maintenance pipeline that enables you to collect and analyze Braze data by connecting all of your applications and databases to a central warehouse. Once data has been collected in the central warehouse, data teams can explore Braze data effectively using their preferred business intelligence tools.

Prerequisites

Requirement Description
Fivetran account A Fivetran account is required to take advantage of this partnership.
Braze REST API key A Braze REST API key with the following permissions:
- users.export.ids
- users.export.segment
- email.unsubscribe
- email.hard_bounces
- messages.schedule_broadcasts
- campaigns.list
- campaigns.details
- canvas.list
- canvas.details
- segments.list
- segments.details
- purchases.product_list
- events.list
- feed.list
- feed.details
- templates.email.info
- templates.email.list
- subscription.status.get
- subscription.groups.get

This can be created within the Braze Dashboard > Developer Console > REST API Key > Create New API Key.
Braze REST endpoint Your REST Endpoint URL. Your endpoint will depend on the Braze URL for your instance.
Braze Currents Braze Currents should be connected to either Amazon S3 or Google Cloud Storage.
Amazon S3 or Google Cloud Storage This integration requires you have access to one Amazon S3 or Google Cloud Storage.

Integration

The following Currents integration is supported for both Amazon S3 and Google Cloud Storage.

Setting up Braze Currents for S3

Step 1: Locate your external ID

In the Fivetran Dashboard, click on + Connector and select the Braze connector to launch the setup form. Next, select Amazon S3. Note the external ID provided here; you will need it to allow Fivetran to access your S3 bucket.

The Fivetran set up Braze connector form. The external ID field needed for this step is located in the middle of the page in a light grey box.

Step 2: Give Fivetran access to a specified S3 bucket

Creating an IAM policy

Open the Amazon IAM Console and navigate to Policies > Create Policy.

Next, click on the JSON tab and paste the following policy. Make sure to replace {your-bucket-name} with the name of your S3 bucket.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
{
"Version": "2012-10-17",
"Statement": [
    {
      "Effect": "Allow",
      "Action": [
"s3:Get*",
"s3:List*"
      ],
      "Resource": "arn:aws:s3:::{your-bucket-name}/*"
    },
    {
      "Effect": "Allow",
      "Action": [
"s3:Get*",
"s3:List*"
      ],
      "Resource": "arn:aws:s3:::{your-bucket-name}"
    }
  ]
}

Lastly, click Review Policy and give the policy a unique name and description. Click Create Policy to build your policy.

Create an IAM role

In AWS, navigate to Roles, then select Create New Role.

Select Another AWS Account and provide the Fivetran account ID 834469178297. Make sure to check the Require external ID checkbox. Here, you will provide the external ID found in step 1.

Next, click Next: Permissions to select the policy you just created.

Click Next: Review, name your new role (i.e., Fivetran), and click Create Role. Once created, click the role you just created, and note the Role ARN shown.

The Amazon S3 ARN listed in the role.

Step 3: Complete the Fivetran connector

In Fivetran, click on + Connector and select the Braze connector to launch the setup form. Within the form, fill the given fields with the appropriate values:

  • Destination schema: A unique schema name.
  • API URL: Your Braze REST API endpoint.
  • API Key: Your Braze REST API key.
  • External ID: The external ID set in step 2 of the Currents set up directions. This ID is a fixed value.
  • Bucket: Found in your Braze account by navigating to Integration > Currents > [Your Current name] > Bucket Name.
  • Role ARN: The Role ARN can be found in step 1 of the Current setup directions.

Lastly, click Save & Test, and Fivetran will do the rest by syncing with the data from your Braze account!

Setting up Braze Currents for Google Cloud Storage

Step 1: Retrieve your Fivetran email from Google Cloud Storage

In the Fivetran dashboard, click on + Connector and select the Braze connector to launch the setup form. Next, select Google Cloud storage. Make a note of the email address that appears.

The Fivetran set up Braze connector form. The email field needed for this step is located in the middle of the page in a light grey box.

Step 2: Grant bucket access

Navigate to your Google Storage Console and select the bucket you configured Braze Currents with, and click on Edit bucket permissions.

The Google Storage Console available buckets. Locate a bucket and click the vertical three dot symbol to open the drop down that allows you to edit bucket permissions.

Next, grant Storage Object Viewer access to the email from step 1 by adding the email as a member. Make a note of the bucket name; you will need it in the next step to configure Fivetran.

Step 3: Complete the Fivetran connector

In Fivetran, click on + Connector and select the Braze connector to launch the setup form. Within the form, fill the given fields with the appropriate values:

  • Destination schema: A unique schema name.
  • API URL: Your Braze REST API endpoint.
  • API Key: Your Braze REST API key.
  • Bucket Name: Found in your Braze account by navigating to Integration > Currents > [Your Current name] > Bucket Name.
  • Folder: Found in your Braze account by navigating to Integration > Currents > [Your Current name] > Prefix.

Lastly, click Save & Test, and Fivetran will do the rest by syncing with the data from your Braze account!

WAS THIS PAGE HELPFUL?
New Stuff!