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.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Oracle GoldenGate is quite stable.
It processes large volumes of data quickly.
The configuration process could be made simpler.
You can tune Oracle GoldenGate to use more RAM on the source side or more processes.
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.
The logging capabilities could be improved, particularly for error logging.
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly.
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.
However, it could be a bit cheaper.
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 ability to sync data in real time is a key feature I rely on.
The benefit is the possibility to use only one tool to perform streaming and transformation of data.
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.
The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.
The main benefits SSIS provides for my company is to streamline processes.
| Product | Mindshare (%) |
|---|---|
| SSIS | 3.7% |
| Oracle GoldenGate | 1.5% |
| Other | 94.8% |
| Company Size | Count |
|---|---|
| Small Business | 22 |
| Midsize Enterprise | 5 |
| Large Enterprise | 30 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
Oracle GoldenGate offers seamless data replication and real-time data transformation, supporting heterogeneous databases with ease. It's appreciated for its stability, scalability, and the capability to handle large data volumes efficiently.
Oracle GoldenGate is known for its effective real-time data integration and minimal downtime, making it suitable for high-volume transactions. While praised for its compatibility across platforms and cost-effectiveness, it faces challenges with cost, licensing, and non-Oracle database integration. Its graphical interface and documentation require enhancements, and technical support could be more responsive. Advanced users seek refined API features and improvements in scalability. Despite these, it remains popular for supporting disaster recovery, data integration, and real-time data exchange.
What are the most important features of Oracle GoldenGate?Oracle GoldenGate is extensively used within industries such as finance and government for data migration, supporting zero-downtime migrations and cloud shifts. These sectors utilize it for centralizing diverse data sources, aiding analytics, and ensuring high availability through disaster recovery solutions.
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.
