This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 15%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
I am trying to set up an azure key vault key to connect from Azure Data Factory directly to CosmosDB. I am following this link but it seems to be for a web app service.
https://learn.microsoft.com/en-us/azure/cosmos-db/store-credentials-key-vault
This creates two secret key names which doesn't work with ADF. Is there a way to connect directly to cosmos using the key vault? I am able to connect to the key vault from ADF. We tried setting up a secret value in the key vault using the "Connection String" value from cosmos but when I select this from the drop down in ADF, I get this error message:
Expecting connection string of format "key1=value1; key2=value2".
I just wanted to check in and see if you had any other questions?
If you have any other questions, please let me know. Thank you for your time and patience throughout this issue.
If the information helped address your question, please Accept the answer. This will help us and also improve searchability for others in the community who might be researching similar information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 20%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
@Andrew Hopkinson Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Hi Andrew,
Try following the guide below to get key Vault secrets:
Use Azure Key Vault secrets in pipeline activities
The tutorial you gave is in fact a guide for Azure Web App to store and use credentials stored in Azure KV.
If this is helpful please accept answer.
I figure it out myself, the issue was that the connection string copied from the the cosmos resource did not include the database name. I had to include ";Databasename=[cosmosdbname]" to end of the secret value in the Azure Key Vault and it worked. This is not well documented and the error message is not clear. The only way I found this was by hovering over the very tiny "i" beside the secret word in ADF for the key vault authentication.
I figure it out myself, the issue was that the connection string copied from the the cosmos resource did not include the database name. I had to include ";Databasename=[cosmosdbname]" to end of the secret value in the Azure Key Vault and it worked. This is not well documented and the error message is not clear. The only way I found this was by hovering over the very tiny "i" beside the secret word in ADF for the key vault authentication.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
@Andrew Hopkinson Appreciate your feedback on the documentation, could you share the article where this change is needed, I will work with content author and get this change updated. Below my colleague has summarized the steps you followed and updated the answer as the question author cannot accept their own answer. They can only accept answers by others.
I don't know if it was a specific article, but everything I saw posted was about connecting to Cosmos using a web app rather just connecting directly from Azure Data Factory, which is very different.
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this!
Issue:
Can I connect directly to CosmosDB from ADF using the key vault?
I am trying to set up an azure key vault key to connect from Azure Data Factory directly to CosmosDB. I am following this link but it seems to be for a web app service.
This creates two secret key names which doesn't work with ADF. Is there a way to connect directly to cosmos using the key vault? I am able to connect to the key vault from ADF. We tried setting up a secret value in the key vault using the "Connection String" value from cosmos but when I select this from the drop down in ADF,
I get this error message: Expecting connection string of format "key1=value1; key2=value2".
Solution:
The issue was that the connection string copied from the the cosmos resource did not include the database name. I had to include ";Databasename=[cosmosdbname]" to end of the secret value in the Azure Key Vault and it worked.
This is not well documented and the error message is not clear. The only way I found this was by hovering over the very tiny "i" beside the secret word in ADF for the key vault authentication.
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
I hope this helps!
If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.