Learn how to export data from Singular automatically to Microsoft Azure Storage.
Note: Data destinations are an enterprise feature (learn more).
Step 1: Get a Storage Account
- Log into your Microsoft Azure account and go to the Portal.
Under Azure services, select Storage Accounts.
Under Create storage account:
- Choose a Resource group or create a new one.
- Enter an Account Name.
- You can leave the default values in rest of the fields.
- Click Review + Create.
- Click Create.
Wait for the deployment to finish. Once the message "Your deployment is complete" appears, click Go to Resource.
Step 2: Grant the Necessary Permissions
In the resource page, select Shared access signature in the right sidebar (if the sidebar is not visible, click the arrows in the upper left corner).
In the Shared access signature settings page:
- Under Allowed services, make sure all the checkboxes are checked.
- Under Allowed resource types, check all the checkboxes (they are not checked by default).
- Under Allowed permissions, make sure all the checkboxes are checked.
Set the expiry date to a few years in the future.
- Click Generate SAS and connection string.
In the list of strings and URLs that is now displayed, find the Connection String and copy it.
Step 3: Set Up the Destination in Singular
- In your Singular account, go to Settings > Data Destinations.
- Type "Azure Storage" in the search box and click it in the dropdown list.
In the Add Connector window:
Under Folder Name, enter the outermost folder in which you want the data saved in your Azure Storage container.
Under Connection String, paste in the connection string you generated in Azure.
Under Data Schema, select the type of data you want to export to Azure. For your schema options, see Data Destinations: Aggregated Marketing Data Schemas and Data Destinations: User-Level Data Schemas.
- Click Save.