HCI For Data Services: Possibility of using SFTP

[former_member70798]

Hello,

Is it possible to transfer csv\xml files from\to SFTP using HCI-4DS? For example: 1) SOAP WS -> SFTP 2) SFTP -> HANA Cloud DB

Thanks!

[vicky20691 · Accepted solution]

Hi Sergey Gryjin,

1. SFTP to Hana Cloud DB is possible as it will be a data migration.

2. In HCI DS , you have an option of doing WEB SERVICE loookup but you cant do a SOAP to SFTP.

    If you have to do SOAP to SFTP with HCI then you should use HCI - PI.

Regards,

Vikas

[former_member70798 · Accepted solution]

Hi Vikas,

Can you pls explain in more detail about web service lookup?

[former_member186851 · Accepted solution]

Hello Sergey,

With HCI-DS both the cases should be possible if am not wrong.

But HCI-PI should be better option as these are not migration scenarios.

[vicky20691 · Accepted solution]

HiSergey,

SAP HANA Academy - HCI Data Services: WSDL to HCP Task - YouTube

Please watch the video number 9 and 10 , how they use OneRow transformation with WS transformation in between.

Regaards,

Vikas

[former_member70798 · Accepted solution]

Hi Vikas,

Thanks for link to video.

I have one more question - If I will use HCI-PI, can I transfer data to HANA DB?

[vicky20691 · Accepted solution]

Hi Sergey ,

Yes, you can. Use Odata as the receiver.

Regards,

Vikas