SAP connections ECC6, S/4 HANA, and HANA Public Cloud

#1

Hi Morphers

Can Easymorph connect to all SAP instances, download and upload data to the databases?

My company is looking to move away from Alteryx but this is a crucial hurdle in our decision to do so.

Any help would be appreciated.

#2

Hi Jeff and welcome to the Community!

EasyMorph supports the SAP HANA SQL dialect in the generic ODBC connector. You can test it by downloading the free edition from our website: EasyMorph | Download free ETL tool. The configuration is as follows:

  1. Install SAP HANA 64-bit ODBC driver for Windows
  2. Configure the ODBC connection in Windows
  3. Open EasyMorph and create a generic ODBC connector, select the ODBC connection configured above.

If something doesn’t work as expected, let me know.

#3

Okay, so Easymorph does not support ECC6 and IDOC upload of data… Does Easymorph know of a third party connector which integrates with Easymorph that can handle these requirements?

#4

That’s correct, ECC6 or IDOC are not natively supported by EasyMorph.

Typically, when a specific data format/connector is not natively supported by EasyMorph there are two generic ways how to handle this:

Use a 3-rd party command-line utility

Use the “Run program” action in EasyMorph to trigger a 3rd party command-line utility (or script) that performs the necessary integration. For instance, when you export data from EasyMorph you can export it into a file format supported by the utility (e.g. CSV) and then call (run) the utility that would export the file into the target application. A typical workflow would look like this:

image

In a similar fashion, you can import data into EasyMorph from unsupported formats using 3rd party command-line tools:

image

Use a web API

EasyMorph has very good support for web APIs. If the target application has a web API that accepts JSON data, then it can be used in an EasyMorph workflow to push data into the target application.

See also our tutorial article on web requests: EasyMorph | Web requests

I’m not familiar with ECC6 or IDOC, but if there are 3rd party command-line tools or web APIs that can handle ECC6 or IDOC using them with EasyMorph should be feasible.