Grouparoo

Grouparoo is an open-source reverse ETL tool that makes it easy to power your marketing, sales, and support tools using the data in your warehouse. Configuration is done in a model-centric UI, making it possible for non-technical team members to configure and schedule data syncs in support of operations.

The Braze and Grouparoo integration makes it easy to operationalize data stored in a warehouse by sending it to Braze. When you set up automatic sync schedules, you can consistently enhance customer communications with up-to-date information.

Prerequisites

Requirement	Description
Grouparoo account and project	A Grouparoo account and project are required to take advantage of this partnership. This integration is possible to use with the free community edition and enterprise solutions provided by Grouparoo. Setup will take place in the Grouparoo configuration user interface.
Braze REST API key	A Braze REST API key with users and track permissions. This can be created in the Braze dashboard from Settings > API Keys.
Braze REST endpoint	Your REST endpoint URL. Your endpoint will depend on the Braze URL for your instance.

Integration

Step 1: Create a Braze app in Grouparoo

In Grouparoo, navigate to Apps and select Braze to create a new Braze app. In the modal that appears, provide your Braze API key and REST endpoint.

Step 2: Set up a model and data source

This integration requires that you have an existing model and data source set up before continuing to the next step. If you do not have this set up, visit the Grouparoo documentation to learn how to set up a model and data source.

Step 3: Create a Braze destination in Grouparoo

Select sync mode

In Grouparoo, select your model from the navigation bar. Next, scroll to the Destinations section and click Add new Destination.

Next, select the Braze app you made, name the destination, and select your desired sync mode from the following:

• Sync: Add, update, and remove Braze users as needed. This option looks for new records, changes to existing records, and deletions.
• Additive: Add and update Braze users as needed, but do not remove anybody. This option looks for new users to add to Braze and changes to existing Braze users but does not keep track of deletions.
• Enrich: Only update those users that already exist in Braze. Do not add or remove Users. This option will only update existing users in Braze.

Property field mapping

Next, you must map Grouparoo property fields to Braze property fields.

Make sure the Braze external_id field is mapped to the primary key in your source table. Map the rest of the fields as necessary for your use case.

Send Record Properties section: A list of preset user profile fields available to map data. Any of these can be synced to from Grouparoo properties.

Optional Braze User Profile Fields section: Create optional custom Braze user profile fields. If you click Add New Braze User Profile Field, you will see all the available properties you can map to Braze. The name of any new field you create will be the same as the Grouparoo property but can be renamed.

Grouparoo groups

In addition to mapping, you may also choose to add Grouparoo groups to Braze subscription groups.