Oracle Cloud Infrastructure (OCI) GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis.
$250
Per License
Workday Adaptive Planning
Score 7.8 out of 10
Mid-Size Companies (51-1,000 employees)
Workday Adaptive Planning streamlines planning workflows, using AI and real-time data integration to improve collaboration and provide predictive forecasts for better strategic analysis.
I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.
We're a mid-size organization working with a shoestring budget and an IT skeleton crew...not much room to dedicate resources to a platform like this fully. Having it SaaS based is helpful for system management through their Helpdesk system, and a single platform also helps streamline the knowledge needed by our developers when integrating other business aspects to Workday.
It helps create dynamic plans for finances, operations and various functional units in an organization all under one platform
It helps in scenario modeling to help analyze various business events and report by any number of business dimensions including channel, customer or product
It can be integrated with any system including ERP, BI or CRM
Dashboards are not the best for graphs/charts. However, I have heard of companies using the dashboards for forecasting/budgeting. I would like to see Workday Adaptive Planning demonstrate this part of the feature.
Better security or locks to prevent deleting Actuals data - you are literally one click away from doing this.
On the web-based reports, better functionality when needing to reverse the sign in calculations - right now it is only available for revenue vs. expenses.
For one we're in way too deep to not move forward with Adaptive. We're integrated with Workday, we do a ton of reporting with Adaptive, and it's working very well for planning and forecasting. No reason to look back or change course.
Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
It is overwhelming at first, but once you really get to know it, you realize it is fairly simple and customizable, and then it has a lot more limitations than you first thought. Realizing those limitations and finding workarounds is when you know you've mastered the software.
There haven't been any lately. The only one issue I can think of is when there was an update in Adaptive that altered our reports. Before I realized there was an issue, Adaptive reached out to let me know, so that it could be fixed.
All aspects of Adaptive Insights perform well. One area that I wish was quicker was integration. When importing data from Intacct our accounting ERP platform, it can sometimes take 4 hours for the import to process. The earlier imports are done, the quicker they complete. My estimate for a quick upload is about two hours.
Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
Whenever we have had any questions, issues, or concerns, the support has been quick and thorough. [This] allow[s] us to be able to fully resolve any issues, or be connected with the right group quickly to attain the result we were after; be it from simple formatting to adding new detailed reporting.
We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
This was extremely helpful so that they could walk you through the model and teach you more about the complexity of various areas. It is most helpful when it is specific to your organization's model. The larger in-person trainings were helpful but they tended to be more generic and entry level. The trainings that are more tailored to your specific needs are the most helpful.
We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
They often times tended to be way too generic or entry level. They would also become sales pitches to upgrade or get new Adaptive Planning products. The questions in the training would be very niche and specific to other organizations. They were rarely helpful to the group at large.
If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
Trust the expertise of very strong 3rd party implementers. Having deployed Adaptive at a separate company before, I thought I knew it all (hubris, I know). Fortunately, I began to (very quickly) trust the judgment of our Carlson implementation team, and they provided invaluable insights and best-in-class processes that have benefitted me and my team greatly.
We use Oracle Data Guard as a backup tool, but not for data replication. Data Guard is not suited for real-time data replication in our non-normalized reporting database nor for the database we are using for our upgrade project, as Data Guard is not able to transform data and is not able to synchronize data into different schemas, which is necessary for our project. Additionally, our project database is on Oracle 12g not 11i: I am not 100% sure Data Guard is able to replicate from 11i to 12g
Workday became our choice because it is fully web-based and easily integrates with other systems. The learning curve for Workday was shorter than that of Dynamics. The reporting tools in Workday are more user-friendly than that of Dynamics. However Workday did not have Check Printing tools which are available in Dynamics. The organization started a project to digitize all financial transactions so it was not a priority feature. When it comes to scaling up the functionalities of Workday it was much easier than Dynamics.
Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
We went from 2 users to 70+ users over a 2 year period of time. The application scaled wonderfully. 65 of those users were non-finance users so they were able to quickly learn the software and prepare budgets quickly and efficiently. That is the power of Adaptive and its ability to scale
In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.
But both issues are solved now.
Installation is straightforward, easy.
Deployed everything within Oracle Data Integrator.
Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
Management Pack and VeriData are additional packs for your management and data verification needs.
It's facilitated a better financial literacy and management by the non-financial managers in the company, giving them a much better ability to see what they're spending, control it, and plan better in the future.
It's hard to quantify the ease of model and version management, but we could never do what we're doing now with our current staff. It would take a small army to replicate anything close to what Adaptive pulls off using Excel, if it's even possible.
