How to use the results of WHINT InterfaceCatalog

The WHINT InterfaceCatalog for SAP PRO/PI generates two Excel Documents to bring more transparency to your interface landscape. Here is how you can better understand the results:


Channel Catalog

  • a list with all communication channels
  • contains all adapter attributes
  • contains all adapter modules
  • contains all parameters within each adapter module
  • You can filter and/or search for specific values as host names, user names, modules used, etc. across all channels

IFC14

 


Interface Catalog

  • a list of all sender/receiver interface combinations
  • contains operation mappings used
  • contains routing (receiver determination and interface determination)
  • contains an assignment to configuration scenario(s)

Example iFlow / Integrated Configuration

IFC9

IFC12IFC13

 

is shown in the InterfaceCatalog as follows:

IFC10IFC11

WHINT now Registered Trademark in Germany

Since October 2016 WHINT® is a registered trademark in Germany and represents our software product line whint://Solutions. Each product name of Whitepaper InterfaceDesign contains the term WHINT®.

IMG_6870

WHINT WebDAV Adapter (On-Premise)

Functionality

This JCA Adapter for SAP PI / SAP Process Orchestration (PRO) supports the WebDAV protocol (Web-based Distributed Authoring and Versioning) which is based on http(s) and allows read/write access to any WebDAV provider that implements the protocol, such as e.g. Telekom MagentaCloud, Box.com, ownCloud, … 


Prerequisites

  • Works with SAP PI 7.1 and higher (incl. SAP Process Orchestration 7.50)
  • Deploy the SCA file provided by Whitepaper InterfaceDesign using NWDS/JSPM/SUM/Telnet
  • Import the TPZ file provided by Whitepaper InterfaceDesign into the ESR

Usage

  • Create a new sender or receiver communication channel and select the adapter “WebDAV” from namespace “http://whint.de/xi/WDA” (Software Component WHINT_WDA 2016.04 of whitepaper-id.com)
  • Transport Protocol: WebDav / HTTP
  • Message Protocol: File
  • Other Options
    • URL (http/https)
    • Proxy (optional)
    • Authentication (Username/Password)
    • Filename
    • Directory
    • Set/Use Adapter-specific Message Attributes (ASMA)
      • Namespace: http://whint.de/xi/WDA
      • FileName
      • Directory
      • Size (sender only)
      • Timestamp (sender only)
      • Host (sender only)
    • Sender Only
      • Poll-Interval in seconds (Sender)
      • Delete file (Yes/No)
      • Duplicate file checking (Yes/No)
      • Quality of Service (EO/EOIO)
      • Archiving on WebDAV Server (Directory/Filename)

Example

WDA1

WDA2

 

whint://Solutions now in SAP HCI Content Catalog

WHINT AMQP Adapter (On-Premise)

Functionality

This JCA Adapter for SAP PI / SAP Process Orchestration (PRO) supports the Advanced Message Queuing Protocol (AMQP), a reliable way to establish a properly decoupled application integration using message queues and topics. AMQP defines both the network protocol and the server-side services through a defined set of message capabilities called AMQ model, which consist of a set of components that route and store messages within the broker service and a network wire-level protocol, that lets client applications talk to the server and interact with the AMQ model it implements.

It connects asynchronously to the followings Brokers by sending and receiving messages in a reliable way:

  • Microsoft Azure Service Bus (Cloud)
  • RabbitMQ (On-Premise/Cloud)

Prerequisites

  • Works with SAP PI 7.1 and higher (incl. SAP Process Orchestration 7.50)
  • Deploy the SCA file provided by Whitepaper InterfaceDesign using NWDS/JSPM/SUM/Telnet
  • Import the TPZ file provided by Whitepaper InterfaceDesign into the ESR

Usage

  • Create a new sender or receiver communication channel and select the adapter “AMQP” from namespace “http://whint.de/xi/AMQ” (Software Component WHINT_AMQ 2016.04 of whitepaper-id.com)
  • Transport Protocol
    • Select one of the following transport protocols
      • MS Azure – to connect with a Microsoft Azure Service Bus
      • RabbitMQ – to connect with a RabbitMQ Broker
  • Message Protocol
    • The message procotcol is preselected based on the transport protocol. The following are available so far:
      • AMQP 1.0 – This is the message protocol for MS Azure
      • AMQP 0-9-1 – This is the message protocol for RabbitMQ
  • Other Options
    • Host & Port
    • Virtual Host (RabbitMQ)
    • SSL/TLS enabled
    • Queue / Exchange Name
    • Topic Support
      • Subscription ID (MS Azure)
      • Exchange Type: direct/headers/fanout/topic (RabbitMQ)
      • Routing Key (RabbitMQ)
    • Consuming Interval (secs/msecs)
    • Authentication based on User/Password
    • Quality of Service (EO/EOIO with queue name)
    • Set/Use Adapter-specific Message Attributes (ASMA)
      • Namespace: http://whint.de/xi/AMQ
      • externalMessageID – Message Id received from broker
      • CreateDateTime – Timestamp of message creation
      • QueueExchangeID – Name of the Queue / Exchange Name
      • RoutingKey (only RabbitMQ)

Example

AMQo1

AMQo2

AMQo3

WHINT InterfaceCatalog for SAP Process Orchestration / PI

Functionality

This solution provides you with an overview about your Integration Landscape: All information from your configuration (Integration Directory) of your SAP Process Orchestration System. The tool downloads (e.g. periodically)

  • the Interface Catalog (based on all Integrated Configurations),
  • the Channel Catalog (based on all channels or on all channels used in the Integrated Configurations) and
  • the Interface Catalog Classic (optionally for PI only, based on Dual-Stack classic routings).

as an Excel Sheet.

All Routing information can be read as well as all communication channel attributes (e.g. host name) and all adapter modules including the corresponding parameters.

It answers questions like

  • what are the routing conditions for Partner X or IDoc Y ?
  • where do we use a specific FTP host?
  • where do we use Content Conversion (also via the MessageTransform Bean) ?

The solution is not invasive (no specific installation needed) and runs completely as interfaces using Standard PI/Process Orchestration technology. Only read access is required using the Integration Directory API.

IFC3

IFC4

IFC5


Prerequisites

  1. Import the TPZ file provided by Whitepaper InterfaceDesign into the ESR
  2. Configure the Process Integration Scenario using the Swing Client (Integration Builder: Directory) or Eclipse (SAP NetWeaver Developer Studio – NWDS) – see Configuration Guide below

IFC15


Configuration Guide

  1. Create a user to access via the Integration Directory API (SOAP Receiver Lookup Channels) with the roles: SAP_XI_API_DISPLAY_J2EE and SAP_XI_APPL_SERV_USER
  2. Create two components according to your naming conventions, e.g. WHINT_IFC_Reader and <SID>_FILESYSTEM (in PI 7.11 it must be a Business System, for newer releases it can be either Business Component or Business System)
  3. Create all necessary SOAP Lookup Channels using the Channel Templates provided for the Objects
    • Communication Channel
    • Integrated Configuration
    • Configuration Scenario
    • Classic only: Receiver Determination
    • Classic only: Interface Determination
    • Classic only: Sender Agreement
    • Classic only: Receiver Agreement
  4. Start the wizard with the Process Integration Scenario WHINT_InterfaceCatalog, select the Component view matching your release and assign the systems to generate your iFlows/ICOs
  5. Assign the lookup channel parameters and select the correct NFS path where to write/read files
  6. Repeat this activity for Process Integration Scenario WHINT_InterfaceCatalog_Classic if you want to create the Dualstack InterfaceCatalog as well

IFC7

IFC6


Messages at Runtime

IFC1


Bitcoin Currency Rates now available from Blockchain

We have enhanced our cloud edition of WHINT CurrencyRates with a new provider: Blockchain.info.

The API provides bitcoin exchange rates for the major currencies and integrates automatically into SAP (e.g. ECC/ERP/CRM).

WHINT CurrencyRates (On-Premise Edition)

This Integration Package for SAP Process Orchestration (PRO)/ SAP PI is a turn-key solution to retrieve currency rates from different data feeds into SAP Business Suite. No additional development is needed on SAP side, only a simple ALE IDoc inbound processing partner profile needs to be configured. You will receive an automatic update of the exchange rates into SAP (table TCURR) via a standard IDoc.

CRO1


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP Process Orchestration (PRO)/SAP PI
  • Mapping, Connectivity and Interface Processing just needs to be activated with a few steps
  • Data provider for Currency Rates
    • ECB – European Central Bank with daily reference rates against the Euro
    • OANDA – FX Feed provides a wide range of over 190 currencies and commodities with daily, weekly, monthly or custom time periods as well as historical rates dating back to 1990

Prerequisites

  • SAP PI 7.1 and higher
  • The data from ECB is available publicly, but for other providers you might need a subscription (e.g. with OANDA)

Pricing

Terms & Conditions (On-Premise)

Yearly Subscription


Configuration Guide: SAP PRO/PI

  1. Import the Integration Content (tpz file) ESR. Result: Software Component WHINT_CRO 2016.06 will be visible.
  2. Configure the Integration Package in Integration Directory/NWDS Integration Designer by starting the wizard for Process Integration Scenario WHINT_CurrencyRates (http://whint.de/xi/CRO).
  • Select the scheduling according to your needs, e.g. daily at 10 PM.
    • In case you use WHINT MessageTrigger Job, you define this in the NWA Job Sceduling
    • If not, you set up a FILE Sender Channel, which is polling a dummy file in Test mode which is scheduled in the communication channel monitor
  • Check the FX Rates Provider URL and add your API key or credentials (if necessary)
  • Configure SSL connectivity to the https/SSL URL by downloading the CA´s and updating them into your keystore
  • Configure the SAP Business System Connectivity

CR_C8

In this example, the two CA´s (DigiCert) have to be imported into the NWA keystore (view TrustedCAs).

CRO2


Configuration Guide: SAP Business Suite 

  1. Check if IDoc-XML Messages can be received
  2. Create ALE Logical System
  3. Create partner profile for IDoc

Transaction SRTIDOCActivate Service /sap/bc/srt/idoc by executing variant IDOC_STANDARD. This is only necessary for HTTP IDoc communication. For Standard tRFC communication this step can be skipped.

Transaction SALE: Add your logical system name which represents the data provider (e.g. ECB)

CR_C1

Transaction WE20

CR_C2 CR_C3


Monitoring the Message Flow

Transaction BD87

CR_C4

Transaction OB08 finally shows the contents of table TCURR, the central exchange rates table in SAP. 

WHINT PaymentReporting Ingenico (Cloud Edition)

This Integration Package for SAP HANA Cloud Integration (HCI) is a turn-key solution which seamlessly integrates Ingenico ePayment reporting data into SAP FI (Ingenico ePayments was formerly known as GlobalCollect).
It enables the automatic processing of the Ingenico Collection Appendix Report as SAP FI documents with state-of-the-art integration technology. No changes or developments are required on SAP ERP side, only a few configuration steps are needed (ALE IDoc inbound processing).The accounting documents will be created automatically via a standard IDoc. Other Reports (Financial Statements) can be picked up automatically as well and e.g. sent via E-Mail.

It enables the merchant to process and reconcile payment processing data and match it with his transactional order-related data in SAP Finance.

PRI_HCI


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP HANA Cloud Integration (HCI)
  • Mapping, Connectivity and Interface Processing just needs to be activated with a few steps
  • Data provider for Payment Reporting 
    • Ingenico ePayments is the online and mobile commerce division of Ingenico Group – connecting merchants and consumers, enabling businesses everywhere to go further beyond today’s boundaries, creating the future of global commerce
  • How it works
    • The regular sales transactions (e-commerce, retail, …) are posted into SAP Finance using the transaction id of Ingenico against credit card/payment type specific G/L accounts (Debit)
    • The payment reporting data is also posted into SAP Finance against the same G/L accounts using the same allocation number (Credit). Like this, the postings can be reconciled easily. The total balance is posted on a receivables G/L account (Debit) which can be reconciled against the financial statement coming from the electronic bank statement.
    • The solution handles the creation of the SAP FI accounting document by picking up the Ingenico Collection Appendix Report and converting (mapping) it automatically.

Prerequisites

  • SAP HANA Cloud Platform, integration service (SAP HCI)

Configuration Guide: SAP Cloud Platform Integration (CPI aka HCI)

  1. Import Integration Package into your HCI tenant
  2. Configure Integration Package
  • Select the scheduling according to your needs, e.g. daily at 10 PM or every hour.
  • Check the SFTP Address and provide your credentials
  • Add User Credentials under Monitoring -> Security Artefacts
  • Add the SFTP Public Key into the known_hosts file and deploy it under Monitoring -> Security Artefacts
  • Configure the SAP Business System Connectivity
  • Maintain the Value Mappings for Account Determination, … tbd.

Configuration Guide: SAP Business Suite 

  1. Check if IDoc-XML Messages can be received
  2. Create ALE Logical System
  3. Create partner profile for IDoc

Transaction SALE: Add your logical system name which represents the data provider (e.g. INGENICO)

CR_C1

Transaction WE20: Maintain Message Type ACC_DOCUMENT for partner (LS) INGENICO with process code BAPI.


Monitoring the Message Flow

Transaction BD87 shows the processed IDoc

Transaction FB03 finally shows the accounting document in SAP. 


SAP Certified – Integration with Cloud Solutions

SAP_ICC_Cloud

We have passed the certification at SAP ICC for our first Turn-key Solution delivered on SAP HANA Cloud Platform, integration service (SAP HCI)!

WHINT CurrencyRates is a plug&play Integration Content which can be deployed effortlessly on SAP HCI. The solution downloads currency rates from FX rate providers, maps to an IDoc format and sends them to SAP Business Suite (e.g. ERP).