tSAPHanaConnection Component

[SBakshi1609745231]

I need help on how to use the tSAPHanaConnection in Talend Open Studio for Big Data or Talend Data Fabric.

An article or a blog with an exmaple on how to use tSAPHanaConnection will be helpful.

Thanks.

[Anonymous]

Hello,

tSAPHanaConnection component in this framework is available in all Talend products with Big Data and in Talend Data Fabric.

Best regards

Sabrina

[SBakshi1609745231]

Can you please link to some article or a blog where there is an example how the tSAPHANAConnection Component can be used in Talend.

[Prakhar1]

hi @Shobhna Bakshi​ 

I have just describe how to connect to SAP HANA ouptut component, which is similar to create a connection in SAP HANA.

Have a look in below link and can ask some more question if you want.

https://community.talend.com/s/question/0D53p00008MRx3XCAT/how-to-configureload-data-to-sap-s4-hanatsaphanaoutput

[SBakshi1609745231]

Hi @prakhar dubey​ 

Thanks for the explanation.

Are there any other dependency which needs to be installed ?

[Prakhar1]

@Shobhna Bakshi​ 

No just the jar file of the connection component which will be by default installed or when you use the component it will automatically ask to you install, not a big deal.

[Anonymous]

Hello,

Here is online documentation about: TalendHelpCenter: Creating the SAP HANA database connection

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

[SBakshi1609745231]

Hi Prakhar (Customer),

Can you share screenshot and explain how to configure tSAPHANAConnection component as you have done for HANA Target compnent.

Thanks in advance.

[Prakhar1]

Hi @Shobhna Bakshi​ 

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

Port = port of the system (eg. 301101)

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

Additional JDBC = "databaseName=<your_database_name>"

There will be not much problem if you have all these details.

[SBakshi1609745231]

Hi Prakhar;

Are

context.HANA_Port

context.HANA_Host

context.HANA_Schema

context.HANA_Password

context.HANA_User

variables in which the actual values are assigned?