Oracle GoldenGate and IBM InfoSphere DataStage are key players in the data integration and replication market. Oracle GoldenGate seems to have the upper hand with its real-time data replication capabilities and strong integration with Oracle environments, whereas IBM InfoSphere DataStage is favored for its robust ETL features and flexible incorporation of complex business logic.
Features: Oracle GoldenGate offers real-time data replication, excellent integration with Oracle systems, and scalability that supports real-time data transformation. IBM InfoSphere DataStage provides strong ETL capabilities, flexibility in integrating complex business logic, and powerful administrative features for large-scale data transformation.
Room for Improvement: Oracle GoldenGate users note high licensing costs, complex setup processes, and limited integration with non-Oracle databases. They also call for better monitoring tools and user interface improvements. IBM InfoSphere DataStage faces criticism over its high costs, intricate architecture, and need for better modern data source integration. It's also suggested that performance monitoring and cloud capabilities be enhanced.
Ease of Deployment and Customer Service: Both products are primarily deployed on-premises, though Oracle GoldenGate offers more flexibility for hybrid and private clouds. Oracle GoldenGate's customer support has mixed reviews due to delays and handling complexities, while IBM InfoSphere DataStage generally has high support ratings but with expensive options and integration challenges in modern tech environments.
Pricing and ROI: Oracle GoldenGate is perceived as expensive, potentially limiting for smaller setups, but justifiable for large enterprises needing robust disaster recovery and migration tools. IBM InfoSphere DataStage is also costly but provides competitive integration pricing compared to Informatica. ROI for both tools heavily depends on data operations' volume and complexity.
We also have the flexibility to submit a feature request to be included as part of the wishlist, potentially becoming a product feature in subsequent releases.
IBM tech support has allocated dedicated resources, making it satisfactory.
The support team responds quickly, providing feedback which we then implement.
It effectively manages larger databases, such as those of 15 terabytes and above.
Oracle GoldenGate is quite stable.
I wonder if it supports other areas, such as cloud environments with open source support, or EdgeShift.
The solution needs improvement in connectivity with big data technologies such as Spark.
The configuration process could be made simpler.
For Oracle GoldenGate, customers face challenges with patching, the latest updates, and encountering bugs.
Pricing for IBM InfoSphere DataStage is moderate and not much expensive.
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.
IBM InfoSphere DataStage is very scalable, allowing us to extend it according to our processing needs.
It is straightforward from a design and development perspective, and also for deployment.
The ability to sync data in real time is a key feature I rely on.
Active Data Guard is an important feature for disaster recovery site applications.
IBM InfoSphere DataStage is a high-quality data integration tool that aims to design, develop, and run jobs that move and transform data for organizations of different sizes. The product works by integrating data across multiple systems through a high-performance parallel framework. It supports extended metadata management, enterprise connectivity, and integration of all types of data.
The solution is the data integration component of IBM InfoSphere Information Server, providing a graphical framework for moving data from source systems to target systems. IBM InfoSphere DataStage can deliver data to data warehouses, data marts, operational data sources, and other enterprise applications. The tool works with various types of patterns - extract, transform and load (ETL), and extract, load, and transform (ELT). The scalability of the platform is achieved by using parallel processing and enterprise connectivity.
The solution has various versions, catering to different types of companies, which include the Server Edition, the Enterprise Edition, and the MVS Edition. Depending on which version a company has bought, different goals can be achieved. They include the following:
IBM InfoSphere DataStage can be deployed in various ways, including:
IBM InfoSphere DataStage Features
The tool has various features through which users can integrate and utilize their data effectively. The components of IBM InfoSphere DataStage include:
IBM InfoSphere DataStage Benefits
This solution offers many benefits for the companies that utilize it for data integration. Some of these benefits include:
Reviews from Real Users
A data/solution architect at a computer software company says the product is robust, easy to use, has a simple error logging mechanism, and works very well for huge volumes of data.
Tirthankar Roy Chowdhury, team leader at Tata Consultancy Services, feels the tool is user-friendly with a lot of functionalities, and doesn't require much coding because of its drag-and-drop features.
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."
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.
