Prerequisites

Before you install SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA, you can review the sequence in which you must install the components and the prerequisite tasks that you must perform.

Prerequisite Tasks

Before you install SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA, ensure that the following tasks are complete:

• Review the system requirements in SAP Central Finance Transaction Replication by insightsoftware Release Notes, and ensure that your setup meets the minimum requirements.
• Copy the setup files for installing and setting up the product to the computer on which you want to install the product.
• Configure the source enterprise resource planning (ERP) system with the required modules.
• Ensure that the source database, such as Oracle E-Business Suite or Microsoft Dynamics AX, and target SLT Replication Server database are accessible from the SAP Data Services server. If required, open ports, and add TNS entries.
• Create an application user who has access to the ACDOCA, BKPF, SKA1, SKAT, T001, and T077Z tables in SAP S/4HANA and share the user credentials with insightsoftware consultants.
• Create a database user named MAGS4HDBUSR on the SAP side for the remote SDA connection from the staging database into SAP S/4HANA. The user must have read access to all the SAP S/4HANA tables in SAP S/4HANADB schema/user.

  Note: The name of the SAPHANADB schema may differ for each customer. This is the core schema that contains all the tables and can be found in the System Status window.

  
  
  

• Assign the SAP GUI user the SAP_BR_EMPLOYEE role and ensure that the user has access to the SAP Fiori query browser and the following roles:

  • /MAGSW/RECON_APF
  • /MAGSW/RECON_OVP
• Set up BryteFlow if you are using BryteFlow for change data capture (CDC). For information about setting up HVR, see the Setting Up BryteFlow.pdf document that is included with the setup files.
• Configure the SAP Landscape Transformation Server.
• Perform the following steps to download and install the product:
  1. Sign in to https://help.sap.com/ .
  2. Search for SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA. The SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA product page appears.
     
  3. Select the SAP Note link. The note number changes for each release. The SAP Note has further instructions to download the media and the required Attribute Change Package (ACP).
     
• Implement the following SAP Notes on SLT:

  SAP Note	SAP S/4HANA Version
  3632967	2025
  3340008	2023
  3169099	2022
  3155700	2021 (PLANT is optional)
  3116266	2021
  3079411	2021 and higher (This SAP note is applicable only for AVL. If you are not implementing AVL, you can disregard this note.)
  3067156	2021
  2922300	2020

  For information about implementing the SAP Notes, contact SAP Support.

• Create a database user named MAGSLTDBUSR in the SLT Replication Server with read and write access to the following tables. The database owner grants the required access to the user. This user will be used in SAP Data Services to connect to the SLT Replication Server database.
  • /1LT/CF_E_HEADER
  • /1LT/CF_E_ACCT
  • /1LT/CF_E_DEBIT
  • /1LT/CF_E_CREDIT
  • /1LT/CF_E_PRDTAX
  • /1LT/CF_E_WHTAX
  • /1LT/CF_E_COPA
  • /1LT/CF_E_CLRITM
  • /1LT/CF_E_CLRWHT
  • /1LT/CF_E_DOCCHG
  • /1LT/CF_E_EXTENT
  • /1LT/CF_E_EXT_IT
  • /1LT/CF_E_EXTCHG
  • /1LT/CF_E_SODOC
  • /1LT/CF_E_SOITEM
  • /1LT/CF_E_SOPART
  • /1LT/CF_E_SOSLN
  • /1LT/CF_E_CIDOC
  • /1LT/CF_E_CIITEM
  • /1LT/CF_E_PODOC
  • /1LT/CF_E_POITEM
  • /1LT/CF_E_POSCH
  • /1LT/CF_E_POACC
  • /1LT/CF_E_PORMD
  • /1LT/CF_E_PORSI
  • /1LT/CF_E_SIDOC
  • /1LT/CF_E_SIITEM
  • /1LT/CF_E_SIACC
  • /1LT/CF_E_SIGLAC
• Configure and start the replication in SLT Replication Server. Perform the following steps to start the replication:
  1. Create a mass transfer identifier with two RFC connections, one for SLT Replication Server and another for the target SAP S/4HANA system. A sample screenshot is as follows.
     
  2. Start replication for the mass transfer identifier that is created for the /1LT/CF_E_HEADER table.
     
  3. Start replication for AVL for the /1LT/CF_E_SODOC, /1LT/CF_E_CIDOC, /1LT/CF_E_PODOC, and /1LT/CF_E_SIDOC tables.
     
• Using Multiple Folders for Business Units: This scenario is applicable to customers who deploy Transaction in multiple instances of a source system. You can use different folder paths for files pertaining to each business unit and instance, such as DEV or QA. Transaction has the flexibility to create different system configurations and a substitution variable for each business unit and instance configuration. A screenshot showing the sample system configurations is as follows.
  

Prerequisite Tasks for Dynamics 365 Finance and Operations as source system

Before performing the prerequisite tasks for setting up Dynamics 365 Finance and Operations as your source system, it's important to understand the Data Management Framework or DMF.

The DMF is a standard tool in Dynamics 365 Finance and Operations that can be used to import, export, and copy data (setup, configurations, references, master, and document data). You require the DMF to export the Transaction data and Master Data into Azure SQL Database from where the exported data will be loaded into the staging database. The following procedure includes DMF from Step 9 onwards.

Complete steps 1-3 if necessary, or begin from step 4.

1. Create an LCS project by referring to Start a new LCS project.
2. If you don't have an Azure subscription, create one, and add it to your LCS project by referring to Add an Azure subscription to an LCS project .
3. Refer to Deploy and access development environments and deploy cloud hosted environment in the LCS project.
4. Connect to the RDP environment or VM created by the cloud hosted environment.
5. Import the AXPP files placed in the SCT/MSFTD365/custom Entities folder in to a new solution in the Finance and Operations environment in Visual Studio.

   Note: Refer to the SAP Central Finance Master Data Replication by insightsoftware Administrator Guide for the complete list of the custom entities.

6. Build and synchronize the entire solution.
7. Refer to Creating a SQL database to create an Azure SQL database.
8. Refer to Azure SQL Database and Azure Synapse IP firewall rules and install a firewall.
9. Go to Framework parameters under Data management in Finance and Operations and set up the required framework options as shown in the following images.
   
   
10. Go to Configure data source, create a new source data format by entering appropriate details and save the format.
    
11. Go to the Configure entity export to database option, double click on the source data format you created, and configure the connection string following the format shown in the screenshot.
    

12. To enable the incremental push load, go to Data Entities, select Source name, Entity, select Change Tracking, and update the tracking for entire entity or primary table or use a custom query.

    

13. Go to the Configure entity export to database, select Source name, Entity, and then select Publish. The job will go to queue and run. These jobs place these tables in your database, however, no data is added.

    
14. Select the Show published only option. The published entities are displayed.
15. To retrieve data in the published entities, go to Export > Create a new group or select an existing group. In the Add multiple section, change the Target data format to your data source, and your Default refresh type to Full push only. Then, search for the entities you wish to export.
    
16. The selected entities will be added. You can either export now or export in the batch job.
    

Prerequisite Tasks for Microsoft Dynamics 365 Business Central (Cloud) as Source System

Jet Data Manager, powered by TimeXtender, facilitates data extraction from Microsoft Dynamics 365 Business Central (cloud). Perform the following steps:

1. Locate the Jet Analytics Setup.exe file in the Business Central (cloud) folder within the SourceConnect 9.0 folder of the product package.
2. Run the setup file and complete the installation process.
   

   Note: To activate Jet Data Manager, obtain the required keys by contacting insightsoftware.

3. Open Jet Data Manager.
4. Import the project (.xml). This file is located in the Business Central (cloud) folder within the SourceConnect 9.0 folder.
5. Run the Connection Manager.
   
6. Edit the staging database settings by clicking the corresponding icon. Provide the necessary details and establish the connection.
   
7. Edit the BC 365 Provider settings by clicking the corresponding icon. Provide the necessary details and select Authorize OAuth.
   
8. Enter your credentials to connect to the data source.

Click here for more information on installing Jet Data Manager.

Prerequisite Tasks for Oracle NetSuite as a Source System

Before you can use Oracle NetSuite as a source system, you must install the NetSuite ODBC drivers and create an ODBC connection on your local system. After establishing the connection, you can use it to configure the datastore in the Data Pipeline tab.

1. Download and install the NetSuite ODBC drivers on your local system.
2. Press Windows + R to open the Run dialog box.
3. Enter odbcad32 and select OK.

   

4. Select the System DSN tab in the following window.
5. Select Add.

   

6. From the list of drivers, select NetSuite Drivers, and then select Finish.

   

7. In the SuitAnalytics Connect ODBC Driver Setup window, enter the following information:
   1. Name: Enter a descriptive name for the connection (for example, NetSuite_Production).
   2. Description: Enter an optional description.
   3. Account ID: Enter your NetSuite account ID (for example, 5172601_SB2).
   4. Role ID: Enter your NetSuite role ID (for example, 1073).
   5. Service Data Source: Select Netsuite.com from the dropdown list.
8. Select Test Connect.

   

9. In the authentication dialog box, enter your NetSuite credentials:
   1. User Name: Enter your NetSuite username.
   2. Password: Enter your NetSuite password.
10. Select OK. If the connection is successful, a confirmation message appears.
11. Select OK to save the connection settings.

Installation Sequence

You can install and configure SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA in the following order:

1. Set Up Staging Database
2. Set Up Data Services Objects
   1. Transaction and AVL
   2. Drilldown
   3. SyncBack
   4. Reconciliation
3. Install Transaction Replication Components on SAP S/4HANA
   1. Install Multi-target application (MTA)
   2. Install insightsoftware ABAP
4. Install Source System-Specific Objects
   1. Transaction and AVL
   2. Drilldown
   3. SyncBack
   4. Reconciliation

Note: After setting up the staging database, you can perform the tasks mentioned in steps 2, 3, and 4 concurrently as well.