In the initial stage when we went with Data Integrator Cloud Service it was primarily the nativity factor that was key for us. Having a single vendor supporting the entire suite of applications, and the ability to configure activities and direct integration with various other Oracle products, were the main attractive features within ODI. This is a well-established product that's good to have if you hold an Oracle suite of applications. It meets all our specifications in terms of usability.

The focus is on integrating and combining data from various sources, such as Oracle, MSS, Hadoop, and MySQL, for your users. The goal is to provide users with easy access to data without them needing to be concerned about the specific RDMS. To achieve this, you're transitioning your RDMS to the cloud, making integration and data access more seamless. The division isn't complex. The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process.            

It's a reliable product. Oracle integration cloud has got the adapters for all their products, which makes the integration a little faster. It makes it easier to implement the integration quickly. It's one of the best features. All the features that other products bring such as the technical adapters from REST, SFTP, database adapters, and Clifton is all standard with Oracle. 

The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration. 

ODI is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and you can combine them to build an really complicate and advance result.

Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing. I have also implemented Oracle Data Warehouse Data Integrators for file uploading to FTP servers, calling web services, and pulling or pushing data to web services. It's great for these tasks.