CODEWITHSUNDEEP
azureazure-logic-apps
Saeid
Saeid

Reputation: 1663

Azure Logic Apps On-premises data gateway doesn't allow executing native SQL queries

I tried to execute a SQL query using Azure "On-Premises data gateway" from Azure Logic Apps. Running the logic resulted the following error message:

{ "status": 400, "message": "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native SQL) is currently not supported using an on-prem gateway connection\r\nclientRequestId: ...", "source": "sql-scus.azconn-scus.p.azurewebsites.net" }

enter image description here

There should be something wrong with my setup. If not, what's the point of having "Execute a SQL Query" if there is no support for native SQL queries? What am I doing wrong?

Upvotes: 8

Views: 4321

Answers (1)

Saeid
Saeid

Reputation: 1663

According to the documentation:

SQL native query is not supported for on-premises SQL server.

So this feature is not available at this point.

Upvotes: 3

Related Questions