AnsweredAssumed Answered

Help with getting data into SQL Server

Question asked by heather.cookson345690 on Jul 5, 2016
Latest reply on Jul 5, 2016 by heather.cookson345690

As someone new to Boomi, could you please point me in the direction of the best way to get data from Successfactors (using Boomi) to my SQL Server database? We were using SFTP but have since found out that SFTP removes line breaks in TXT files and does something to CSV files which means that its not recognizable as a CSV file unless its manually opened and resaved again. Should I be looking at a database connector or maybe the MS SQL Server BCP? Can you let me know if you have any suggestions please?

 

Thanks,

Heather

Outcomes