Create a destination connection

Setup credentials for AzureBlob

To set up an AzureBlob destination connection, you need the following setup credentials for the AzureBlob.

• container
• azure shared access signature (SAS uri)
• account

  These credentials are located in the url of the Azure blob storage to which the extracted data needs to be uploaded.

  See also Retrieving the credentials for the Azure blob storage.

Determine the setup parameters from the upload url as described below.

Example

The table below displays the parameters retrieved from the example download uri:

https://pmdoctestcd.blob.core.windows.net/c7045b18-be6f-4534-2fba-0b1f42c1e6d3?sv=2020-06-10&si=sap-c7044b18-be8f-4534-8fba-0b2f42c1e7c7&sr=c&sig=cjknPMhIeHvaKtpMgNFmUVp7KHQirhR1m1WCMkCiZUg%3D

Parameter	Description	Example
azure access signature	everything after the question mark	sv=2020-06-10&si=sap-c7044b18-be8f-4534-8fba-0b2f42c1e7c7&sr=c&sig=cjknPMhIeHvaKtpMgNFmUVp7KHQirhR1m1WCMkCiZUg%3D
account	the first part of the url	pmdoctestcd
container	the app id, or the first guid in the url	c7045b18-be6f-4534-2fba-0b1f42c1e6d3

Setup the AzureBlob destination connection

Follow these steps to create the AzureBlob destination connection.

Step	Action
1	Define a new connection of type AzureBlob.
2	Check if CData AzureBlobDestination Provider CData AzureBlobDestination Provider is 22.0.8348.0 or higher. See also Loading data using CData Sync
3	Enter a descriptive name for the destination connection. For example, AzureBlob_IM.
4	Enter the AzureBlob credential parameters retrieved from the upload url. Select SAS as the Auth Scheme. Enter the Azure Shared Access Signature (SAS uri).
5	Go to the Advanced tab and locate the Other section. Set Insert Mode to SingleFile. Set Include Column Headers to True.
6	Create and test the connection.

See the illustration below for an example.