Prerequisites

Review the prerequisites before you begin setting up Microsoft SQL Server-to-SAP HANA database replication.

Make sure:
  • You are familiar with Microsoft SQL Server and SAP HANA database.

  • You have valid licenses for Replication Server with ExpressConnect for HANA DB and Replication Server Options.

  • You have valid licenses for Replication Server and Replication Server Options.

  • You have obtained the licenses for the Replication Server and Replication Server Heterogeneous Edition.

  • Microsoft SQL Server 2008 is installed and configured to serve as the source (primary) database from which Replication Agent replicates transactions, and SAP HANA database is installed and configured as the target (replicate) database to which Replication Server with ExpressConnect for HANA DB replicates transactions.
  • Microsoft SQL Server JDBC driver 1.2 is installed.
  • TCP/IP connectivity is available between all hosts.
Because Replication Agent for Microsoft SQL Server is limited to the Microsoft Windows platform, all examples shown are for Windows.
Note: On Windows Vista and Windows Server 2008, you must be logged in as an Administrator.

Do not use Replication Server reserved words for object names or connection names. A complete list of reserved words is in the Replication Server Reference Manual.