ODI Cloud platform
Pros
- ODI uses ELT architecture, which enhances the load performance and is very scalable.
- ODI is platform independent. It supports all platforms, hardware and operating systems.
- It comes with pre-built integration, allowing immediate data replication, transformation, and data governance while ensuring data quality.
Cons
- OnPrem connectivity Agent has issues sometimes. It needs improvement.
- We encountered issues while moving a repository from one environment to another.
- I would be nice to have more cloud adapters to connect to different saas applications.
Return on Investment
- We are able to connect to SaaS applications and bring that data to our data warehouse.
- We don't have to worry about maintaining the infrastructure and upgrades.
- The product is highly scalable. Our company acquires and divests businesses, in our case a cloud solution is very helpful to scale the system depending on the need.
Other Software Used
Oracle Integration, Oracle Commerce Cloud, Oracle HCM Cloud



