How to add multiple databases as part of Azure Data Explorer linked service?

Prateek Punj 1 Reputation point Microsoft Employee
2022-05-24T17:26:11.883+00:00

HI,

I am trying to setup a data explorer linked service in data factory and I want to connect it to multiple databases within the same cluster. How can I do that? I tried adding multiple database names with a comma and it throws me error.

Any help on this will be very appreciated.

Thank you

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
480 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,542 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-05-27T10:13:51.743+00:00

    Hi @Prateek Punj ,

    Thank you for posting query in Microsoft Q&A Platform.

    We should consider parameterizing database name in linked service and dynamically pass value to that parameter to point to desired DB. Comma separated values will not help. Also note at a given time your linked service can point to only on DB which supplied as value to parameter.

    206201-image.png

    Please check below video which helps.
    Parameterize Linked Services in Azure Data Factory

    Hope this helps. Please let us know if any further queries.

    ----------

    Please consider hitting Accept Answer button. Accepted answers help community as well.

    1 person found this answer helpful.
  2. Suba Balaji 11,186 Reputation points
    2022-05-25T09:33:21.053+00:00

    Hi @Prateek Punj

    Thanks for posting your query on Microsoft Q&A platform.

    We are not allowed to mention multiple databases in the linked server configuration. However we can parameterize the database name and pass different database name (in the same cluster) during run time.

    Please let us know if you have further questions on it.

    Thank you.

    0 comments