Skip to main content

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
If you do not know your credentials, reach out to your Microsoft account representative.

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.

Once you have entered valid Azure Blob Storage credentials, you can use the same account any time you go to create a new Azure Blob Storage DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

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/
Do not include the container name.

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.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.