Reference 360 Extension for SAP Finance > Deploying Reference 360 Extension for SAP Finance > Configuring Reference 360 Extension for SAP Finance assets
  

Configuring Reference 360 Extension for SAP Finance assets

After you extract the extension package, import the extension assets to MDM - Reference 360.
Note: Before importing the data model, pages, and reference data assets, ensure that you are assigned to the Designer, MDM Designer, Reference 360 User, and Reference 360 Business Steward user roles, and not to the Admin user role.
Importing the extension assets overwrites your customization and the existing Reference 360 assets.

Importing the Business 360 application assets

Import the predefined Cloud Data Quality rule specifications, dictionaries, and mapplets related to Reference 360 Extension for SAP Finance to validate SAP ECC and SAP S/4HANA data. You can also import the predefined custom pages, source systems, and job assets to synchronize SAP ECC and SAP S/4HANA data with Reference 360 in batches.
    1In Business 360 Console, click Explore > Import.
    2Navigate to the following file:
    <Extracted extension package>/1_MDM_Assets.zip
    3Click Open.
    4On the Import Assets page, ensure that all the assets are selected, and click Import.
    5On the My Import/Export Logs page, verify whether the import job is successful.

Importing reference data assets and code lists

Import the reference data sets and code lists in your environment through API calls using the reference data JSON files.
To import to the Reference 360 Extension for SAP Finance assets, use the JSON files in the following folder:
<Extracted extension package>/Reference Data/Create/Master Entities
Run the Postman API in the following order:
  1. 1R360 GL COA Master.json
  2. 2R360 GL CompanyCode Master.json
  3. 3R360 Cost Center.json
For more information about importing reference data assets, see Import version 2 in the Reference 360 REST API help.

Importing Cloud Data Integration assets to integrate with SAP

You must import the Cloud Data integration assets to integrate SAP ECC and SAP S/4HANA and .
To import the Cloud Data Integration assets, perform the following steps:
    1In Data Integration, click Explore > Import.
    2Navigate to the following file:
    <Extracted extension package>/2_DI_Assets.zip
    3Click Open.
    The Import Assets page lists the assets in the file.
    4Ensure that all the assets are selected, and then select Publish Taskflow(s) after import.
    5Click Import.
    6On the My Import/Export Logs page, verify that the import job is successful.

Configuring a dictionary

Configure the Range_Dictionary dictionary to concatenate the Chart of Account and Account Group columns. Add the reference data in the dictionary manually.
    1In Data Quality, click Explore > Reference 360 > SAP Extension.
    2Select Range_Dictionary.
    3Click the Configuration tab.
    A design workspace for the dictionary appears.
    4 Add the dictionary data.
    Note: Column 1 concatenates the Chart of Account and Account Group attributes. Column 2 defines the lower limit, and Column 3 defines the upper limit.
    For more information about adding data to a dictionary, see Adding data to a dictionary in the Data Quality help.
    5Save the dictionary.

Adding code values to the reference data assets

You can import the code values to the reference data assets by using Reference 360. Add the reference data code values to the R360: Account Type and R360: Reconciliation Account reference data assets.
    1To access the Administrator service, assign the Reference 360 Business Steward role to the user.
    1. aIn Administrator, click Users.
    2. bSelect the user name to assign the role.
    3. cIn the Assigned User Groups and Roles section, enable the Reference 360 Business Steward role.
    4. dClick Save.
    2To import data into Reference 360, upload the CSV file with code values.
    1. aIn Reference 360, from the Explore page, select the reference data to which you want to add the code values.
    2. bClick the Import Values icon.
      3. The Upload File page of the Import Values wizard appears.
    3. cTo select a file to upload, drag a CSV source file, or click Browse and select the source file.
      4. The first 10 rows of records appear in the preview section.
      The following table lists the code values and the location:
      Reference Data Asset
      Code Value File Location
      ECC Account Type
      <Extracted extension package>/Reference Data/Load/ECCAccountType
      ECC Reconciliation Account
      <Extracted extension package>/Reference Data/Load/ECCReconciliationAccount
      ECC Tax Code
      <Extracted extension package>/Reference Data/Load/ECCTaxCode
      S4H Account Type
      <Extracted extension package>/Reference Data/Load/S4HAccountType
      S4H Reconciliation Account
      <Extracted extension package>/Reference Data/Load/S4HReconciliationAccount
      S4H Tax Code
      <Extracted extension package>/Reference Data/Load/S4HTaxCode
    4. dClick Next.
      5. The Map Fields page appears.
    3 After you select the file to import, the import process automatically maps the possible columns to the suitable target fields. You can either use the system suggested mapping or modify the mapping as required.
    1. aOn the Map Fields page of the Import Values wizard, verify the system suggested mapping of fields.
    2. bTo manually map any field, perform one of the following tasks:
      3. The import process maps the field accordingly.
    3. cVerify the mapping of all fields and ensure that all the required fields are mapped.
    4. dClick Next.
      5. The Preview and Import File page appears.
    4 After you map the fields, use the preview section to review and verify the mapping, and then import the data.
    1. aOn the Preview and Import File page of the Import Values wizard, verify the mapping.
      2. If the preview does not return desired results, you can go back to the Map Fields page to map the fields again.
    2. bTo import the file, click Import.
      3. The import process starts. You get a notification after the import process is complete.
    Note: For more information about importing code values, see .

Adding a Secure Agent to the Secure Agent group

You can add a Secure Agent to the predefined Secure Agent group.
    1In Administrator, click Runtime Environments.
    2Expand the Actions menu for the infa_extension_runtime Secure Agent group, and select Add or Remove Secure Agents.
    3In the Available Agents list, select the Secure Agent that you want to add to the group, and click Select.
    4Expand the Actions menu for the infa_extension_runtime Secure Agent group, and select Enable or Disable Services, Connectors.
    5From the Services tab, select the services to enable for the Secure Agent group.
    6From the Connectors tab, select the connectors to enable for the Secure Agent group.
    7Click Save.

Importing parameter files

To import parameter files, save the parameter files in the Secure Agent Installation directory.
    1Copy all the parameter files from the following directory:
    <Extracted extension package>\Secure Agent Files\Parameter Files
    2Copy the parameter files into the following directory:
    <Secure Agent Installation Directory>\apps\Data_Integration_Server\data\userparameters
    Optionally, if you want to use a configured path for the target location, see Parameter file location in the Mappings documentation of the Data Integration help.

Configuring the flat file connection

After you import the Reference 360 Extension for SAP Finance assets, configure the flat file connection to access the flat files from the Secure Agent.
To configure the flat file connection, perform the following steps:
    1In Administrator, click Connections.
    2Click infar360sap_conn_flatfile.
    3Configure the directory to store the flat file.
    Default is C:\ReferenceData.

Configuring the SAP connection

You can use SAP Table connection to integrate SAP ECC and SAP S/4HANA with MDM - Reference 360 in batches.
    1To configure a SAP Table connection, perform the following steps:
    1. aVerify if the required licences are available for SAP Table Connector to create an SAP table connection and process SAP table data.
    2. bDownload and install the Microsoft Visual C++ Redistributable package on the Windows machine that hosts the Secure Agent.
    3. cDownload and configure the SAP libraries on the Secure Agent machine to read from and write to SAP tables.
    4. dTo enable the Secure Agent to connect to the SAP system as a Remote Function Call (RFC) client, create and configure the sapnwrfc.ini file on the machines that host the Secure Agent.
    5. eConfigure the SAP user account to process SAP table data.
    6. fInstall the SAP Table connection transport files on the SAP machines that you want to access.
    7. gTo connect to SAP through HTTPS and read SAP table sources, configure the machine that hosts the Secure Agent and the machine that hosts the SAP system.
    For more information about the SAP Table Connector, see SAP Table Connector in the SAP Table Connector documentation.
    2Configure the following connections:
    The following table describes the SAP Table connection properties:
    Connection property
    Description
    Runtime Environment
    Required. Runtime environment that contains the Secure Agent that you want to use to access SAP tables.
    Username
    Required. SAP user name with the appropriate user authorization.
    Password
    Required. SAP password.
    Client
    Required. SAP client number.
    Language
    Language code that corresponds to the SAP language.
    Saprfc.ini Path
    Required. Local directory to the sapnwrfc.ini file.
    To write to SAP tables, use the following directory:
    <Informatica Secure Agent installation directory>/main/bin/rdtm
    Destination
    Required. DEST entry that you specified in the sapnwrfc.ini file for the SAP application server.
    Destination is case sensitive.
    Note: Use all uppercase letters for the destination.
    Port Range
    HTTP port range. The SAP Table connection uses the specified port numbers to connect to SAP tables using the HTTP protocol. Ensure that you specify valid numbers to prevent connection errors. Default: 10000-65535.
    Enter a range in the default range, for example, 10000-20000. When a range is outside the default range, the connection uses the default range.
    Test Streaming
    Tests the connection. When selected, tests the connection using both RFC and HTTP protocol. When not selected, tests connection using HTTP protocol.
    Https Connection
    When selected, connects to SAP through HTTPS protocol. To successfully connect to SAP through HTTPS, verify that an administrator has configured the machines that host the Secure Agent and the SAP system.
    Keystore Location
    The absolute path to the JKS keystore file.
    Keystore Password
    The destination password specified for the .JKS file.
    Private Key Password
    The export password specified for the .P12 file.
    3Test the connections, and ensure that the connections are successful.
    4If the SAP instance and the Secure Agent are installed in the same Virtual Private Cloud (VPC) network, perform the following steps:
    1. aConfigure the Secure Agent host to use the private IP address to access the SAP instance.
      1. aOpen the following file on the Secure Agent:
        • ▪ On Windows. \Windows\System32\drivers\etc\hosts
        • ▪ On Linux. /etc/hosts
      2. bAdd an entry for the SAP instance in the following format:
        3. <SAP Hostname> <Private IP address of SAP Host>
      3. cRepeat steps 4.a.i through 4.a.ii for all the SAP instances available in VPC as Secure Agent host.
    2. bFor communication between SAP instance and Secure Agent, add a custom DTM configuration property to use the private IP address of the Secure Agent host.
      1. aIn Administrator, click Runtime Environments.
      2. bExpand the Actions menu for the Secure Agent, and select Edit Secure Agent.
      3. cIn the Custom Configuration Details section, enter the following details:
        4. Field Name
        Value
        Services
        Data Integration Server
        Type
        DTM
        Name
        SapTableReaderNatIpAddress
        Value
        <Private IP address of Secure Agent host>
      4. dClick Save.
        5. The Secure Agent restarts automatically within 10 minutes. To apply the properties immediately, you can restart manually. Ensure that no tasks run to avoid failure of any running task.
    3. c Test the connection to verify the connectivity between SAP and the Secure Agent host.
      4. If the connection test is unsuccessful, disable the firewall to resolve the issue.

Configuring the Reference 360 connection

After you configure the SAP connection, configure the Reference 360 connection.
    1In Administrator, click Connections.
    2Click infar360sap_conn_Finance360.
    3Test the connection, and ensure that the connection is successful.