Using JDBC Custom Activity for MSSQL Stored Procedure

[tsutherland]

I am creating a custom JDBC activity to pass variables to a MSSQL stored procedure. The connection tests fine with the credentials and connection I've created and we are using Mid Servers to connect.

This is the definition of the stored procedure (as provided by the DBA):

and these are my inputs:

When I test the inputs, my raw output has no error messages, shows completed and I have auto-map to Local for the output. However, it appears that the stored procedure on the database is not receiving the values in the inputs when I test.

I have confirmed the inputs with the DBAs but I'm stymied on how to troubleshoot this next. I've combed through all the documentation, of course, but I'm not seeing a lot for setting up calls to store procedures and troubleshooting.

TIA!

[Richard Hine]

Could you share a screenshot of how you have the execution command panel configured to call the stored procedure and populate the variables?

Thanks,

Richard

[tsutherland]

Absolutely! Thanks for the help.

[Malathi Vinoth]

Hello Richard and tsutherland,

I need help in buliding up same scenario, could you please help me what type of credential used and how to trigerr the JDBC custom activity

Please share your email address I will contact if possible

[tsutherland]

I have not gotten it to work yet. I have a ticket in with a partner for help.  I created JDBC credentials using a specific username/password for the SQL server. As for triggering the custom activity, I plan to do it either in a catalog workflow or in flow designer, but I haven't gotten that far yet. A catalog request will be the trigger either way.