It allows the replication in REAL TIME from the Oracle database in RAC to the contingency database, through the immediate replication of the data in the REDO LOGS, without the need to wait for them to be written at the level of the ARCHIVE LOGS.
It allows me to granularly replicate specific tables Review collected by and hosted on G2.com.
In our experience it is important to check that the database is prepared to proceed with the replication through OGG.
Pay special attention to the types of data that are not supported, because if the tables use them they will not be replicated, besides there must be a good database design model with their respective primary and foreign key relationships, it is not recommended handle the logic of the relationships between the tables only at the level of the application. Review collected by and hosted on G2.com.
Integrates well with Oracle database
Integrates well with all Oracle set of tools including Hyperion applications Review collected by and hosted on G2.com.
There are better ETL tools in market e.g. Informatica
If you are working with multiple databases I would recommend to go with Informatica Review collected by and hosted on G2.com.
Graphical definition of ETL processes and execution control Review collected by and hosted on G2.com.
The complicated transformation operations are difficult to develop. Review collected by and hosted on G2.com.
stays within our budget very robust features data analytics were fully customizable to our needs. No hidden charges for things like data, storage performance or support Review collected by and hosted on G2.com.
requires frequent Java updates, difficulty finding accessible support documentation for my team ( who was comprised of blind computer operators) documentationm once found was converted, slowing the overall implementation. Review collected by and hosted on G2.com.
the ease of access of the application on a day to day at work. Whenever I had an issue there was many templates online that helped me when I had a question. High performance and no impact on the production towards the environment. Review collected by and hosted on G2.com.
My dislikes really go in to the effect of the cost it bears to companies which is pricey. Though I can look how to use many features online. I found that many features have been added to which it can be very overwhelming. The earlier versions were very complex but I will say this version is much more user friendly Review collected by and hosted on G2.com.
Easy to learn and use. As an administrator it very easy to customize. It can transform and load large amoyof data. Review collected by and hosted on G2.com.
Data Security is not very user friendly . Review collected by and hosted on G2.com.
This is a cloud service that supposed to replace on-premise Exadata(s) Review collected by and hosted on G2.com.
From the sales account team who are incompetent at best, to network engineers that cant get tunnels up for 4 months ... this solution is part of the audit strong-arm that forces customers into Oracle cloud solution. Unless you have direct connect expect daily network outages and excuses from account team Review collected by and hosted on G2.com.
You can have multiple different data sources coming into this Oracle GoldenGate. You are not limited to only Oracle databases. Review collected by and hosted on G2.com.
The time that it takes to implement Oracle GoldenGate. Because you can have multiple databases going through it it can take a long time to set it up. Review collected by and hosted on G2.com.
The software seems to be glitchy at times. It's hard to navigate too. Or I made need to do some more training to figure out some of the aspects of the software that cause me confusion. Overall it's ok. Does the job. Review collected by and hosted on G2.com.
Navigating it is difficult for me. I just need to get myself more acclimated to it. Review collected by and hosted on G2.com.
It's easy to use, with drag and drop to build out the package and ELT flow. For staff who knows PLSQL, it's not hard for them to pick up ODI. Our enterprise project has been using ODI for nearly 3 years now. Review collected by and hosted on G2.com.
It doesn't provide the near real time data replication function similar to OGG (oracle golden gate), but the scheduled jobs in ODI is still pretty neat. Review collected by and hosted on G2.com.