Just execute a MySQL Stored Procedure, also a SQL Server update statement

This might be simple but I can't figure it out.

Once I'm done, this will be put into a FH batch but right now I need to figure out the pieces.

I need to be able to execute a mysql stored procedure. That's it. no read data, no write data. Not sure how to do that.

Once I figure that out, in another FH process I need to execute an update statement in SQL Server. I can probably do the same way as mysql once I understand that part.

Any help would be appreciated.

Alan
 

Hi Alan,

You can do this with the help of the SQL Heater . Just put your SQL statement here. You can decide when the SQL should be executed. Once during the “START” of the Import/Export process, at the “END” or for each processed row.

To execute a MySQL Stored Procedure you have to write call sp_NAME(para1, para2, …). If you need to overtake some field content you have to use FlowHeater Parameter instead. See screenshot below.

Like this way you can also perform your UPDATE statement on your MS SQL Server database.

 

 

Thanks, I think I tried this but FH complained about the read side. Is there a way to tell FH that I done need a valid Read side since I'm only going to use the write side?

Alan
 

Hi Alan,

Sorry I don’t understand. You can choose (1) on which side the SQL statement should be executed and (2) in case of a multi adapter definition on which Adapter ?

 
 

I understand that, but in this case I don't have a "read" adapter, only a "write", but I think FH requires me to have a valid "read" adapter.
I maybe can just use an empty text file and use textadapter.
I'll try it out and see if that will work.
Thanks
Alan
 

Hi Alan,

Now it´s clear for me. In this case just use the TestFile Adapter as a dummy adapter. Create just one row on READ side and configure your WRITE side to perform just updates. Of course the one row shouldn’t match the primary key for updates that´s all.