Oracle Autonomous Data Warehouse vs. Oracle Fusion Cloud Enterprise Performance Management

II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.

Incentivized

It is well suited in a geographically distributed environment where you have various key participants in multiple time zones providing input and necessary explanations on performance and measured success It is less appropriate where you have a single office environment with a single finance department working together. It is also less suited when the GL is NOT an Oracle product and the interface between the GL and the reporting software needs to be implemented with utmost care and handling.

Incentivized

• Very easy and fast to load data into the Oracle Autonomous Data Warehouse
• Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
• Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
• It is always patched and always available and you can add storage dynamically as you need it.

• Account Reconciliation CLoud Services provides tight integration with Oracle R12 and 11i . Provides drillback capability. It is flexible and provides rich functionality to users.
• We have implemented ARCS on cloud and migrated planning and budgeting from On premise to PBCS and EPBCS. Functionality is onpar with onpremise. Provides regular updates monthly
• We don't need to upgrades every year and saved a lot on Hardware.

Incentivized

• It is very expensive product. But not to mention, there's good reasons why it is expensive.
• The product should support more cloud based services. When we made the decision to buy the product (which was 20 years ago,) there was no such thing to consider, but moving to a cloud based data warehouse may promise more scalability, agility, and cost reduction. The new version of Data Warehouse came out on the way, but it looks a bit behind compared to other competitors.
• Our healthcare data consists of 30% coded data (such as ICD 10 / SNOMED C,T) but the rests is narrative (such as clinical notes.). Oracle is the best for warehousing standardized data, but not a good choice when considering unstructured data, or a mix of the two.

Incentivized

• The limitation of constrained out of the box dimensions that requires ripping the initial implementation to add the new dimensions is a major drawback.
• Smartview interface is cumbersome for many.
• The only financial adapter is available for integration for other modules we have to go with file-based uploads which is cumbersome and not real-time.
• It is very costly in terms of licensing unlike other Oracle products.

Incentivized

Because

• It is really simple to provision and configure.
• Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
• Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.

Incentivized

We have a pretty good userbase who are at the high level who gained value from this tool. Discontinuing this tool is prone to impact their day to day operations. Also the data in this tool cannot alter the source, which maintains the integrity of this tool. Smartview is a cool addition that gained lot of traction as well.

Incentivized

It produces consolidated multi currency reports faster and more accurately whilst adding additional pivotal functionality. The Smartview reporting is a key for us and a flagstone of the application

Incentivized

EPM has been so far available all the time

Incentivized

The product performance is so far very good

Incentivized

Support from our implementation partner is a 10/10, but support from Oracle is awful. Case in point: recently over a 2-day period, there were a series of intermittent outages. Oracle actually asked US for the outage time-stamps. I would have thought that, since we were paying them, they should probably be able to tell us!

Incentivized

Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.

Incentivized

I suggest doubling the time to implement from the initial quote you get from the Sales team. That's always been the case for me for multiple EPMs now. The out-of-the-box functionality of Oracle Planning and Budgeting Cloud is pretty robust so I appreciate that and it really helped us get the ball rolling quickly.

Incentivized

As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it

Incentivized

Oracle Planning and Budgeting Cloud fared very well against Adaptive, Anaplan, and Host Analytics. We ultimately decided on Oracle due to its reputation and strength of existing customers. We are happy with our decision.

Incentivized

The product is scalable

Incentivized

• Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
• Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
• All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.

Incentivized

• Significantly reduced the amount of money we spent for the maintenance of in-house hardware.
• We now need less employees to manage the configurations of Oracle EPM Cloud.
• There have been many time savings as a whole to apply to more productive causes.

Incentivized