How to connect/access to SQL server functions from Azure data factory

AP 156 Reputation points
2021-12-07T05:49:12.947+00:00

Hi, We have a SQL On Prem that we established a connection to via Azure data factoty linked service.

We now have to access SQL functions from that server in ADF and read data.

I see options like table/Stored Procedure Query etc. But not sure how to access functions and pass parameters to them to execute and access data.

Please help.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,105 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,471 Reputation points MVP
    2021-12-07T05:56:13.01+00:00

    Hey,
    Can you show a sample SQL query what you are trying to implement via SSMS?
    We can leverage the same thing via Lookup activity in ADF.

    Anything SQL that can be done via SSMS can be done via Lookup activity in ADF
    Though it has some restrictions with amount of data returned


0 additional answers

Sort by: Most helpful