--- title: "Setup Steps to Refresh data from SAP ECC Systems" slug: "setup-steps-to-refresh-data-from-sap-ecc-systems" updated: 2026-05-21T16:49:13Z published: 2026-05-21T16:49:13Z canonical: "skthelp.syniti.com/setup-steps-to-refresh-data-from-sap-ecc-systems" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Setup Steps to Refresh data from SAP ECC Systems ## Overview This article describes the steps required to refresh data from an SAP ECC system. Ensure that you have completed the [Prerequisites](/v1/docs/sap-ecc-via-syniti-rfc#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](/docs/setup-steps-to-refresh-data-from-sap-ecc-systems#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 | e.g.: MARA, DD02L, LFA1 | | ACTVT | 03 (Display) | | S_TABU_DIS | DICBERCLS | 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 1. Enter transaction **SM59** in the SAP system and click the **Create** button. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-5q7umzxs.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 2. Create a TCP/IP Connection, specifying RFC Destination (for example, NCO_SERVER) and an optional description to aid understanding. 3. Select the Registered Server Program type under the Technical Settings and specify the Program ID (for example, SKPStreamServer). 4. Save the record. > [!NOTE] > 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. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-6bwsjbwz.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 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] > 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. 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: 1. Enter transaction **SMGW** and select **Goto > Expert Functions > External Security > Maintenance of ACL Files**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-4h2rfw30.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 2. Select the **Reginfo File** tab on the Maintenance page and click the **Insert Line** button, and then select **Standard**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-9qrg0h3i.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 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. In the Comment field, enter a comment to aid understanding. 6. Save the record. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-mhnnqc68.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 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](/v1/docs/connect-using-sap-netweaver#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. #### 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 | e.g.: MARA, DD02L, LFA1 | | ACTVT | 03 (Display) | | S_TABU_DIS | DICBERCLS | 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 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. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-6msp4963.jpg?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 4. 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. - **For ECC:** /BOA/SDRM_READ_TABLE - **For S/4 HANA:** /BS4/SDRM_READ_TABLE | | Stream Read Table | Function for efficient data retrieval. By default: - **For ECC:** /BOA/STREAM_READ_TABLE - **For S/4 HANA:** /BS4/STREAM_READ_TABLE | | 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: - **-1:** no recovery - **0:** recover without delay - **n (other numeric value):** recover after n seconds. | | Extended Properties | Additional properties not listed in the grid. | > [!NOTE] > Note > > Complete the rest of the fields in the Add Target Connection wizard. Refer to [Add Target Connection Wizard](https://skthelp.syniti.com/v1/docs/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**. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-m4hqxoyb.jpg?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 2. In the Select Tables dialog box, expand the source navigation tree, and then click the schema, for example, SAPERP. > [!NOTE] > 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. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-ep7cjq21.jpg?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 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] > Note > > Append the percent (**%**) symbol to the first characters of a table to retrieve a list of tables that begin with specific characters. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-jpiro0q7.jpg?sv=2026-02-06&spr=https&st=2026-11-13T12%3A55%3A03Z&se=2026-11-13T13%3A55%3A03Z&sr=c&sp=r&sig=Z7MpwRvlZR3SChEOiBlDYdmTXzaEXvqsNv7nx3Mx8iY%3D) 4. Select the table(s) that need to be imported into the Source Connection table metadata store, and then click **OK**.