Refresh data from SAP S/4HANA Systems via Syniti Replicate

Overview

This article describes the steps required to refresh data from an SAP S/4HANA system. Ensure that you have completed the Prerequisites steps before proceeding to configure Refresh replication for an SAP S/4HANA system.

User Authorization

The following Authorization Objects must be assigned to the user utilizing the standard Read Function extraction. If your scope is to utilize the Streaming functionality check the next section.

SAP Streaming Setup

To enable the data streaming capability in SAP S/4HANA the following steps must be taken:

Configure the Destination and Program

1. Enter transaction SM59 in the SAP system and click the Create button.

   

2. Create a TCP/IP Connection, specifying RFC Destination (for example, NCO_SERVER) and an optional description to aid understanding.

3. Choose the Registered Server Program type under the Technical Settings and specify the Program ID (for example, SKPStreamServer).

4. Save the record.

Note

Ensure that you make a note of the RFC Destination and Registered Server Program values that you have used as these will be required for the configuration of the SAP Connection in Replicate.

The RFC connection to the specific application has been created or registered in Syniti Replicate and table extractions triggered RFC streaming server gets activated.

Note

If you are downloading multibyte / unicode character sets, ensure that unicode is activated on the Unicode tab in the Destination setup.

If multiple SAP systems connection are required to be configure, then the RFC program ID can be updated to suit the specific SAP System ID SKPStreamServer<SAPSID>. The same Program ID must be used while registering the RFC connection to this SAP system from Syniti Replicate.

Configure the Gateway

After defining the Destination and Program for the Replicate Streaming Server, you need to set up the SAP Gateway to allow for the connection to the Replicate Server.

Depending on the SAP Netweaver version, that is, starting from v7.4, Gateway security is enhanced with the gw/acl_mode parameter influencing the external systems starting or registering external programs, such as gw/sec_info and gw/reg_info.

To register SKPStreamServer external program, complete the following steps:

1. Enter transaction SMGW and select Goto > Expert Functions > External Security > Maintenance of ACL Files.

   

2. Select the Reginfo File tab on the Maintenance page and click the Insert Line button, and then select Standard.

   

3. In the Create Line in Reginfo File dialog box, complete the following steps:

   1. In the P/D field, enter P.

   2. In the TP field, enter the Program ID value you entered in transaction SM59 above. For example, SKPStreamServer.

   3. In the HOST field, enter the IP address for the Replicate Server that you have or will be installing the Syniti Replicate software.

   4. Set the ACCESS and Cancel fields to *.

   5. Optionally, set the Comment field to aid understanding.

   6. Save the record.

      

After completing the change, you can reload the files without having to restart the gateway. To do this, in the gateway monitor (transaction SMGW), select Goto > Expert Functions > External Security > Reread.

Refer to Troubleshoot SAP RFC Connection when your test connection in Syniti Replicate fails.

This completes the setup on the SAP side to support the streaming capabilities embedded in Syniti Replicate v10.7.0.4 or later.

User Authorization

The following Authorization Objects must be assigned to the user utilizing the Streaming capabilities:

Syniti Replicate Setup

Add Source Connection Wizard

The following field(s) require specific information for SAP NetWeaver Extract.

Select Provider

1. On the Select Provider page, enter SAP ECC RFC in the Name field.

2. From the Database list, select SAP NetWeaver Extract.

3. On the Provider list, the Syniti SAP RFC .NET Data Provider option is selected by default.

4. Click Next.

Set Connection String Screen

Enter your connection information for your SAP system.

Note

Complete the rest of the fields in the Add Target Connection wizard. Refer to Add Target Connection Wizard for more information.

Select Source Tables

1. Right-click the Source Connection that represents the SAP System where data is being extracted and select Select Tables.

   

2. In the Select Tables dialog box, expand the source navigation tree, and then click the schema, for example, SAPERP.

   Note

   Avoid expanding the navigation tree below the SAPERP schema. If you expand it, the system attempts to load all the tables defined by the ‘TableMode’ connection property and could take a few minutes to complete.

   

3. Select the specific table that needs to be extracted by entering the name in the Filter field, and then clicking the Apply Filter icon.

   Note

   Append the percent (%) symbol to the first characters of a table to retrieve a list of tables that begin with specific characters.

   

4. Select the table(s) that need to be imported into the Source Connection table metadata store, and then click OK.