Wondering how people are running MySQL stored procedures from Appian for validat

@David, can a JDBC be set up or must this be done over webservices? If using a JDBC then you could use the following plug-in to run stored procedures:

https://forum.appian.com/suite/tempo/records/type/components/item/i8BCLGOdlMUpdGVqT-RV7oRg74uEGJO5C8ZhL3Yukyv6zRTk30LjvusuVlHbS9BJg/view/summary

Matthew - my preference is to not install a plug-in but to use out-the-box Appian smart services that are part of the core product.

David, one way to run Stored Procedures using OOTB functionality would be the deprecated Query Database Smart Service:

forum.appian.com/.../Query_Database_Smart_Service.html

I have attached a screenshot of how this could be configured to run a test procedure in MYSQL that already has a JDBC set up. You can also use a set of connection information through this method as well by choosing "Set up a custom data source" if no predefined source exists.

Matthew, good to know that is there. It's obviously misnamed - should be manipulate_database_direct_access !

Even though the JDBC connection can be restricted somewhat - most DBAs would be nervous about enabling this I can see.

I'm still thinking that the RESTful route is the clearest - and looking for examples that people have done - or what does Appian recommend for Stored Procedures now this Query service is deprecated?

David, I believe the plug-in is the best route instead of using this smart-service. This smart service is deprecated in the sense that it is no longer used for writing to tables or querying from tables, instead the Write to Datastore Entity smart services and Query Entity should be used. I am not sure if this (being its deprecation) applies to using it for running stored procedures.

For RESTful integrations, one can use the HTTP Query Smart Service out of the box.
forum.appian.com/.../HTTP_Query_Smart_Service.html

I have personally never dealt with integrating with an RDBMS over HTTP(s). Is the use case for a cloud site or for an on premise installation? (in terms of which database you are attempting to access)