How to configure/load data to SAP S/4 HANA(tSAPHanaOutput)

[Vadigi]

Hello All,

I have a question regarding the database component tSAPHanaOutput. I have read the reference guide but unfortunately, scenarios or examples are not provided in the document.

I am trying to use SAP HANA as my target component but I could not be able to find any article/example to configure the tSAPHanaOutput component properties. I would really appreciate if anyone can share the example or their experience to proceed further.

Thanks in Advance.

Vadigi

[Anonymous]

@prakhar dubey​ Maybe you could share some experience?

[Prakhar1]

Hi @Pavan Vadigi​ ,

I have attached one screenshot where i configured the tSAPHanaOutput component.

Host = host name of the SAP HANA system you are trying to connect ( eg. abc.host.org)

Port = port of the system (eg. 301101)

Table Schema = Schema name from where your table belongs to.

User and Password = your username and password to connect to the SAP HANA

Table = Table name in which you want to perform your action.

Action = It depends on your requirement, i have to do insert and update so i have selected that option.

Also, if you go to advance setting in this component there is an option for additional jdbc parameter, so add there value of the database name ( for example : databaseName=ABC )

Please let me know in case of more help.