IBM DataStage vs. SAP Replication Server

Excellent Cloud data mapping tool and easy creating multiple project data analytics in real-time and the report distribution are excellent via this IBM product. Easy tool to provide data visualization and the integration is effective and helpful to migrating huge amounts of data across other platforms and different websites insights gathering.

Incentivized

I asked questions about a warm standby and multicast replication. We ended up using bi-directional replication and a warm standby db. Having 3 or more live OLTP DB's where each was read-write was going to be difficult to manage for contention if the same table was being updated. We stuck with an easier solution to have only two OLTP's, and then used additional DB's as read-only DW's.

Incentivized

• Data movement
• Seamless integration of scripts and etl jobs
• Descriptive logging
• Ability to work with myriad of data assets
• Direct integration for Governance catalog

Incentivized

• guaranteed delivery
• high availability
• scalable
• low latency
• data transformation

Incentivized

• Connector Stages to Snowflake on the cloud. We had some issues initially but since then had been corrected.
• Accessing tool from a browser (zero foot-print). Currently we need to either install locally or connect to a server to do ETL work.
• Diversify ways of authenticating users.

Incentivized

• Data Reconciliation Functionality.

Incentivized

Because it is robust, and it is being continuously improved. DS is one of the most used and recognized tools in the market. Large companies have implemented it in the first instance to develop their DW, but finding the advantages it has, they could use it for other types of projects such as migrations, application feeding, etc.

Incentivized

It could load thousands of records in seconds. But in the Parallel version, you need to understand how to particionate the data. If you use the algorithms erroneously, or the functionalities that it gives for the parsing of data, the performance can fall drastically, even with few records. It is necessary to have people with experience to be able to determine which algorithm to use and understand why.

Incentivized

I believe that IBM generally has one of the worst and most complex assistance systems (physical and online) that exists.

Incentivized

SAP support has been outstanding. They have quick response times and always meet their SLAs. Any time we have an issue that needs to be researched they are able to get back to us quickly with resolution.

Incentivized

It's obvious since they both are from the same vendors and it makes it easier and can get better rates for licensing. Also, sales rapes are very helpful in case of escalations and critical issues.

Incentivized

Hands down Sybase has the best replication

Incentivized

• Reduce development time by 65% compared with hand coding.
• Reduces ETL process maintenance times.
• Better data governance for technical and non-technical people.
• Improve time to market for initiatives that require data integration.

Incentivized

• A positive is that it allow quick business decision making on the basis of real time data. Huge time saving for business.

Incentivized