ODI Salesforce integrations are very slow, looking for performance enhancement possibilites
We have an integration setup using ODI, which extracts data from Salesforce. While it works fine, the processes take a long time to run. We created equivalent processes using OIC, which runs much faster. Recreating all processes in OIC will take a lot of time, so we are looking for options to improve the performance in ODI. Is anyone aware of any parameters that can be set, or, any other changes that can be done to achieve the same?
The mappings in ODI are very simple. They read from Salesforce and load tables in ADW. No transformations being done in this layer.