Connecting to Azure Table / Azure Cosmos DB
This article shows how to connect to data stored in Microsoft Azure Table storage or Azure Cosmos DB tables.
When connecting to Azure Cosmos DB, accounts using the Azure Table API are supported.
2. Azure resource
Use the Azure Portal to set up your service resource. You will need either an Azure Storage resource or an Azure Cosmos DB resource set up that the Dundas BI server computer can access via its network/IP address.
You will need the connection string to access your resource to add a data connector for it in Dundas BI.
2.1. Azure Storage tables
The connection string is one of the Access Keys for the account, which you can find from the Azure Portal once the resource is set up, and you can copy it to the clipboard. For details, see Manage storage account access keys.
2.2. Azure Cosmos DB
To connect to your resource, you can navigate to its Connection String settings in the Azure Portal. You can typically choose Read-only Keys and copy your connection string to the clipboard.
3. New data connector
Once you have your connection string as shown above, use the main menu in Dundas BI and choose New, then Data Connector.
After filling in a Name, set Data Provider to Azure Table / Azure Cosmos DB.
Paste or type in your Connection String.
Connection strings copied from the Azure Portal typically already include the Account Key or access key, in which case you can leave this next field blank.
You can click Test connection to confirm you have access.
Click the Submit button at the bottom of the dialog to save and check in the data connector, and automatically discover data structures.