Copy Activity: Fabric + Azure Key Vault + external database connection

Hi shivangjha

It is feasible to use Azure Key Vault to extract credentials and use them in replication activities for data pipelines.

You can try the following steps:

Set the managed identity for the data factory. Ensure that the data factory has a managed identity associated with it.

Configure Azure Key Vault. Open Key Vault's access policy and add a hosting identity with permissions and secrets.

Store secrets in Azure Key Vault. Navigate to Key Vault and store MongoDB credentials as confidential.

Add a Web activity to get secrets. In the data factory pipeline, add a new Web activity to extract secrets from the Azure Key Vault.

Use of secrets in replication activities. In the Copy activity, dynamic content is used to reference the output of the Web activity.

You can view the link below for more details:

Use Azure Key Vault secrets in pipeline activities - Azure Data Factory | Microsoft Learn

Store credentials in Azure Key Vault - Azure Data Factory | Microsoft Learn

Regards, 

Nono Chen 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.