ODI – The difference I see is it is used for data integration to load huge data from across different databases and within the same databases like PLM to BI, EBS to BI, etc. OCI – It is for integrations between systems like SOAP services etc.