How to connect to SAP in Talend Studio via an SAProuter

author
Thomas Steinborn
EnrichVersion
6.4
6.3
6.2
6.1
6.0
EnrichProdName
Talend Real-Time Big Data Platform
Talend Data Services Platform
Talend Data Management Platform
task
Data Governance > Third-party systems > Business applications > SAP components
Design and Development > Third-party systems > Business applications > SAP components
Data Quality and Preparation > Third-party systems > Business applications > SAP components
EnrichPlatform
Talend Studio
Talend SAP RFC Server

How to connect to SAP in Talend Studio via an SAProuter

This article details the procedure to connect to SAP via an SAProuter . If you want to set up a standard connection to your SAP system to retrieve a table or a function, refer to the Studio User Guide section: 40.5.2 Retrieving SAP tables.
Environment

This article is valid for all Talend products on subscription from v5.6 upwards.

Procedure

To connect via an SAP router in Talend Studio and the components you will have to use the additional property: jco.client.saprouter .

In your Talend Studio :

  1. In the Repository tree view, expand the Metadata node, right-click the SAP Connections node and select Create SAP connection from the contextual menu. The [SAP Connection] wizard opens up.
  2. Fill in the generic properties such as Name , Purpose , and Description .
  3. In step 2 of the connection wizard, fill in the SAP system connection details and add a property entry in the Additional Properties table.
    Property Name Value
    jco.client.saprouter /H/router.company.com/S/3299/W/password/H/

    Replace router.company.com and password with the actual values.

  4. Click Finish .
How to let your Talend SAP RFC Server work with an SAProuter?

Adjust your properties file to include the jco.server.saprouter property. E.g.

# For RFC server only

jco.server.progid=TALEND

jco.server.gwhost==<hostname>

jco.server.gwserv=sapgw00

jco.server.connection_count=2

jco.server.saprouter=/H/router.company.com/S/3299/W/password/H/