Can we Decrypt CSV file in Data Services?

[Former Member]

Hello Experts,

I have requirement where I need to decrypt CSV file and load the data in SAP HANA? I am not sure if we can do it Data Services. If yes, then I would like to know how?

Thanks,

Nishith

[Former Member]

Hi Nishith,

How are you encrypting the file in the first place? =>

There must be a utility/tool that does the decrypting on the command line.

If that is the case, give a look into the designer manual (pdf xi4_ds_designer_en.pdf in your Doc directory of your installation)

Chapter:

6.6 File transfers.

You can see: .."use Encryption/decryption mechanisms."

Normally this is a (*.bat or .sh) file you can write to fetch files from remote servers (scp..). As an example there is a ftp transport in the manual, but you should be able to just decrypt a CSV file into the directory and when the .bat script you wrote comes back as success (Return code 0), DS will read the files.

There are a few variables that can be assigned in the job ($AW_USER, $AW_PASSWD...) that you can pass as argument to the file you are invoking and then use as an variable inside that file.

Regards

Norbert