Overview
This article describes the steps required to refresh data from an SAP ECC system. Ensure that you have completed the Prerequisites steps before proceeding to configure Refresh replication for an SAP ECC system.
User Authorization for Refresh
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 SAP Streaming Setup section.
Authorization Object | Authorization Field | Authorization Value |
S_RFC | RFC_NAME | /BOA/SDRM_READ_TABLE /BOA/SRTT_GET_TABLE_SIZE_RFC RFC_METADATA RFC_METADATA_GET RFC_FUNCTION_SEARCH GET_SYSTEM_TIME_REMOTE DDIF_FIELDINFO_GET PERF_TRA_DIA RFCPING (Optional, not required for all ECC versions) |
RFC_TYPE | FUNC or FUGR | |
ACTVT | 16 | |
/BOA/SDRMF | RFC_NAME | /BOA/SDRM_READ_TABLE |
ACTVT | 16 (Execute) | |
S_TABU_NAM | TABLE | <Name of Tables in scope> e.g.: MARA, DD02L, LFA1 |
ACTVT | 03 (Display) | |
S_TABU_DIS | DICBERCLS | <Authorization Group of Tables in scope> e.g.: MAT1, &NC&, FI01 |
ACTVT | 03 (Display) | |
S_TABU_CLI | CLIIDMAINT | Allowed |
SAP Streaming Setup
To enable the data streaming capability in SAP ECC for SAP NetWeaver 7.40 or later, complete the following steps:
Configure the Destination and Program
Enter transaction SM59 in the SAP system and click the Create button.
Create a TCP/IP Connection, specifying RFC Destination (for example, NCO_SERVER) and an optional description to aid understanding.
Select the Registered Server Program type under the Technical Settings and specify the Program ID (for example, SKPStreamServer).
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 going to be downloading multibyte / unicode character sets then ensure that unicode is switched on, 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 gw/acl_mode parameter influencing the external systems starting or registering external programs gw/sec_info and gw/reg_info.
To register the SKPStreamServer external program, complete the following steps:
Enter transaction SMGW and select Goto > Expert Functions > External Security > Maintenance of ACL Files.
Select the Reginfo File tab on the Maintenance page and click the Insert Line button, and then select Standard.
In the Create Line in Reginfo File dialog box, complete the following steps:
In the P/D field, enter P.
In the TP field, enter the Program ID value you entered in transaction SM59 above. For example, SKPStreamServer.
In the HOST field, enter the IP address for the Replicate Server that you have or will be installing the Syniti Replicate software.
Set the ACCESS and Cancel fields to *.
In the Comment field, enter a comment to aid understanding.
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 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 for Streaming
The following Authorization Objects must be assigned to the user utilizing the Streaming capabilities.
Authorization Object | Authorization Field | Authorization Value |
S_RFC | RFC_NAME | /BOA/STREAM_READ_TABLE /BOA/SDRM_TABL_CALLBACK /BOA/SDRM_READ_TABLE /BOA/SRTT_GET_TABLE_SIZE_RFC RFC_METADATA RFC_METADATA_GET RFC_FUNCTION_SEARCH GET_SYSTEM_TIME_REMOTE DDIF_FIELDINFO_GET PERF_TRA_DIA RFCPING (Optional, not required for all ECC versions) |
RFC_TYPE | FUNC or FUGR | |
ACTVT | 16 | |
/BOA/SDRMF | RFC_NAME | /BOA/SDRM_READ_TABLE |
ACTVT | 16 (Execute) | |
S_TABU_NAM | TABLE | <Name of Tables in scope> e.g.: MARA, DD02L, LFA1 |
ACTVT | 03 (Display) | |
S_TABU_DIS | DICBERCLS | <Authorization Group of Tables in scope> e.g.: MAT1, &NC&, FI01 |
ACTVT | 03 (Display) | |
S_TABU_CLI | CLIIDMAINT | Allowed |
Syniti Replicate Setup
Add Source Connection Wizard
The following field(s) require specific information for SAP NetWeaver Extract:
Select Provider
On the Select Provider page, enter SAP ECC RFC in the Name field.
From the Database list, select SAP NetWeaver Extract.
On the Provider list, the Syniti SAP RFC .NET Data Provider option is selected by default.
Click Next.
Set Connection String
Enter your connection information for your SAP system.
The tables below defines the available Syniti SAP RFC .NET driver connection properties along with recommended values to be used for properties.
| Required Parameters | Description |
| AppServerHost | IP Address or host name of application server |
| System ID | Unique identifier assigned to each individual SAP system |
| Client | SAP client number |
| System Number | Unique identifier for an SAP instance |
| User | User ID authenticating to the SAP System |
| Password | Password |
| Optional Parameters | Description |
| System Language | Select your system language |
| Read Table | Function allowing direct access to database tables.
|
| Stream Read Table | Function for efficient data retrieval. By default:
|
| Logon Group | Logon Group when connection is loading balanced/SAP Message Server |
| SNC Mode | Secure Network Communications mode enhances security for SAP connections. Set in True to use SNC |
| SNC Partner Name | Identification of the secure network partner |
| SNC Library Path | Directory containing secure network communications libraries |
| SNC QOP | Quality of Protection specifies the level of security using SNC |
| SNC SSO | Secure store and forward enhances security for message transmission |
| SAP Router | Secure communication tool for connecting SAP systems |
| Message Server Host | Server responsible for managing communication between SAP instances |
| Message Server Service | Service of the SAP system (message server). This can be the numeric description of the service port of the message server or the alphanumeric equivalent (for example, sapmsXXX, where XXX is the system ID of the SAP system). |
| Gateway Host | Entry point for communication between SAP systems and external applications |
| Gateway Service | The service that facilitates communication between SAP systems and external applications |
| Destination Server | Name of the destination defined in SM59 in SAP, for example: NCO_SERVER |
| Program ID | Unique identifier for a program running in the SAP system, for example: SKPStreamServer |
| Connection Count | SAP connection count refers to the total number of active connections to an SAP system |
| Max Pool Size | Maximum number of connections allowed in the pool |
| Fetch Block Size | Read Block Size. Specifies the amount of data retrieved in each fetch operation |
| Fetch Queue Size | Specifies the number of data blocks kept in memory during fetch |
Retry Delay | Period of time (in seconds) that a read operation should wait before attempting to recover a fetch error. Possible values:
|
| Extended Properties | Additional properties not listed in the grid. |
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
Right-click the Source Connection that represents the SAP System where data is being extracted and select Select Tables.
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.
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.
Select the table(s) that need to be imported into the Source Connection table metadata store, and then click OK.