Forum Discussion
Copy Activity: Fabric + Azure Key Vault + external database connection
Hi shivangjha
I am aware of the problem. And I updated the following link:
Get Azure Key Vault secrets in Fabric pipeline – Simplyfies
Regards,
Nono Chen
Hi Anonymous ,
Thanks for your update on the procedure - how to get azure key vault secrets.
It does not solve the actual problem of using those secrets in the copy activity in fabric.
As per my original post, i had specifically requested some info on how to use azure key vault secrets in the Copy data activity.
excerpt from the original post
"
I understand that as a solution/work around, I can configure a web activity in the data pipeline to get secrets/credentials from Azure Key Vault - but the real issue lies in how to use that in the copy activity/ creating a connection to the mongo source (which would be a PROD mongo db in this case)."
If you can help on those lines, it would be super cool.
Appreciate your efforts though 🙂
Hi shivangjha
In response to this sentence: “but the real issue lies in how to use that in the copy activity/ creating a connection to the mongo source (which would be a PROD mongo db in this case).”
First, you store MongoDB's connection string, or credentials, in Azure Key Vault. Make sure you have access to those secrets.
In the data factory pipeline, add a new Web activity. Configure this activity to get secrets from Azure Key Vault. You will need to provide the Key Vault URL and secret name.
Make sure your data factory has access to Azure Key Vault.
Solved: Accessing Azure KeyVault secret for Fabric CopyDat... - Microsoft Fabric Community
After obtaining secrets in a Web activity, you can use them in a replication activity. You can set MongoDB's connection string by referencing the output of your Web activity. For example:
@activity('WebActivityName').output.value
Regards,
Nono Chen