Recently, the packaging for SAP Sybase Replication Server (SRS) has changed to reduce the complexity of matching SRS components to the most commonly found replication use cases.

Before I get into it – here is a quick SRS Packaging 101 to get all of us on the same page.

SRS is packaged into various SRS Editions.   Editions are further extended with SRS Options.    Editions typically represent a common use case, or usage scenario. Depending on the scenario, Options are sometimes embedded or bundled into the relevant Edition.

The following SRS Editions are available today:

Edition

Used For

SAP Sybase Replication Server, enterprise edition

Base Replication Server Solution – includes SAP Sybase ASE replication functionality for source and target.

SAP Sybase Replication Server, real time loading edition

Replicating data into SAP Sybase IQ from Oracle and SAP Sybase ASE

SAP Sybase Replication Server, heterogeneous edition

Replicating data between traditional RDBMS solutions – Oracle, DB2, Microsoft SQL Server and SAP Sybase ASE

SAP Sybase Replication Server, change data capture edition

Replicating data from traditional RDBMS solutions into ETL solutions – like SAP Data Services

SAP Sybase Replication Server, SAP HANA edition

Replicating data from traditional RDBMS solutions into SAP HANA

Tips:  

  • Decide on the SRS edition first, matching the closest possible scenario.
  • If the target database is not supported by SRS, the CDC Edition offers integration with SAP Data Services, which has extensive support for many different data management environments.

With the latest update to packaging, it is not often where the SRS Options are required – only SRS, Enterprise Edition does not include SRS Options.    The options all provide functionality to replicate from and/or to different source or target systems.


Here is a list of available options:

Edition

What is it used for

SAP Sybase Replication Server, option for Microsoft SQL Server

License to use Microsoft SQL Server as a source and target for replication

SAP Sybase Replication Server, option for IBM DB2

License to use DB2 as a source and target for replication

SAP Sybase Replication Server, option for oracle

License to use Oracle as a source and target for replication

SAP Sybase Replication Server, option for SAP HANA

License to use SAP HANA as a target database

Tips:

  • SRS, Real Time Loading Edition, Heterogeneous Edition, Change Data Capture Edition and HANA Edition already include all Options supported and certified for that use case.
  • SRS Heterogeneous Edition does not include the Data Assurance Option, or the Advanced Services Option.
  • It is only necessary to add Options to SAP Sybase Replication Server, Enterprise Edition


Here’s a mapping that describes which options are included in Editions:

Edition

Option

SAP Sybase Replication Server, enterprise edition

None – includes ASE functionality by default (all editions do)

SAP Sybase Replication Server, real time loading edition

Includes Oracle Option – and IQ as a target – ASE functionality by default

SAP Sybase Replication Server, heterogeneous edition

Includes SQL Server, DB2, Oracle options –  ASE functionality by default.   Advanced Services and Data Assurance Features are not included in this package.

SAP Sybase Replication Server, change data capture edition

Includes SQL Server, DB2, Oracle options, and internal delta database – and ASE replication functionality by default

SAP Sybase Replication Server, SAP HANA edition

Includes SQL Server, DB2, Oracle, HANA options – ASE functionality by default

Finally – the following items are not available any more individually – because SAP Sybase Replication Server, Enterprise Edition, and all relevant Editions already includes the functionality.   

  • SAP Sybase Replication server
  • SAP Sybase Replication server, Advanced ServicesOption
  • SAP Sybase Replication server, Data Assurance Option

* For Mainframe Scenarios, Replication Agent for DB2 needs to be licensed separately.

In conclusion – SAP Sybase Replication Server Editions offer broad support for multiple use cases – be sure to look into some of the new Editions to unlock value in your organisation.

Please reply with your comments, or questions…

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. BI DEVELOPER

    Hi Rudi,

    My source is MSSQL Server and Target is SAP Sybase IQ. I wan to use IQ as Dataware house, before loading data to IQ, I want to perform some ETL.

    SAP Sybase Replication Server, option for Microsoft SQL Server is perfect for me ?

    Further more on top on IQ, can I implement BI4 for enterprise reporting ?

    (0) 
    1. Rudi Leibbrandt Post author

      Hello BI Developer.

      Answering question 2 first – yes, you can use BI4 for Enterprise Reporting!

      I would reach out to your SAP Account Executive for clarification, and ask for some pre-sales support.  

      The only “certified” sources for real time, direct replication into SAP IQ is Oracle, and SAP ASE.   Anything else needs to be staged in an interim SAP ASE database – which I’m sure your SAP account team or partner can help with.     The SRS, Real Time Loading Edition contains the capabilities of loading into IQ. 

      There *might* be a way to use the IQ “RLV” functionality to replicate directly into IQ – but, I would work closely with SAP consulting or pre-sales for this.

      (0) 
      1. Jeff Tallman

        Actually, given the ETL requirement for BI Developer, it sounds like he/she has some complex transformation or master data management processes….which means they could use RS/CDC edition to replicate MS SQL –> RS/CDC –> SAP Data Services –> HANA.

        (0) 
  2. Michael Harding

    Hi Rudi –

    Just to clarify, Rep server isn’t included with any of the ASE licensing?  We’re being told that Rep Server can be used as an HA or DR solution for ASE, but not clear as to what that means from a licensing standpoint.

    (0) 
    1. Jeff Tallman

      If you bought ASE runtime licenses for SAP applications, it includes RS licensing and DR components.   Otherwise, for custom applications, certain ASE licenses (e.g. DR license) includes RS restricted use licenses for DR sites.   Going forward, in ASE 16 sp02 –  2015 Q2-ish time frame, we are going to be releasing a new ASE option for HADR that moves RS more from the DR aspect into a mixed HA and DR aspect with a synchronous rep agent protocol to RS to protect from data loss, fault monitoring, ASE HADR mode, ASE client failover, etc.   Tentatively, this HADR option looks like it will be called ASE Data Shield – but that could change, obviously, between now and 2015 Q2-ish

      However, in those use cases, when packaged as part of an ASE option, the RS licensing is usually restricted in some way, shape or form.   Beyond that, full use RS licensing is needed.

      (0) 
      1. Michael Harding

        Thanks for the clarification, Jeff.

        So bottom line, even if I own ASE and am using it, if I want to use RS strictly for replication (i.e., from SAP ERP to HANA), I need to consider a separate license?

        (0) 
        1. Jeff Tallman

          Depends on which package you bought with ERP or HANA ….some “bundles” included RS, but yes, at worst case, you would need RS/HANA edition.   Best bet is to ask your Account Rep – or check with Rudi Liebbrandt as he is closest to which SAP bundles included SRS.

          (0) 

Leave a Reply