topic Re: How to connect Talend and SAP BW with Talend as datasource? in Talend Studio

How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Wed, 28 Jun 2017 12:29:17 GMT

Hello,

we are currently trying to connect Talend and SAP BW without using a JDBC interface to the underlying Talend database. It's not about bringing SAP BW data to Talend, but the other way round.

Therefore we are looking for a solution that intergrates Talend as a native source system to SAP BW.

Unfortunately I could not find any description for this scenario in the Talend help pages and in this forum.

What I found out is that a component named "tSAPDataSourceOutput" exists and I am able to establish a handshake with my BW system via the sapjco3 Java Connector.
The attempt fails with the following error message:

Exception in component tSAPDataSourceOutput_5
SAPException@5c44c582 [
errorCode=1
,errorGroup=519
,errorKey=JCO_UNKNOWN_GROUP_519
,errorMessage=No data request exists for request number 1
,bapiName=BAPI_DSOURCE_SEND_CHARSTRING
,objectName=TEST_DS_TALEND (TALENDB)
]

Is there anyone who already used the SAP BW connection in this way and has a best practise scenario for that?
And does anybody know how to handle the component "tSAPDataSourceOutput" so that SAP BW can get the data?

Re: How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Mon, 03 Jul 2017 08:30:18 GMT

Hello,

Could you please post your tSAPDataSourceOutput component setting screenshot on forum? Any more error message printed on console?

Best regards

Sabrina

Re: How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Tue, 04 Jul 2017 16:50:53 GMT

Screenshot is attached. USERNAME and HOST are just set for the screenshot.

Would be great if someone can give me a hint.

tsapdatasourceoutput.jpg

Re: How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Wed, 05 Jul 2017 04:00:56 GMT

Hi,

Have you already added the SAP java connector sapjco3.jar in module view?

Best regards

Sabrina

Re: How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Wed, 05 Jul 2017 07:55:34 GMT

Hi,

yes I did. With "I am able to establish a handshake with my BW system via the sapjco3 Java Connector" I already went to the following steps.

- System connection succsessful

- Meta-Data-Sync of DataSource in BW

By the way: The source system in BW was defined as "External System" and I did choose "Registered Server Program" with "Program ID" "TALEND" in the RFC settings. But I did not setup the Talend RFC-Server because it seems like this module is only needed to get data out of SAP and not the other way round.

Re: How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Wed, 05 Jul 2017 09:04:56 GMT

Hi,

What's SAP BW version you are using? SAP BW 7.3? With your subscription solution product, could you please create a case on talend support portal on which we can give you a remote asistance(webex) through support cycle with priority?

Best regards

Sabrina

Re: How to connect Talend and SAP BW with Talend as datasource?

Anonymous — Wed, 05 Jul 2017 11:43:11 GMT

We are using SAP BW 7.4.

The WebEx support would be great. I will create a case.

Best regards,

Michael