Search

Azure Table Storage

Azure Table Storage

Setup Guide

Follow these steps to connect Azure Table Storage to your CData Connect Cloud account:

  1. Open the Connections page of the CData Connect Cloud dashboard.

  2. Click + Add Connection in the upper-right corner.

  3. Type Azure Table Storage into the search field, then click the data source name.

  4. On the Basic Settings tab of the new connection, enter a connection name or keep the default name.

  5. Select an Auth Scheme and follow the relevant instructions below.

Authentication Methods

SharedAccessSignature

  1. Enter the following information:

    • Shared Access Signature—a valid signature of a resource to connect to. This signature may be generated with a tool such as Azure Storage Explorer. See Microsoft’s help page for more information about shared access signatures.

    • Account—the Azure Storage account name. To access your Azure storage accounts or create one, log into the Azure portal and click Storage Accounts in the services menu on the left. If the backend is set to AzureStack, set the Account as the complete host for your data. For example: <account>.nm.azs.sandia.gov. If the backend is set to Emulator, set the Account as the complete host. For example: http://127.0.0.1:10002/devstoreaccount1.

    • Backend—select the backend from the drop-down list. The backend is where the data is stored. Data may retrieved from the classic Azure Table Storage repository (Storage, the default), Azure Storage Emulator, CosmosDB, or Azure Stack Hub.

  2. At the top of the CData Connect Cloud Add Azure Table Storage Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

AccessKey

  1. Enter the following information:

    • Account—the Azure Storage account name. To access your Azure storage accounts or create one, log into the Azure portal and click Storage Accounts in the services menu on the left. If the backend is set to AzureStack, set the Account as the complete host for your data. For example: <account>.nm.azs.sandia.gov. If the backend is set to Emulator, set the Account as the complete host. For example: http://127.0.0.1:10002/devstoreaccount1. To obtain the account name for the backend of CosmosDB, navigate to Cosmos DB service and select your Azure Cosmos DB Account. From the resource menu, go to the Connection String page. Find the account name and set the Account to this value.

    • Access Key—the key for the storage account. To obtain the Access Key for the default backend (Storage), log into the Azure portal and click Storage Accounts in the services menu on the left to list the storage accounts. Select a storage account and click Access Keys in the Settings section. Either key1 or key2 can be used. To obtain the Access Key for the backend of CosmosDB, 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 the Access Key to this value.

    • Backend—select the backend from the drop-down list. Data may retrieved from the classic Azure Table Storage repository (Storage, the default), Azure Storage Emulator, CosmosDB, or Azure Stack Hub.

  2. At the top of the CData Connect Cloud Add Azure Table Storage Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

AzureAD

  1. Enter the following information:

    • Azure Tenant—(optional) the Microsoft Online tenant being used to access data. This value is the directory Id in Azure Portal > Azure Active Directory > Properties. If not specified, your default tenant is used.

    • Account—the Azure Storage account name. To access your Azure storage accounts or create one, log into the Azure portal and click Storage Accounts in the services menu on the left. If the backend is set to AzureStack, set the Account as the complete host for your data. For example: <account>.nm.azs.sandia.gov. If the backend is set to Emulator, set the Account as the complete host. For example: http://127.0.0.1:10002/devstoreaccount1.

    • Backend—select the backend from the drop-down list. Data may retrieved from the classic Azure Table Storage repository (Storage, the default), Azure Storage Emulator, CosmosDB, or Azure Stack Hub.

  2. At the top of the CData Connect Cloud Add Azure Table Storage Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

More Information

For more information about interactions between CData Connect Cloud and Azure Table Storage, see this information page.