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.