Azure Table Connection

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium Azure Table connector.

Azure Table is a project management tool.

This topic describes how to authenticate to Azure Table and configure any necessary connection properties in the Azure Table connection connector.

Connection Configuration #

Each connection property available in the Azure Table connector is explained below.

Connection Name #

The name of the connection to be created should be provided. This is the name that will display on the list of available connections.

Account #

The Windows Azure Storage account name.

To access your Azure storage accounts or create one, log into the Azure portal.

Click Storage Accounts in the services menu on the left.

If the connection property ‘Backend’ is set to AzureStack, set the Account as the complete host for your data.

Example: .nm.azs.sandia.gov

If ‘Backend’ is set to Emulator, set the Account as the complete host.

Example: http://127.0.0.1:10002/devstoreaccount1

AuthScheme #

The scheme used for authentication. Accepted entries are AccessKey and SharedAccessSignature.

Together with Account, this field is used to authenticate against the service.

AccessKey: Indicates authentication will be done via AccessKey and Account. The default is AccessKey.

SharedAccessSignature: Indicates authentication will be done via SharedAccessSignature and Account. Generally Tables must also be set.

Access Key #

The key for the storage account.

To obtain the Access Key:

1. Log into the Azure portal.

2. Click Storage Accounts in the services menu on the left to list the storage accounts.

3. Select a storage account and click Access Keys in the Settings section.

   Either key1 or key2 can be used.

   If using CosmosDB as the ‘Backend’, instead navigate to Cosmos DB service and select your Azure Cosmos DB Account.

   From the resource menu, go to the Connection String page.

   Find the PRIMARY KEY value and set AccessKey to this value.

Shared Access Signature #

A shared access key signature that may be used for authentication instead of Access Key.

Backend #

The backend where data is stored.

Possible Values:

• AzureStack

• CosmosDB

• Storage

• Emulator

Data may be retrieved from either the classic Azure Table Storage repository, Azure Storage Emulator, or it may be retrieved from CosmosDB.

Alternatively, you may specify AzureStack if you are using Azure Stack Hub. If you choose to do so, specify the Account as the complete host for your data.

Example: < account >.nm.azs.sandia.gov

If you choose Emulator, specify the Account and SharedAccessSignature connection property.

Enable SSL #

Option for creating the connection with SSL enabled.

Upload Keystore File #

Option to upload the keystore file.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.

Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.