#1 most frequent
United States of America
63.7%79 installations of 124
What is SAP Replication Server?
SAP's Sybase Replication Server is database development and management software.
Categories & Use Cases
Top Performing Features
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.8
Connecto to Big Data and NoSQL
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Category average: 7.8
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.1
Areas for Improvement
Business rules and workflow
Ability to define and manage business rules and workflows
Category average: 8.3
Collaboration
Collaboration is enabled by a shared repository of project information and metadata
Category average: 7.3
Integration with MDM tools
Integration with master data management tools to ensure data consistency across the organization
Category average: 7.8
Who Buys & Uses SAP Replication Server
#2 most frequent
Australia
5.6%7 installations of 124
#3 most frequent
India
5.6%7 installations of 124
Replication Server offers guaranteed delivery and data protection
Pros
- guaranteed delivery
- high availability
- scalable
- low latency
- data transformation
Cons
- make implementation easier
- make programming easier
- offer out of the box pre-defined use cases
Return on Investment
- Positive in the fact that Rep Server has prevented corruption from being propogated
- Positive - we continue to see value every day from the product
- Positive - we replicate our audit trail to an audit server that no one can touch - has helped to prevent and detect fraud
Alternatives Considered
Oracle GoldenGate
Other Software Used
MongoDB, SAP Adaptive Server Enterprise, Oracle Exadata Database Machine
Sybase Replication Server 11.9 review
Pros
- Training was excellent on the product.
- Great customer service when questions arose.
- Functionality was awesome.
- Bringing the main OLTP down for maintenance then allowed down time we could previously never afford to make SLA committments
Cons
- A few bugs existed in the specific implementation we created requirements for, and we had to wait for Sybase to fix those bugs before it went live to production
- Two way replication had issues where if the same table was being updated by both source and destination, a decision had to made on the "truth". We had to write some special software for specific business requirements.
- Sometimes RepServer would go down, and we didn't know about it until the next time a healthcheck was performed. We had to write some monitoring software to notify us if things went down.
Return on Investment
- The positive impact was better performance from our application using these new databases available to the business.
- Negative impact was development time
- Another negative impact was that Sybase engineering had to patch RepServer to fix a bug we discovered.
SAP replication server (Real Time data Transfer)
Pros
- Real time data transfer.
- Enhanced data monitoring and Transformation Capability.
- Low maintenance.
- Tight integration with SAP
Cons
- Data Reconciliation Functionality.
Return on Investment
- A positive is that it allow quick business decision making on the basis of real time data. Huge time saving for business.
Other Software Used
SAP Business Warehouse, SAP ERP
