It was really helpful. I used the same method to run a stored procedure on MSSQL using SQLCMD : SQLCMD -S server_name -U user_name -P password -i sample.sql and in sample.sql I put: exec sp_name sp_parameters Then I used ExecuteProcess to call SQLCMD along with its parameters. ... View more

Thanks for your answers. Recently I noticed that probably NiFi can help me for this problem. Can I implement this dataflow in NiFi? ... View more

Thanks. I meant that I don't have access to any tables or views on the database server so I don't know the logic underneath. I am able only to call the stored procedures. ... View more

Well, in terms of offloading the store procedure, I do not have access to the database server and I am just given access to those stored procedures to run them. Is it wise to run the stored procedure in a java application and then use for example spark to write it in HDFS? Thanks. ... View more