Integrating with SAP - spectrum_platform - 23.1

Spectrum Quality Connector for SAP Guide

Product type
Software
Portfolio
Integrate
Product family
Spectrum
Product
Spectrum > Spectrum Platform
Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Quality Connector for SAP Guide
First publish date
2007
Last updated
2024-02-22
Published on
2024-02-22T23:28:41.647612

To integrate Spectrum Technology Platform with SAP, you need to install supporting databases and dataflows on the Spectrum Technology Platform server, and then configure your SAP system to communicate with Spectrum Technology Platform. Once you do this, users of SAP will have access to address validation and geocoding functionality from within SAP.

  1. On the Spectrum Technology Platform server, install the databases required to perform address validation, geocoding, and tax jurisdiction assignment and define database resources for each database.

    You must give the database resources the following names.

    Database Required Name for Database Resource
    Enterprise Geocoding - Canada Database IGEO_CAN
    Enterprise Geocoding - U.S. Database EGM_US
    Enterprise Tax Database ETM
    Universal Addressing - Canada Database Canada
    Universal Addressing - Loqate Database Loqate
    Universal Addressing - U.S. Database UAM_US
  2. When you install the SAP, several dataflow files are automatically installed. Other dataflow files must be manually copied into Spectrum Technology Platform.
    1. If you are adding Enterprise Tax or Universal Addressing to an existing installation, open Spectrum Technology Platform Enterprise Designer, select View > Server Explorer, and delete this dataflow: SAPValidateAddressWithCandidates.
    2. Go to: SpectrumDirectory\server\modules\dataflows\sap.
    3. Review the following table then copy the applicable dataflow files to:

      SpectrumDirectory\server\import

      If you are installing this set of modules Copy these dataflow files to the import folder
      Universal AddressingModule ValidateAddressWithCandidates_UAM.df

      SAPBatchValidateAddress.df

      Enterprise Geocoding

      ValidateAddressWithCandidates_EGM.df

      Enterprise Geocoding
      Universal Addressing

      ValidateAddressWithCandidates_UAM_EGM.df

      Enterprise Tax
      Universal Addressing

      ValidateAssignGeoTAXInfo.df
      SAPBatchAssignGeoTAXInfo.df

      SAPValidateAddressAndAssignGeoTAXInfo.df
      ValidateAddressWithCandidates_UAM_ETM.df

      Universal Addressing without Loqate


      SAPValidateAddressWithCandidate_UAM.df

      Universal Addressing without Loqate
      Enterprise Tax

      ValidateAssignGeoTAXInfo.df
      SAPBatchAssignGeoTAXInfo.df

      SAPValidateAddressAndAssignGeoTAXInfo.df
      SAPValidateAddressWithCandidates.UAM_ETM.df

      Universal Addressing with Loqate

      ValidateAddressWithCandidates_UAM_Loqate.df

      Universal Addressing with Loqate
      Enterprise Geocoding

      ValidateAddressWithCandidates_UAM_Loqate_EGM.df

      Universal Addressing with Loqate
      Enterprise Tax

      ValidateAddressWithCandidates_UAM_Loqate_ETM.df

      Universal Addressing with Loqate
      Enterprise Geocoding
      Enterprise Tax

      ValidateAddressWithCandidates_UAM_Loqate_EGM_ETM.df

      Universal Addressing, Loqate only

      ValidateAddressWithCandidates_Loqate.df

      Universal Addressing, Loqate only
      Enterprise Geocoding

      ValidateAddressWithCandidates_Loqate_EGM.df

      Enterprise Geocoding

      GeocodeUSAddressWithCandidates.df
      ValidateAddressWithCandidates_EGM.df

      Enterprise Tax

      ValidateAssignGeoTAXInfo.df
      ValidateAddressWithCandidates_ETM.df
      SAPBatchAssignGeoTAXInfo.df

      Note: If errors occur in Management Console or Enterprise Designer, delete the contents of WindowsTemporaryDirectory\g1Assemblies, where WindowsTemporaryDirectory is one of these: %TMP%, %TEMP%, %USERPROFILE%, or the Windows directory. Typically, C:\Documents and Settings\USERNAME\Local Settings\Temp\g1Assemblies. After deleting the contents of this folder, log in again.
  3. Import .SAR files.

    A .SAR file is a file that contains a third-party add-on package for SAP, such as the Spectrum Technology Platform SAP. The .SAR file is located on the Spectrum Technology Platform installer in the SAP Objects folder. For information about importing .SAR files into SAP applications, see your SAP Basis administrator.

  4. Activate the business configuration (BC) sets. The activation options and sequence differs for ECC and CRM installations.
    1. Activate BC sets for ECC and S/4 HANA installations
      1. Log on to the client where the settings for the Spectrum Technology Platform SAP is to be configured.
      2. Enter the transaction code SCPR20. This activates BC sets and places the default entries on the Spectrum Technology Platform customizing tables.
      3. In the BC Set field, enter keyword *hsgrp1* and find all the BC Sets in this namespace.
      4. Activate it with the options Overwrite All Data and Default Mode.


      5. Select and activate the BC sets with the activation options set to Overwrite All Data and Expert Mode
        Note: Activate these BC sets in the order listed.
        • /HSGRP1/BCSET_BC_BAS_DES
        • /HSGRP1/BCSET_BC_BAS_GTX
        • /HSGRP1/BCSET_BC_BAS_PV
        • /HSGRP1/BCSET_BUPA_CUSTOM
        • /HSGRP1/BCSET_DQC_CUSTOM
        • /HSGRP1/BCSET_VENDOR
        • /HSGRP1/DD_TCODE
        • /HSGRP1/FUZZY_SEARCH_INPUT_PARAM
        • /HSGRP1/MERGE_SETTINGS
        • /HSGRP1/ONP_PO
        • /HSGRP1/SPOD_CON_TABLE
        • /HSGRP1/SPOD_IN_TABLE
        • /HSGRP1/SPOD_OPT_TABLE
        • /HSGRP1/SPOD_OUT_TABLE
        • /HSGRP1/SPOD_PO
    2. Activate BC sets for CRM installations where ICWC isn’t required (IC Web Client)
      1. Log on to the client where the settings for the Spectrum Technology Platform SAP is to be configured.
      2. Enter the transaction code SCPR20. This activates BC sets and places the default entries on the Spectrum Technology Platform customizing tables.
      3. In the BC Set field, enter keyword *hsgrp1* and find all the BC Sets in this namespace.
      4. Activate it with the options Overwrite All Data and Default Mode.


      5. Select and activate the BC sets with the activation options set to Overwrite All Data and Expert Mode
        Note: Activate these BC sets in the order listed.
        • /HSGRP1/BCSET_BC_BAS_DES
        • /HSGRP1/BCSET_BC_BAS_GTX
        • /HSGRP1/BCSET_BC_BAS_PV
        • /HSGRP1/BCSET_BUPA_CUSTOM
        • /HSGRP1/BCSET_DQC_CUSTOM
        • /HSGRP1/BCSET_VENDOR
        • /HSGRP1/DD_TCODE
        • /HSGRP1/FUZZY_SEARCH_INPUT_PARAM
        • /HSGRP1/HYBRID_CONFIG
        • /HSGRP1/MERGE_SETTINGS
        • /HSGRP1/ONP_PO
        • /HSGRP1/SPOD_CON_TABLE
        • /HSGRP1/SPOD_CON_ENTRY
        • /HSGRP1/SPOD_IN_TABLE
        • /HSGRP1/SPOD_OPT_TABLE
        • /HSGRP1/SPOD_OUT_TABLE
        • /HSGRP1/SPOD_PO
        • /HSGRP1/SPOD_SSE_ENTRY
  5. Set up the RFC destination for Spectrum OnPremise.
    1. Enter transaction code SM59.
    2. Click Create.
    3. In the RFC Destination field, enter a name of your choice.
    4. In the Connection Type field, enter G (HTTP connection to external server).
    5. In the Description 1 field, enter a meaningful description.
    6. Press the Enter key.
    7. Click the Technical Settings tab.
    8. In the Target Host field, enter the computer name or IP Address of the Spectrum Technology Platform server.
    9. In the Service No field enter 8080.
    10. Click the Special Options tab.
    11. Select No Timeout.
    12. Select HTTP 1.1.
    13. After you save, click Connection Test.
      Note: If there is a pop-up window, check the Accept All Further Cookies box and select YES.
    14. When the test is successful, go to the Response Body tab to view the Spectrum Technology Platform page.
      Note: To setup RFC Destination for Spectrum OnDemand, seeIntegration of SAP with Spectrum on Demand.
  6. Set up the Spectrum Technology Platform Logging Object
    1. Enter transaction code SLG0.
    2. Click New Entries.
    3. In the Object column, enter /HSGRP1/DQC.
    4. In the Object text column, enter DQC Logging.
    5. Save the change.
  7. Configure the BuildGlobalAddress web service in the SAP Visual Admin:
    1. Go to drive:/usr./sap/system id/DVEBMGS01/j2ee/admin and click go.bat and enter J2EE_ADMIN as password.
    2. Go to Cluster > Server > Services > JCo RFC Provider and select the Bundles tab.
    3. Enter all the information needed by the application and click Set to save the changes.
    4. Go to Cluster > Server > Services > Web Services Security.
    5. Create a proxy in Web Services Client > sap.com > Dynamic WSProxies with the name ValidateAddressWithCandidates.
    6. For the URL, enter:

      http://spectrumservername:port/soap/ValidateAddressWithCandidates?wsdl

      For example,

      http://MySpectrumServer:8080/soap/ValidateAddressWithCandidates?wsdl

    7. Restart the application server.
  8. If you will be using French address validation, you must install the Data Normalization table cdq-TableLookup-SAP.tba on the Spectrum Technology Platform server. For more information, see the Spectrum Technology Platform Installation Guide.
  9. To configure DPV and RDI options, open T-code/hsgrp1/options, and specify Y (to enable) or N (to disable), as needed.
    • PVPO: For PO Box address validation

    • PVST: For street address validation

    • PVQU: For batch address validation