TrustRadius: an HG Insights company

SAP Replication Server

Score9 out of 10

8 Reviews and Ratings

What is SAP Replication Server?

SAP's Sybase Replication Server is database development and management software.

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.9

  • 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.6

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.9

Areas for Improvement

  • Business rules and workflow

    Ability to define and manage business rules and workflows

    Category average: 8.2

  • Collaboration

    Collaboration is enabled by a shared repository of project information and metadata

    Category average: 7.8

  • Integration with MDM tools

    Integration with master data management tools to ensure data consistency across the organization

    Category average: 7.2

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