Connecting to SAP in Talend Studio via an SAProuter - Cloud - 8.0

SAP

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > SAP components
Data Quality and Preparation > Third-party systems > Business applications > SAP components
Design and Development > Third-party systems > Business applications > SAP components
Last publication date
2024-03-28
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, see Retrieving data from SAP tables using a dynamic schema.
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 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.
    SAP Connection metadata wizard opened.
    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/