What users are saying about
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101
167 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

Actian DataConnect

The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors.
David Byrd profile photo

Oracle GoldenGate

It is particularly useful in situations where ACTIVE DATA GUARD cannot handle the desired outcome. It can be used to support cross-platform migrations not supported by Active Data Guard which is a far cheaper solution to DR. It is suited for migrations that require zero downtime as there is bi-directional capability built into the product. It is also useful when the source and target are of different databases such as Oracle to SQL Server as the target. It is overkill if all you require is a physical standby that is open read-only.
No photo available

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.5
Oracle GoldenGate
8.0
Connect to traditional data sources
Actian DataConnect
10.0
Oracle GoldenGate
8.2
Connecto to Big Data and NoSQL
Actian DataConnect
9.0
Oracle GoldenGate
7.8

Data Transformations

Actian DataConnect
10.0
Oracle GoldenGate
7.2
Simple transformations
Actian DataConnect
10.0
Oracle GoldenGate
7.8
Complex transformations
Actian DataConnect
10.0
Oracle GoldenGate
6.6

Data Modeling

Actian DataConnect
10.0
Oracle GoldenGate
7.0
Data model creation
Actian DataConnect
10.0
Oracle GoldenGate
7.3
Metadata management
Actian DataConnect
10.0
Oracle GoldenGate
6.8
Business rules and workflow
Actian DataConnect
10.0
Oracle GoldenGate
7.1
Collaboration
Actian DataConnect
10.0
Oracle GoldenGate
7.1
Testing and debugging
Actian DataConnect
10.0
Oracle GoldenGate
6.9

Data Governance

Actian DataConnect
9.5
Oracle GoldenGate
7.6
Integration with data quality tools
Actian DataConnect
9.0
Oracle GoldenGate
7.7
Integration with MDM tools
Actian DataConnect
10.0
Oracle GoldenGate
7.6

Pros

  • The large connector base for DataConnect is outstanding. However even when they do not have a custom connector, they have a web services Invoker which allows you to connect to any web services.
  • The underlying scripting language is Visual Basic-ish. Very easy to start.
  • The product has been around a long time, through multiple company acquistions, and still is a competitive player via pricing.
  • Support team is awesome.
  • Large user community.
David Byrd profile photo
  • Replication. Oracle GoldenGate's strength is it's main feature, replication. GoldenGate is able to quickly replicate transactions in a method that maintains transactional integrity and give you a like to like replica on the other side.
  • Transformation. Oracle GoldenGate is able to do some data transformation as it replicates, this is very key if you need your data to appear a certain way, especially important in Reporting.
  • Recoverability. Oracle GoldenGate has many fail safes to ensure data is not lost, some examples of this are trail files its own system of recording changes that works with the DB SCN.
  • Multiple Data Sources/Targets. Oracle GoldenGate is not limited to just Oracle Databases as a target it can support most of the popular databases in the industry today such as SQL Server, MySQL, DB2 and more.
Michael Grayson profile photo

Cons

  • Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running.
  • New connector development does not seem a priority.
David Byrd profile photo
  • Where there are open transactions GoldenGate needs to auto-detect them.
  • GoldenGate should have dba views like Oracle Database.
  • Patching or upgrading GoldenGate is a bit complicated.
  • When extract or pump trail file sequence number is about to reach the max limit, we should get a warning or critical threshold alert.
  • When Integrated replicat is altered, it converts to classic replicat. We don't get any message that the replicat is running in classic mode. There should be some sort of alerting in the ggserrlog file.
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
Oracle GoldenGate9.2
Based on 3 answers
We are very Happy with the product and the support and it helps us achive our 99999 SLA.
No photo available

Usability

No score
No answers yet
No answers on this topic
Oracle GoldenGate8.6
Based on 3 answers
As stated earlier Golden Gate is very user friendly and easy to use. Has some very good features that helps troubleshooting very easy.
No photo available

Reliability and Availability

No score
No answers yet
No answers on this topic
Oracle GoldenGate10.0
Based on 1 answer
Oracle GoldenGate has only gone down for us when the data being sent was bad.
Michael Grayson profile photo

Performance

No score
No answers yet
No answers on this topic
Oracle GoldenGate9.0
Based on 1 answer
Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.
Michael Grayson profile photo

Support

No score
No answers yet
No answers on this topic
Oracle GoldenGate8.8
Based on 3 answers
Overall support for Golden Gate is very good. Whenever we have created an SR, We get solution for it pretty fast.
No photo available

In-Person Training

No score
No answers yet
No answers on this topic
Oracle GoldenGate10.0
Based on 1 answer
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.
Michael Grayson profile photo

Online Training

No score
No answers yet
No answers on this topic
Oracle GoldenGate10.0
Based on 1 answer
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.
Michael Grayson profile photo

Implementation

No score
No answers yet
No answers on this topic
Oracle GoldenGate8.6
Based on 3 answers
We use the oracle golden gate documentation for implementation. All the steps are very well documented.
No photo available

Alternatives Considered

As I stated earlier, DataConnect makes a head-to-head run against the others. It has advantages and disadvantages compared to the competitors. The choice really comes down to pricing and specific requirement needs for the project you are planning. Questions such as On-premise or Cloud, Security, and Specific Connectors available will drive your decision.
David Byrd profile photo
Oracle Golden Gate is very user friendly product and very easy to install, setup and troubleshoot.Quest SharePlex is bit complicated compared to Oracle Golden Gate and has less features.
No photo available

Scalability

No score
No answers yet
No answers on this topic
Oracle GoldenGate10.0
Based on 1 answer
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.
Michael Grayson profile photo

Return on Investment

  • Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment.
  • Problems are fairly easy to handle and rework.
David Byrd profile photo
  • We found this product really useful since it allowed us to keep two different data stores in sync.
  • It freed us from conducting expansive querying of our live data base, and instead just using the data-cache store instead.
No photo available

Pricing Details

Actian DataConnect

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Oracle GoldenGate

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details