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. After data has been collected in the central warehouse, data teams can explore Braze data effectively using their preferred business intelligence tools.

Prerequisites

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.

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 (such as Fivetran), and click Create Role. After the role is created, click it and note the Role ARN shown.

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.

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.

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!