Prerequisites

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

  • Familiarity with Microsoft SQL Server and SAP HANA database.

  • Valid licenses for Replication Server with ExpressConnect for HANA DB and Replication Server Options.

  • Valid licenses for Replication Server and Replication Server Options.

  • Valid licenses for the Replication Server and Replication Server Heterogeneous Edition.

  • Install and configure Microsoft SQL Server 2008 to serve as the primary (source) database from which Replication Agent replicates transactions, and SAP HANA database as the replicate (target) database.
  • Install Microsoft SQL Server JDBC driver 1.2.
  • TCP/IP connectivity 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. The Replication Server Reference Manual includes a complete list of reserved words.