"Send file to Azure Blob Storage" node
The integration between Synerise and Azure Blob Storage opens up possibilities of exporting data collected in Synerise. By means of the Send file node, you can push data from Synerise to add save it as a blob in your Azure storage. You can use this connection in various scenarios such as exporting transactions, event data, customer information (such as marketing agreements), results of metrics, aggregates, expressions, reports, and many more to Azure Blob Storage.
You must have an account on Azure AD.
- Click Azure Blob Storage > Send file.
- Click Select connection.
- From the dropdown list, select the connection.
Create a connection
To allow the data exchange, establish a connection between Synerise and Azure Blob Storage.
- At the bottom of the Select connection dropdown list, click Add connection.
- In the Blob SAS URL, enter the Blob shared access signature (SAS) URL that allows access to a storage account and/or containers and blobs. You can generate it in your Azure AD account.
- Confirm by clicking Apply.
Define the integration settings
In this step, fill in the form that allows you to send data from Synerise to Azure Blob Storage.
- In the Container field, enter the name of an existing container in your storage.
If this field is already filled out, it means that the URL used in the connection settings contains the name of the container.
- In the Blob name field, enter the name of the blob (file) you want to send to the storage.
If this field is already filled out, it means that the URL used in the connection settings contains the name of the blob. In such case, the contents of the blob will be overwritten.
You can use Jinjava in this field.
- From the File format dropdown list, select the format in which the file will be saved in the storage.
If you select the CSV [*.csv] option, follow the instructions below:
- From the Delimiter dropdown, select the character that separates fields in a row.
- From the Quotation mark dropdown list, select the characters that contain the text.
- From the Escape character dropdown list, select the character which changes the default interpretation of a character or a string followed by the character.
- From the Line ending dropdown list, select:
- Line feed - This option shifts the cursor to the next line vertically.
- Carriage return and line feed - This option points the cursor to the beginning of the line horizontally and shifts the cursor to the next line vertically.
- The No Byte Order Mark option is currently unused.
- To wrap the values with characters selected in the Quotation mark field when the delimiter occurs in the value, select the Quoting style only if required option. For example, for the following values:
The output with the enabled Quoting style only if required option will be as follows:
- Confirm by clicking Apply.
Example of use
You can create a workflow that is triggered one time in order to export the customer database (email addresses and newsletter agreements) to the storage.
As a prerequisite for this example, create a segmentation of customers who have email addresses and enabled newsletter agreements. This segmentation will be used in the Get Profiles node that will be a part of the workflow.
In the configuration of the workflow:
- Start the workflow with the Scheduled Run node. In the configuration of the node, set the Run trigger to one time. Select the Immediately tab.
- To retrieve customers data to the workflow, as the next node, select Synerise > Get Profiles. In the configuration of the node:
- Select a segmentation from which you want to extract customers’ data.
- Select the customer attributes to be exported. In this example, it’s an email address and email marketing agreement.
- To send the file with customers data, add Azure Blob Storage > Send file. Fill in the configuration form in the node.
- Add the End node.