Sep 09, 2021
We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.
SSIS and Oracle GoldenGate compete in the data integration sector. Oracle GoldenGate holds an advantage with superior real-time data processing and scalability, while SSIS is favored for its cost-effectiveness and ease of use.
Features: SSIS offers data transformation and workflow management, seamlessly integrating with Microsoft products, making it optimal for Microsoft environments. Oracle GoldenGate provides real-time data synchronization, high availability, and heterogeneous environment support, suiting enterprises requiring quick data replication and integration.
Room for Improvement: SSIS could enhance its real-time data handling, increase scalability, and improve support for non-Microsoft platforms. Oracle GoldenGate might simplify its deployment process, reduce complexity for smaller enterprises, and offer more competitive pricing.
Ease of Deployment and Customer Service: SSIS is praised for its straightforward integration in Microsoft settings, benefitting from SQL Server support resources. Oracle GoldenGate, though needing a complex deployment for multi-platform support, delivers comprehensive technical assistance, catering to diverse infrastructures.
Pricing and ROI: SSIS is cost-effective with lower initial setup costs and flexible pricing, offering an attractive ROI for budget-conscious organizations. Oracle GoldenGate, despite higher expenses, provides substantial ROI through advanced real-time data management and efficiency improvements.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
The rating for Oracle GoldenGate support is a three.
The support team responds quickly, providing feedback which we then implement.
The first line of support needs to be more knowledgeable.
It effectively manages larger databases, such as those of 15 terabytes and above.
Oracle GoldenGate is quite stable.
It processes large volumes of data quickly.
The configuration process could be made simpler.
For Oracle GoldenGate, customers face challenges with patching, the latest updates, and encountering bugs.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
The logging capabilities could be improved, particularly for error logging.
The list price is high, and the price can sometimes seem expensive if the appropriate discount is not applied.
The pricing of Oracle GoldenGate is quite high.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
The most valuable feature of Oracle GoldenGate is its ability to sync data in real-time, which is crucial for me.
Active Data Guard is an important feature for disaster recovery site applications.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
We end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model.
| Product | Market Share (%) |
|---|---|
| SSIS | 5.9% |
| Oracle GoldenGate | 2.7% |
| Other | 91.4% |
| Company Size | Count |
|---|---|
| Small Business | 22 |
| Midsize Enterprise | 5 |
| Large Enterprise | 29 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.
Oracle GoldenGate Features
Oracle GoldenGate has many valuable key features, including:
Oracle GoldenGate Benefits
Some of the benefits of using Oracle GoldenGate include:
Reviews from Real Users
Below are some reviews and helpful feedback written by Oracle GoldenGate users.
PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."
Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”
A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."
An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
