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 Domo’s Microsoft Azure Blob Storage connector to pull CSV, TSV, and TXT 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 connect to your Microsoft Azure Blob Storage account in the Data Center. This topic discusses the fields and menus that are specific to the Azure Blob Storage 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 connect to your Azure Blob Storage account and create a DataSet, you must have the following:- Your Microsoft Azure Blob Storage account name
- Your Microsoft Azure Blob Storage account key
Connecting to Your Azure Blob Storage Account
This section enumerates the options in the Credentials and Details panes on the Azure Blob Storage Connector page. The components of the other panes on 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 account. The following table describes what is needed for each field:Field | Description |
|---|---|
Account Name | Enter your Microsoft Azure Blob Storage account name. |
Account Key | Enter your Microsoft Azure Blob Storage account key. |
Details Pane
This pane contains various options for selecting and configuring the file you want to import into Domo.Menu | Description |
|---|---|
What File Type Would You Like to Import? | Select whether you want to pull a CSV, TSV, TXT, XLS, or XLSX file into Domo. |
Select File Compression Type | Select the compression type of your file. |
Blob Containers | Select the desired container. |
File Encoding | Select the file encoding. By default, UTF-8 is selected. |
Date Format | Select the date format used in the selected file. |
Blob Search Type | Select whether you want to filter the blobs with simple or advanced options. |
Limit the Search To Directory | Enter the path to limit the search to a directory, subdirectory. Leave it empty if you want to search for the blob in the container root and all directories. For example directory/subdirectory/nesteddirectory/ |
Blob Name | Enter partial or full name of the blob (Do not include extension). |
Blob Name Match Type | Select how to match the blob names in Azure with the provided Blob Name. |
Ignore Case (checkbox) | Should Domo ignore the cases while matching the provided Blob Name? |
Invert Match (checkbox) | Pull the files with the provided prefix that do not match the provided criteria of Blob Name match |
Advanced Filter For Blobs | The All Blobs option is selected by default and the connector pulls all the blobs for the configured dataset. The Latest Updated Blobs option pulls all the latest updated blobs for the configured dataset. The Recent Blob option pulls only the latest blob from all the obtained blobs for the configured dataset. |
Does Your Blob Containers Have Directories? | Select ‘Yes’ if your blob containers have directories. |
Blob Directories | Select the blob directory. |
Select Block Blob | Select the desired file. |
Pull All Files (checkbox) | Select this checkbox if you would like to pull all files from a directory. |
How Would You Like To Choose Your Block Blob? | Specify whether you would like to select your block blob or enter it manually. |
Enter Block Blob | Enter the desired file name. |
Block Blob Match Type | Specify whether the block blob should start with or contain the name you have entered in Enter Block Blob . |
Blobs Search Type | Select whether you want to filter the blobs with simple or advanced options. |