Intro
Microsoft Azure Blob Storage is designed to easily and efficiently store any type of unstructured data, such as images, videos, audio, and documents. Use this connector to pull data files from your Microsoft Azure Blob Storage account into Domo. Combine your Azure data with data from other data sources throughout your company for a comprehensive view of your business. Set up custom alerts to be notified in real-time when your key metrics change, so you can make faster, better business decisions. To learn more about the Azure Blob Storage API, visit their page (https://docs.microsoft.com/en-us/res…rvice-rest-api ). You export data to Azure Blob Storage in the Data Center. This topic discusses the fields and menus that are specific to the Azure Blob Storage SAS Token connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Connector.Prerequisites
To configure this connector, you will need the following:- The Storage Account Name
- An Account access level SAS token
Note: This connector works only with the account access level SAS token. So, if you receive an authentication error, please confirm if you are entering a container access level token instead.
Configuring the Connection
This section enumerates the options in the Credentials and Details panes in the Azure Blob Storage SAS Token Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your Azure Blob Storage container. The following table describes what is needed for each field:Field | Description |
|---|---|
| Account Name | Enter the storage account name. |
| Shared Access Signature (SAS) Token | Enter your account access level SAS token . |
Details Pane
This pane contains a number of fields for specifying your data and indicating where it’s going.Menu | Description | ||||
|---|---|---|---|---|---|
| What file type would you like to import? | Select the file type you want to import. | ||||
| Blob Containers | Select the Azure Blob container you want to send your Domo data to. | ||||
| How would you like to choose your Blob? | Specify how would you like to pull your blob file. | ||||
| Enter Blob Name Prefix | Enter the blob name prefix. | ||||
| Blob Match Type | In the Enter Blob Name Prefix, specify whether the blob should contains, startsWith or endsWith the name you have entered. | ||||
| File Encoding | Select the file encoding. By default, UTF-8 is selected. | ||||
| Advanced |
| ||||
Input DataSet ID | Enter the DataSet ID (GUID) for the DataSet you want to copy to the selected Azure Blob Storage container. You can find the ID by opening the details view for the DataSet in the Data Center and looking at the portion of the URL following datasources/. For example, in the URL https://mycompany.domo.com/datasources/845305d8-da3d-4107-a9d6-13ef3f86d4a4/details/overview , the DataSet ID is 845305d8-da3d-4107-a9d6-13ef3f86d4a4. | ||||
| Select Filename | Select whether you want to reference your DataSet using the Input DataSet ID or an output file name. | ||||
| Filename | Enter the output file name for your data. |
Advanced
| Menu | Description |
| Select the delimiting character | Select the delimiting character used in your file. If your delimiter is not listed select ‘Other. |
| Specify your delimiter | Enter the character used to delimit your character separated values (CSV) text. |
| Quote Character | Select the desired quote character for parsing CSV files (Double quote is the default quote character for CSV standard.) |
| Custom Quote Character | Enter the desired CSV Quote character. |
| Escape Character | Select the desired escape character for parsing CSV files. |
| Custom Escape Character | Enter the desired CSV escape character. |