Sunday, 27 March 2016

A first attempt at using HANA Cloud Integration to integrate Workday and Salesforce

Starting to do some research on this idea, I ran across an article about a recent agreement between Workday and Salesforce:
Under a technical agreement and go-to-market strategy, Salesforce and Workday will do the following:
  • Salesforce will standardize on Workday's applications.
  • Workday will standardize on Salesforce's applications and platform.
  • Workday will integrate Salesforce with Workday's human capital management software, financials and big data analytics software.
  • Salesforce will integrate Workday into Chatter and other applications. [SOURCE]
Then, I had an even more amusing thought – “What about a Workday – Salesforce integration”.

Since the Eclipse-based software for HCI is already available, I decided to see how far I could get with my nefarious – no - heretical plan.
Unfortunately, I had a few hurdles to achieve my mischievous plan:
  • I would be unable to actually deploy my integration since I didn’t have access to a real tenant in the HCI cloud environment.
In the operation subsystem preferences (WindowPreferencesSAP HANA Cloud IntegrationOperations Server) specify the URL provided to you by SAP.

This meant that I was just restricted to playing with the design-time environment. The runtime environment / operations views with all the cool monitoring stuff wouldn’t be available.
  • I’m not a domain expert in HCM or CRM or a technical expert in Workday or Salesforce– so my integration probably wouldn’t be optimal.
Integration

Since I saw that both Workday and Salesforce both used SOAP, I started looking for example WSDL files. It turned out to be more difficult than expected but I finally discovered what I needed.  I got the Salesforce WSDL file from an example Java project  and the Workday WSDL file from their public API site. 

Note: I was unable to find publicly available WSDL files for most SAP Cloud applications – it looks like such files are just available for partners.  The one exception is for SuccessFactors where various APIs / WSDL files were found – though I have no idea whether they are still valid or not.

A Caveat for PI Developers / Partners:  Prepare to meet an old friend - Eclipse Tools for HCI appear to be very similar to existing Process Integration Eclipse tools. They could even be the same tools. I’m not a PI expert, so I can’t make that judgment call.  This similarity shouldn’t be a reason for disappointment but rather excitement in that existing PI developers / partners can exploit their previous experience to rapidly use this new cloud-based technology.

Steps

Note: I’m not going to going to describe all the preliminary steps (project creation, etc)  - you’ll find an excellent description in the HCI Developer documentation.

1. Import both WSDL files into Eclipse

SAP HANA Certifications and Material


2. Build a very simple integration process

SAP HANA Certifications and Material

3. Create a mapping between the two WSDL files

SAP HANA Material and Certifications

SAP HANA Material and Certifications

The WSDL files from each participant were difficult to understand and my mapping between the two WSDL files was valid but not correct in terms of actual / functional associations.

Caveat: I’m obviously missing tons of functionality such as authentication, etc

4. Deploy to the new integration to my tenant in the cloud

A first attempt at using HANA Cloud Integration to integrate Workday and Salesforce

Full stop – without a valid tenant I can’t deploy anything. My initial attempt would have failed miserably in the runtime if I had actually tried to start it but with more work, accounts on Workday and Salesforce, etc, I'm sure that eventually it would be functional.

Source: scn.sap.com