As a new member of the SAP Community Network and longtime database expert, I am excited to share my knowledge as a member of SAP’s Global Database Center of Excellence in what will be a regular blog.
My posts will be focused on the importance of data replication when integrating different applications and systems, an important theme that has relevance not only for those using SAP applications or SAP DBMSs, but also for users with applications or DBMSs from various other providers in the market.
In today’s post, I’d like to analyze a set of typical scenarios where systems integration and data replication is the key for business needs, as well as provide an overview of SAP Sybase Replication Server technology, which is a cornerstone of SAP's data movement strategy.
Current architectures employ or require the following from their IT systems:
While each of these cases pose their own unique data movement requirements, they all require a robust solution for real-time, low latency data movement – one that is capable of handling high data volumes with no performance impact to the source or target database system. SAP Sybase Replication Server is the best solution in the market with the required capabilities. Let's take a look at some key aspects of the solution:
With all these features SAP Sybase Replication Server allows businesses to leverage existing applications across multiple locations and geographies, make decisions based on the today’s information while feeling secure in the stability and reliability of their distributed enterprise environment.
One of the most interesting use cases is the ability to do heterogeneous data replication between multiple database systems comprising databases from SAP as well as other companies.
In Table 1 you can find the supported origin DBMSs and in table 2 supported destination DBMSs:
Table 1: Origin DBMSs |
---|
- SAP-Sybase: • ASE • ASA (version 11 and previous, not certified for ASA 12) |
- Non SAP-Sybase: • Oracle (11g, 11g ASM, 11g RAC, 10g, 10g ASM, 10g RAC, 9i ...) • MSSQL (2008 R1, 2008 R2, 2005 SP2 ...) • DB2 (9.7, 9.5, 9.7 Unix and OS/390) |
Table 2: Destination DBMSs |
---|
- SAP-Sybase: • ASE • ASA (version 12 valid as destination database) • Sybase IQ (12.7, 15.X) • HANA (Certification expected in Q1 2013) ➕ |
- Non SAP-Sybase: • Oracle (11g, 11g ASM, 11g RAC, 10g, 10g ASM, 10g RAC, 9i ... etc) • MSSQL (2008 R1, 2008 R2, 2005 SP2 ... etc) • DB2 (9.7, 9.5, 9.1 ... etc Unix and OS/390) • Theoretically any ODBC data source |
On my next blogs, I shall outline the SAP Sybase Replication Server architecture and sample configuration for a basic heterogeneous system replicating from Oracle 11g to ASE 15.7.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 |