Set Up Staging Database

You can set up SAP HANA as your staging database for Master Data Replication:

Set Up Staging Database in SQL Server

To set up the staging database in SQL Server, perform the following steps:

1. In SQL Server, create a staging database named mag_sc_stg; ensure that your database administrator has granted you the required permissions to run the scripts in the mag_sc_stg database.
2. Copy the Content folder that is available in the product setup folder to the computer on which the you had created the mag_sc_stg database.
3. Extract the contents of the compressed folder and go to Content/STAGE/Sql server and run the COMMON_OBJECTS.SQL in the staging database. The common objects that are required for the different entities are created.
4. Run the other queries specific to the different entities available in the Content/STAGE/Sql server folder. The database objects, such as tables, views, and stored procedures, are created for the different entities in the staging database.
5. If your data source is SAP ERP Central Component, run the ecc_tables.SQL.
6. Run the RECON_OBJECTS.SQL available in the Content/STAGE/Sql server folder. The tables and views for the reconciliation reports are created in the staging database.

Set Up Staging Database in SAP HANA

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

1. In SAP HANA, create a user named mag_sc_stg; ensure that your database administrator has granted you the required permissions to run the scripts in the mag_sc_stg schema.
2. Copy the Content folder that is available in the product setup folder to the computer on which the staging database is installed.
3. Extract the contents of the compressed folder and go to Content/STAGE/Hana/Hana_BYPH and run the COMMON_OBJECTS.SQL as mag_sc_stg user in the staging database. The common objects that are required for the different entities are created.
   
4. Run the other queries specific to the different entities available in the Content/STAGE/Hana/Hana_BYPH folder. The database objects, such as tables, views, and stored procedures, are created for the different entities in the staging database.
5. If your data source is SAP ERP Central Component, run the ecc_tables.SQL.
6. Run the RECON_OBJECTS.SQL available in the Content/STAGE/Hana/Hana_BYPH folder. The tables and views for the reconciliation reports are created in the staging database.