We have a program spitting out big extract file. currently this file is manually downloaded by users and processed in the legacy system.
We can use XI to converting this file to pre-defined format and insert the rows directly into legacy system DB (using JDBC adapter). Is this approach safe (if we have more than 100k rows to be inserted).