locked
Error connecting to On Prem SQL Database RRS feed

  • Question

  • I am trying to create a logic App to Execute a query On Premise SQL Database and return the results in a CSV file. When I trying to do the connection using the On Premise gateway. 

    Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Get Native Sql Metadata) is currently not supported using an on-prem gateway connection clientRequestId: 9FCBAFB5-07FB-40B3-96A2-99B33568182A 

    

    I am getting the below error am I missing something if it is not supported what is the workaround for this. 

    Wednesday, April 10, 2019 3:51 PM

Answers

  • Hi vdha

    This capability is not supported over the OPDG yet, however, it is in the product team's backlog. The recommendation is to use Storage Procedures which is definitely supported over OPDG.

    • Marked as answer by vdha Thursday, April 11, 2019 3:51 AM
    Wednesday, April 10, 2019 10:26 PM

All replies