At moment you can not run stored procedure using ExecuteSQL, however, you can use ExecureScript to do the same with stored procedure wrapped in script with MySQL engine or any other client you can use please refer : https://community.cloudera.com/t5/Support-Questions/Does-ExecuteSQL-processor-allow-to-execute-stored-procedure/m-p/158922   If you found this response assisted with your issue, please take a moment to login and click on "Accept as Solution" below this post. Thank you     ... View more

ExtractText processor can help you grab needed information from json content and store in the flow file attribute for reuse after InvokeHTTP.    Thank You  ... View more

DBCPConnectionPool provides Database Connection Pooling Service. Connections can be asked from pool and returned after usage by SQL processor which are responsible to run the SQL queries . You can useListDatabaseTables processor along withDBCPConnectionPool controller to get the table metadata    If you found this response assisted with your issue, please take a moment to login and click on "Accept as Solution" below this post. Thank you, Chandan    ... View more

I suggest you have a technical support case opened with the Cloudera Technical Support team so we can dive further.   Thank You. ... View more