If you manage the customers' data in several places at once, you can use Automation Hub to synchronize it. It's possible thanks to the HTTPS and SFTP integrations that allow you to send data from Synerise to external sources and the other way round.
This use case describes how to prepare an automated workflow that launches every day and sends the updated list of customers with the agreement for email communication from Synerise to an external resource using the SFTP protocol.
One of the challenges addressed in this use case is modifying the value of the customer attribute (a newsletter agreement attribute) so the data structure is consistent.
Prerequisites
- You must have customers in Behavioral Data Hub > Profiles.
- You must have a target resource with which you synchronize the data (in this use case, an SFTP server is used).
Process
- Create a segmentation of customers whose data you want to send to the external resource.
- Prepare a transformation to modify the data to meet the requirements of the external resource data structure.
- Prepare a workflow that sends the data of customers from Synerise to the external resource.
Prepare a segmentation
As the first part of the process, create a segmentation of customers who agreed to receive emails. Data of these customers will be sent to the external resource.
- Go to
Decision Hub > Segmentations > New segmentation.
- As the name of the segmentation, enter
Subscribers. - Click Add condition.
- From the dropdown list, select
newsletter_agreement. - As the logical operator, select Equal.
- In the text field, enter
enabled. - Click Save.

The configuration of the segmentation
Prepare a transformation
In this part of the process, you define the rules of modifying data before sending it to the SFTP server, so the data is consistent. For the purposes of this case, a newsletter_agreement parameter value will be changed from enabled to true. Additionally, we add a parameter which marks data as imported, so this import can be distinguished in the SFTP server.
The transformation which is the output of this part of the process is used later to automate sending the data.
Prerequisites
You need a sample of data that will be used in data transformation. You can add it in two ways:
- Prepare a
.csvfile with a few columns and example values.
Click here to see an example file
clientId,email,newsletter_agreement 111111111,john.doe@synerise.com,enabled 222222222,kathy.smith@synerise.com,enabled 333333333,lily.novak@synerise.com,enabled 444444444,matt.turner@synerise.com,enabled Export several customers from Behavioral Data Hub > Profiles to a
.csv file.Click here to read the instructions
- Go to Behavioral Data Hub > Profiles
- On the list, select several customers.
- At the top of the list, click the Export button.
- On the pop-up, enter the name of the export.
- Select three attributes: email, clientId, and newsletter_agreement.
- Click Apply.
- On the pop-up, click Go to Reports.
- On the list, find your export.
- Next to the export, click the
icon.
- From the context menu, select Download.
Result: A `.csv` file is downloaded.
- Go to
Automation Hub > Transformations > New transformation.
- Enter the name of the transformation.
- Click Upload a new file or drag one here.
Add file with sample data
This step allows you to add a data sample. In further steps, you define how the data must be modified. Later, when this transformation is used in the workflow, the system uses the rules created with the sample data as a pattern for modifying actual data.
- Upload the file with the sample data.
- Set Delimiter and provide Quotation mark and Escape character.
- Click Apply.

Edit the newsletter_agreement value
The Edit Values step allows you to replace the enabled value of the newsletter_agreement attribute with true.
- On the right panel, click Add step.
- From the dropdown list, select Edit Values.
- Click the Edit Values step.
- In the configuration of the step:
- Select the newsletter_agreement column.
- Under Edit values by, from the dropdown list, select Replacing.
- In the dropdown below, leave the Static value option at default.
- In the text field, enter
true. - Confirm by clicking Apply.

Add the parameter which marks data as imported
The Add Column step allows you to add a column to the data. As a result, you can easily identify the import in the external source (the SFTP server).
- On the right panel, click Add step.
- From the dropdown list, select Add Column.
In the configuration of the step:
- In the Add Column field, enter
importType. - In the dropdown, select Static value.
- In the text field, enter
synerise_subscribers. - Confirm by clicking Apply.

The configuration of the Add Column step - In the Add Column field, enter
Preview and save the transformation
- Preview the results in the Output tab.

The preview of modifications to the file - In the upper right corner, click Save.

The transformation configuration
Prepare a workflow
As the final part of the process, create a workflow which sends the customers' data every day to the external source using the SFTP protocol.
- Go to
Automation Hub > Workflows > New workflow.
- Enter the name of the workflow.
Define the launch date
- As the trigger node, add Scheduled Run.
- In the configuration of the node:
- Select the Repeat runs option.
- From the Timezone dropdown list, select the time zone consistent with the timezone selected for your workspace.
- Define the frequency of the workflow (for example, every day at 6.00 A.M.).
The workflow will automatically launch every day at 6.00 A.M. - Confirm by clicking Apply.

Select customers to export
- Add a Get Profiles node.
In the configuration of the node:
- Select Segments and then the segmentation you created in the first part of the process.
- In the Attributes values section, select newsletter_agreement and email.
- Confirm by clicking Apply.

The configuration of the Get Profiles node
Select the transformation
- Add a Data Transformation Studio node.
- In the configuration of the node, keep the default From workflow context option.
- In the editor, click Templates library:
- Select the transformation you have created before.
- Click Use template.
- Confirm by clicking Apply.

TIP: You can also create a transformation directly in the Data Transformation Studio node instead of selecting a template.
Configure settings for SFTP protocol
- Add the Send File node by clicking THEN > SFTP - Send File.
In the configuration of the node:
- Select the SFTP connection type as Public key, choose the connection in the Select connection field, and click Next.
- Enter the path to your server.
- Select the port.
- Enter the path to the directory.
- Enter the name of the file.
- If needed, in the File name suffix, select the suffix of the file name.
- From the File format dropdown list, select the CSV format.
- Verify and modify the delimiters if needed.
- Confirm by clicking Apply.

The configuration of the SFTP Send File node
Add the finishing node
- Add the End node.
- In the upper right corner, click Save & Run.
Result:
The workflow configuration
Check the use case set up on the Synerise Demo workspace
You can check the configuration of each item created in this use case on our Synerise Demo workspace:
If you’re our partner or client, you already have automatic access to the Synerise Demo workspace (1590), where you can explore all the configured elements of this use case and copy them to your workspace.
If you’re not a partner or client yet, we encourage you to fill out the contact form to schedule a meeting with our representatives. They’ll be happy to show you how our demo works and discuss how you can apply this use case in your business.
Generated events
This use case generates approximately 5 events per workflow execution:
automation.clientStartPath (~1), automation.clientPathStep (~3), automation.clientEndPath (~1).