Optimize data entities to achieve better performance
One method of improving the performance of integrations is to change the behavior of data entities. When bringing in entities that are not composite and don't require row-level logic, turning on set-based processing for the entity can help. Set-based processing allows for rows to be collected and moved in groups, reducing the effect of latent communication with the database.
Another method that works for entities that are not composite is to split input files into multiple parts. Doing so allows finance and operations apps to take advantage of multithreading to the extent that the environment is capable.