You can import data from Azure Blob Storage to create or update source datasets in Anaplan Data Orchestrator (ADO). To import data, you need a connection to Azure Blob Storage and either a pipeline or a connection extract.

You must first create a connection to Azure Blob Storage with the Azure Blob Storage connector in Data Orchestrator. Then use that connection to either create a pipeline or use a connection extract for data import.

Prerequisites

Before you create a connection and import data, you need to meet these connectivity and CSV file prerequisites.

Connectivity prerequisites

Before you can create a connection to Azure Blob Storage, you need to meet these prerequisites.

ItemNotes
Azure Blob Storage accountA storage account hosted on Azure Blob Storage.
Azure Blob Storage user with account permissions

A user with access to the storage account.

The user also must have at least read permissions to the container and objects.

Authentication method for Azure Blob Storage

For the authentication method, you can use either:

  • Storage Account Key: Azure Secret Key is required to connect with this method.
  • OAuth: A client ID, client secret, Azure tenant ID, and refresh token are required to connect with this method.
Azure Blob Storage connection details

You need these account details based on your authentication method (Storage Account Key or OAuth).

For Storage Account Key you need:

  • Azure secret key
  • Azure Blob Storage account name
  • Container name
  • Endpoint URL (optional)

For OAuth you need:

  • Client ID
  • Client secret
  • Azure tenant ID
  • Refresh tokey
  • Azure Blob Storage account name
  • Container name
  • Endpoint URL (optional)
Azure Blob Storage folder pathFolder path to a subset of the container.

CSV file prerequisites

CSV files uploaded to Data Orchestrator must be UTF-8 encoded. See File requirements for Anaplan Data Orchestrator for more information about CSV file requirements.

Create a connection to Azure Blob Storage

You will need your Azure Blob Storage credentials to connect the Azure Blob Storage data with Data Orchestrator. View the Azure Blob Storage documentation for more information about your credentials.

To create a connection:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Connections from the left-side panel.
  4. Select Create connection.
  5. Select the Azure Blob Storage connector and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. Enter these details on the Connection details screen, and then select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Enter a description about your connection.
  7. Enter your Azure Blob Storage credentials on the Connection credentials screen, and then select Next.
    For information about the fields on this page, see Authentication options for Azure Blob Storage connections.
  8. After the connection test is complete, select Done.

Import data

You can import data from Azure Blob Storage with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.