#connector #insertdata

Hi,

I have a process which works as expected from the Studio but when I deploy into the server, one of the forms doesn't work properly.

I have two forms and two process variables (of type collection) in two different pools. I'm using exactly the same external API to get the data in the two forms :
varName1 = ../API/bpm/activityVariable/{{taskId}}/processVariable1 --> first form
varName2 = ../API/bpm/activityVariable/{{taskId}}/processVariable2 --> second form

Hello,
I'm trying to do a process with a MS SQL connector to insert data into my bdm. But I can't find a good methode. I don't want to use an ui interface because it must be something automatically. I've done a process with an input connector. But my question is if it's correct putting in a script something like this "insert into myrequebdm (column1, column2,..) select col1, col2,.. from msSQLtable " or is there other ways according the experience who has done something like that.

Thanks in advance for your ideas or comments.

Walter R.