Export data efficiently to Azure Blob Storage by creating a connection string and configuring a workflow. This process enables seamless data transfer, supporting various file types such as JSON, XML, and CSV.

Create a connection string

To create a connection string:

  1. Create a container to start an SAS URL for the Azure Blob.
    Ensure permissions for Create and Write to the container are selected, and the Expiration Date is correctly defined. If the Blob container will also be used for imports to the system, you must select the Read permission.
  2. Navigate to the Configure menu and select + in the Connection String section to add a new data source.
  3. Enter a name for the DataSource in the Create DataSource dialog box. Now, select Azure Blob Storage from the Provider dropdown.
  4. Paste the SAS URL into Details. 
  5. Select OK and save the changes.
    The Azure Blob container can now be used as a destination when exporting a Model or a Model view.

Create the Anaplan Financial Consolidation Workflow

  1. Create a new process in Explorer. 
  2. Enter a name for the process and select Create.
  3. Select Task Toolbar in the workflow and expand the Application section.
  4. Drag and drop the Model Export object into the white space. Now, highlight the Model Export object and select the pencil icon to edit the properties.
  5. Enter a name and select what type to export in the Properties dialog box. 
    1. Select the model or model view from the dropdown.
    2. Enter the connection string created earlier as the Destination. 
    3. Enter name for the Blob container.
    4. Select the type of file to be created. JSON, XML, and CSV are supported file types.
  6. Select OK and save the workflow changes.
  7. Run the workflow to write an extract of the model or model view to the Blob container.

Note: Extracts are stored in a .zip format, which contains the output in the file format selected.