Oracle Analytics Cloud vs. Oracle Integration (OIC)

Our hands are open to producing diverse reports and data analysis. When the initial setup was done and after a short time we got acquainted with this platform, we easily connected different sources and other databases to this platform and via Data Model Editor to model data, which we can use in pixel-perfect reports. It has a great user interface with a genius machine-learning system.

For all type of integration except those with a huge volume. It can deal with 20MB of transactions and processing of 1GB file when a file is being read using file or FTP adapters. It cannot be used for EDI as this support is not there. OICS is a perfect fit for other integration and is best when a customer has Oracle applications in the landscape. It is even greater if you have a requirement to create a custom form and make use of Process Cloud. All of these work very well together seamlessly. API needs can be handled by APIary.

Incentivized

• Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake.
• We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs.
• OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations.
• OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler.

Incentivized

• Auto-association of Oracle applications prepopulates the application connector select box and preconfigures Oracle Integration (OIC) using secure credential access for faster integration.
• Various other system connectors are available to use readily.
• User-intuitive experience--Connectors, integrators, and dashboard can be seen on one page.

Incentivized

• Performance of the tool: While Oracle Business Intelligence Cloud Service (OBICS) can handle large volumes of data as well, it becomes quite unstable and slow when number of concurrent users is high.
• Limited visualisation options for reporting.
• Difficult to integrate with other non-Oracle tools. This is especially needed since visualisation options are limited.

Incentivized

• Currently, it is not retaining the logs for more than 3 days, which it needs to address.
• We also need some functionality inside the interface to re-push the same transaction again so that it will be helpful while testing and fixing the issue.
• Also, some log errors are not giving the correct details. Oracle needs to rectify those.

Incentivized

Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.

Incentivized

The team is proactive and takes the issue up for resolution, they follow continuous development and release.

Incentivized

Better: Easy integration with different systems (internal, such as SAP; or external, such as data coming from tables from your vendors). Many companies use it and it's a good tool to learn. In my case, I learned at P&G and when I moved to Whirlpool I already learned how to use it! And I use it very often in my role. Worse: Well, if I need to do anything beyond a table, line or bar chart, I export the data and use a different tool.

Incentivized

The nearest thing I have used to OIC is UiPath, as it is often used as a tool to integrate software together. However, it is much more suited to legacy software which have little to no API endpoints. If the infrastructure already exists I understand why people use RPA for integration, however for when API's are easily accessible and you're using Oracle tools, OIC is better.

Incentivized

• Essbase delivers well on the business objectives with executive reporting.
• Essbase works well for financial close reporting purposes.
• Essbase is good for providing a single source of data for company actuals, forecast and budget data.

Incentivized

• Created a solution for unique business integration with minimal processing times
• Saves my team about 7 hours per week because of how it communicates with all the information. Because it communicates faster, and because there's a lot of information to communicate with, another solution might not work.

Incentivized