We are purchasing a third party application that requires data to be sent to an MS SQL server from our system i. We can use a stored procedure on the Windows/SQL side to pull the data, however this is an IBM application process that can be run anytime during the day or night so we would have to schedule the procedure to run very frequently to check for data if we want to do it on the Windows side. We would prefer to be able to push the data to the SQL server as a last step of the IBM i application process.
Does anyone have any experience or ideas on how we could trigger the SQL procedure from the IBM? We are on Version 7.1 Mod 0.