Set Up Staging Database

For SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA, you can set up one of the following databases as your staging database for Transaction, Drilldown, and SyncBack:

• SAP HANA
• Microsoft SQL Server (2012 through 2019)

Note: The option to set SAP ASE as a staging database is deprecated from November 2022 release onwards.

Prerequisite Tasks

Before you set up the staging database, copy the setup files located at <Setup Folder>\Transaction Replication 8.0\Transaction Replication 8.0\SourceConnect 8.0\Stage to the computer on which you want to run the setup files.

SQL Scripts to Create Read-Only Login Access (MSSQL as Stage)

To create a login and user with read-only access to all reconciliation objects (Tables, Views, Procedures, and other scripts), follow these steps:

1. Run the sda_access.bat batch file by double-clicking it or running it in the command prompt.
2. Enter the Following Details:
   • serverhost_st: Stage MSSQL Server Hostname
   • username_st: Stage MSSQL Server Username
   • password_st: Stage MSSQL Server Password
   • master_schema: Master Database/Schema Name
   • stage_database: Stage Database Name
   • stage_schema: Stage Schema Name
   • Login_Name: New Login Name
   • Login_Password: New Login Password
   • User_Name: New User Name
   • Role_Name: New Role Name

Set Up Staging Database in SAP HANA

To set up your staging database in SAP HANA, perform the following tasks:

1. In SAP HANA, create a database user named MAG_SC_STG.

   Note: When setting up a database user, you can provide a username of your choice.

2. Open the Virtual_source_tables.sql file at <SetupFolder>\Stage\HANA folder, and do the following:
   1. As indicated in the Virtual_source_tables.sql file, create remote sources using smart data access in SAP HANA that point to the SLT Replication Server database and SAP S/4HANA database.
   2. Run the Virtual_source_tables.sql file. The virtual source tables are created.