I have the data source which is a linked SQL server.
We can only read the the data from that linked server (no write permission)
How can I execute a select query in Appian to read from one of the tables in that linked SQL DB?
Discussion posts and replies are publicly visible
Hi Pooja, to execute a traditional SELECT query against your database you can utilize the Query Database Smart Service. If you have defined a CDT and Data Store to reference these tables (preferable), you can utilize a!queryEntity().