whint://Solutions now in SAP HCI Content Catalog

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 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).

WHINT CurrencyRates (Cloud Edition)

SAP_ICC_Cloud

This Integration Package for SAP HANA Cloud Integration (HCI) 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.

CR_C5

CR_C7


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP HANA Cloud Integration (HCI)
  • SAP Cloud Certified Integration Package
  • Mapping, Connectivity and Interface Processing just needs to be activated with a few steps
  • Safe and secure connectivity fully integrated in SAP´s cloud middleware – connecting to your On-Premise SAP world
  • 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
    • Blockchain.info Exchange Rates API: Currency data from the major bitcoin exchanges

Prerequisites

  • You need an existing HCI tenant from SAP where you can deploy our content. Please contact us in case you haven´t any.
  • The data from ECB is available publicly, but for other providers you might need a subscription (e.g. with OANDA)
  • You need a connectivity from SAP HCI to your On-Premise SAP system. This can be achieved e.g. with an inbound proxy like the SAP Web Dispatcher or using SAP HANA Cloud Connector. We support you getting there if needed.

Configuration Guide: HCI

  1. Import Integration Package into your HCI tenant
  2. Configure Integration Package

CR_C6

  • Select the scheduling according to your needs, e.g. daily at 10 PM.
  • 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 keystore which has to be deployed.

CR_C9


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

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. 


Hybrid Integration / OnPremise & Cloud Connectivity

Now, in 2015, I believe in 2 major future trends becoming reality in the next 10 years:

  • Cars will be mainly electric
  • Software will be mainly running in the cloud (outside of companies own data centers)

To get there, it will be sometimes by selling your beloved Diesel-Car and buying a Tesla. This is a really big change as the infrastructure for chargers is not as good as with classic gas-stations. So doing this in Germany/Europe means you are an early adopter and sacrifice some luxury to be innovative.

Same applies for software managed in the cloud. No company is interested in driving projects to replace their existing IT systems running in a server room / data center and let them be hosted and managed by another company… Also, the question of hosting your current IT landscape at some provider does not provide the benefits you might be looking for. You still have to buy the license, and decide which hardware/database you might want to use. If you are lucky, updates will be managed by the hosting provider, but thats usually it.

But the future is clear: You pay for your software subscription-based, it is very up-to date (no headache about release changes and versioning), it is fully scalable, you do not worry about hardware, security and so on….

To get there over the time, a pragmatic approach could be to replace your “old” applications by looking for a cloud alternative. Instead installing a new release and/or migrating to a newer version, you make the paradigm change into cloud step by step.

Of course there will be questions about security, availability, performance, SLAs, change management and support, but that´s why you have an IT-department. They should be working those things out (with some help of good partners).


So instead replacing everything in one shot, a hybrid model seems to be first choice: some applications are running on premise, and some are running (already) in the cloud. I guess this concept also applies to cars for the time being. Plug-In hybrid cars offer a good mix of gas-station infrastructure and pointing to the right direction with electric-only driving modes.


The next question will then be: How can I INTEGRATE my on-premise with my cloud applications in a smart way?

  • Option 1:  You have a (on premise) middleware already (SAP PI/PO, Microsoft BizTalk, …)
    This works well if you connect OP (on premise) – OD (on demand/cloud)
  • Option 2: You decide for a cloud middleware
    This does not mean you can get rid of the OP middleware, but if you connect OD – OD it would be bad to go through a OP component (same applies for OP-OP connectivity).
    So you keep your OD middleware and enhance it with a CLOUD (OD) middleware.

For SAP customers using SAP NetWeaver PI or PO (PRO), it seems logical to use SAP HANA Cloud Integration (HCI) as the concepts are quite similar (although more flexible) and OP mappings can be reused… Moreover, there will be a hybrid option in the future where runtime elements from HCI will be running on your PRO installation in runtime containers.

If you do not want to narrow your possibilities to one single platform, you can be quite relaxed. There are many great solutions out there, including Dell Boomi or elastic.io, so the reality might be to integrate through multiple cloud middleware solutions, depending on what they are able to provide (existing content for plug-and-play connectivity) or based on the business app you want to integrate.

WHINT Webhook JSON Connector

WHINT_WJC

Functionality

This solution enables you to push data via an ABAP structure to a Webhook using JSON.

Prerequisites

  • Works with any SAP ABAP Based system (Basis 6.10 and higher)
  • You install the Whitepaper InterfaceDesign ABAP components through a transport
  • The software comes in an isolated, namespace-specific environment that basically provides one function group and a sample report to show the usage

Usage

  • You pass the data to be transferred from any context
    • BAdI (Business Add-In)
    • User-Exit (CMOD)
    • BTE (Business Transaction Event)
    • BOR Event
    • Enhancement Spot
    • Customer-specific ABAP program
  • to a function module:  /WHINT/WJC_ABAP2JSON

Example

You want to add subscribers from your SAP CRM system to your MailChimp E-Mail distribution list.

See our blog entry: “SAP integration with Webhooks and JSON through elastic.io

SAP integration with Webhooks and JSON through elastic.io

WHINT_WJC_elastic

This article shows how to integrate any SAP ABAP system with MailChimp through elastic.io using a solution of Whitepaper InterfaceDesign, the WHINT Webhook JSON Connector.


elastic

Our Partner elastic.io is an iPaaS (Integration Platform as a Service), a cloud connectivity solution to enable business integration between on-premise and on-demand applications. The platform is hosted in Germany´s most secure cloud environment and fulfills highest security standards.

MailChimp is a cloud solution to send marketing emails, automated messages, and targeted campaigns.

Whitepaper InterfaceDesign provides professional services and software solutions around SAP integration and cloud connectivity. We are a SAP Application Development Partner since 2014.

SAP Partner


Step-by-step guide: Prerequisites

  1. Install the add-on into your SAP ABAP system
  2. Create an account at elastic.io
  3. Create an account at MailChimp
  • No additional middleware needed (!)

Configure MailChimp

  • Create a list

MailChimp Create List


Configure elastic.io (1)

  • Add new flow
  • Save Webhook URL

elastic 1 elastic 2


Configure SAP

  • Configure the connectivity
  • Select the data structure to be sent
  • Retrieve the JSON structure by invoking the WHINT WJC (Webhook JSON Connector)

Transaction SM59: Create an RFC destination (HTTP) and select SSL

sap 1 sap 2

Transaction STRUST: Load the SSL certificates (CAs) needed for the HTTPS connection

sap 3

Transaction SE11: Select or create a DDIC structure to pass the information to MailChimp

sap 4

Transaction SE38: Create program that invokes the WHINT WJC and run:

sap 5 sap 7


Configure elastic.io (2)

  • Insert JSON String into Webhook sample
  • Define field mapping
  • Connect your MailChimp account

elastic 3

elastic 4

elastic 5

Start the flow!


Monitoring & Results

  • SAP
  • elastic.io
  • MailChimp

sap 8

Monitoring on elastic.io:

elastic 7 elastic 8

Verify result in MailChimp:

mailchimp list 2 mailchimp list 3

SAP Landscape of Whitepaper InterfaceDesign running on Microsoft Azure Cloud

Thanks to Microsoft and especially our friend and partner Michael Havemester, our first SAP development systems are now up and running:

  • SAP NetWeaver PO 7.4 SP9 with B2B add-on and IGW (Integration Gateway) on D11 instance
  • SAP Solution Manager 7.1 SP on D12 instance

WPO

WSM