How to dynamically switch database names in Mongo DB Linked Service?

Question

How to dynamically switch database names in Mongo DB Linked Service?

ADFUser 1

How do i call DATABASES dynamically from a MONGO Database in Azure data factory. When trying to create a linked service for mongo DB it is asking to Hardcode the database name without making it a dynamic content.

But we have more than 90 databases which we need to connect and get data from . It is not possible to create 90 AKV secrets and get data?

Please suggest an alternative or a solution to this.

Thanks

Chandra Boorla 15,475 Reputation points Microsoft External Staff Moderator

2025-03-06T18:02:40.1533333+00:00

@ADFUser

Just checking in to see if the below answer provided by @ Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Chandra Boorla 15,475 Reputation points Microsoft External Staff Moderator

2025-03-06T18:02:40.1533333+00:00

@ADFUser

Just checking in to see if the below answer provided by @ Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,886 MVP Volunteer Moderator

User's image

you can use the Advanced settings and use dynamic settings

Chandra Boorla 15,475 Reputation points Microsoft External Staff Moderator

2025-03-07T18:09:01.9566667+00:00

@ADFUser

Just checking in to see if the above answer provided by @ Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

How to dynamically switch database names in Mongo DB Linked Service?

1 answer

Your answer