Hi,
Can I query Appian database using an external SQL query tool such as TOAD?
Thanks,
Roberta
Discussion posts and replies are publicly visible
Hi Roberta -
Have a look at this documentation that details Appian's Enhanced Data Pipeline for cloud customers - this will explain how this can be possible.
Hi Robert,
Thank you so much for this information.
In case we don't have "Premier Support", is there a way (if you know)?
No. Only way is via the Enhanced Data Pipeline.
Mathieu is correct. This is currently only available to customers having premier support with HA.
Hi Roberta - if the SQL you want to run is static you could write a Stored Procedure (SP) and then create an Appian WebAPI to invoke the SP. Since SPs allow you to pass parameters you can make them more generic as needed.
Thank you, Stewart. This is very helpful.