Can OutSystems replace SSIS as an ETL tool?


Can OutSystems replace SSIS as an ETL tool? Our specific scenario is pulling files from an SFTP server and parsing it to MS SQL Server.

Can OutSystems make SFTP connections? Yes.
Can OutSystems read files? Yes.
Can OutSystems parse files? Yes.
Can OutSystems write to MS SQL? Yes.

OutSystems was thought to be used as a web/mobile development tool. There are several other tasks that it can do, but maybe not in an ideal way.

Some ETL can be done in OS. Thousands of records on a daily basis? No problem. But if it will be heavier, if you are talking about millions or records, OS is not the best approach.