topic Re: tSAPHanaConnection Component in Talend Studio

tSAPHanaConnection Component

SBakshi1609745231 — Mon, 04 Jan 2021 09:16:41 GMT

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.

Re: tSAPHanaConnection Component

Anonymous — Tue, 05 Jan 2021 05:21:56 GMT

Hello,

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

Best regards

Sabrina

Re: tSAPHanaConnection Component

SBakshi1609745231 — Thu, 07 Jan 2021 04:46:07 GMT

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

Re: tSAPHanaConnection Component

Prakhar1 — Thu, 07 Jan 2021 06:36:47 GMT

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

Re: tSAPHanaConnection Component

SBakshi1609745231 — Thu, 07 Jan 2021 07:14:47 GMT

Hi @prakhar dubey

Thanks for the explanation.

Are there any other dependency which needs to be installed ?

Re: tSAPHanaConnection Component

Prakhar1 — Thu, 07 Jan 2021 07:31:17 GMT

@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.

Re: tSAPHanaConnection Component

Anonymous — Thu, 07 Jan 2021 09:02:42 GMT

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

Re: tSAPHanaConnection Component

SBakshi1609745231 — Thu, 07 Jan 2021 10:00:14 GMT

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.

Re: tSAPHanaConnection Component

Prakhar1 — Thu, 07 Jan 2021 12:28:34 GMT

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.

Re: tSAPHanaConnection Component

SBakshi1609745231 — Thu, 07 Jan 2021 16:09:45 GMT

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?

Re: tSAPHanaConnection Component

Prakhar1 — Fri, 08 Jan 2021 06:16:35 GMT

Hi @Shobhna Bakshi ,

Yes I have created context variables to store the values, you can also hardcode it.

Re: tSAPHanaConnection Component

SBakshi1609745231 — Tue, 12 Jan 2021 06:28:17 GMT

Hi @prakhar dubey ;

Can you please share screenshot on how to configure tSAPHanaInput and explaining it as well.

Thanks in advance.

Re: tSAPHanaConnection Component

Prakhar1 — Tue, 12 Jan 2021 06:52:54 GMT

@Shobhna Bakshi

I have created the SAPConnection using the tSAPHANAConnection component and used it in my job.

in table name field you can write your source table name, it is not mandatory if you are writing a proper sql query which i did.

in the edit schema you can create schema according to the source table.

Thats it.