Setting up an SAP connection - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
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
Design and Development
Last publication date
2024-02-29

About this task

This section shows you how to set up a centralized SAP connection using the SAP metadata wizard.

To successfully establish the connection between Talend Studio and SAP, ensure that you have the proper authorization rights to access the SAP systems. For more information, see SAP.

Procedure

  1. In the Repository tree view, expand the Metadata node and check that the SAP Connections node is present. If the SAP Connections node is present, go to the next step. Otherwise:
    • Open the Feature Manager window by selecting Help > Feature Manager.
    • Type sap in the search field, check SAP in the search result section, and click Next.
    • Proceed as prompted to install the SAP module and restart Talend Studio.
    Available features dialog box.
  2. Right-click the SAP Connections node and select Create SAP connection from the contextual menu. The SAP Connection wizard opens up.
    New SAP Connection on repository - Step 1/2 dialog box.
  3. Fill in the generic properties such as Name, Purpose (optional), and Description (optional). The information you fill in the Description field will appear as a tooltip when you move your mouse pointer over the connection.
  4. If needed, set the connection version and status in the Version and Status fields respectively. You can also manage the version and status of a repository item in the Project Settings dialog box. For more information, see Upgrading the version of project items and Status management respectively.
  5. Click Next to fill in the SAP system connection details.
    Update SAP Connection - Step 2/2 dialog box.
    The following table describes the fields listed in the dialog box.
    Property Description
    Client The SAP system client ID.
    Host The name or IP address of the host on which the SAP server is running.
    User and Password The user connection ID and password.
    System Number The SAP system number.
    Language The language of the SAP system.
    Additional Properties Complete this table with the property or properties to be customized if you need to use custom configuration for the SAP system being used.

    For example, if you need to retrieve data from tables with more than 512 bytes per row using this connection later, click the [+] button below the Additional Properties table to add a property api.use_z_talend_read_table and set its value to true. For more information, click Help to open the dialog box that shows the instruction.

    Note that additional properties are optional if you are creating metadata for connecting an SAP Application Server through RFC; however, if you are creating metadata for connecting an SAP Message Server through RFC, the following properties are required and need to be set in this table.
    • jco.client.r3name
    • jco.client.mshost
    • jco.client.group
  6. Click Check to validate the SAP connection details.
  7. Click Next to specify the type of the SAP connection you want to create from the ADSO connection type drop-down list.
    • Select SAP JCO3 to create a connection using SAP JCO3.
    • Select Hana JDBC to create a connection to the SAP HANA database.
    Update SAP Connection - Step 3/3 dialog box.
    Note: The SAP Connection - Update SAP Connection - Step 3/3 dialog box is available only when you have installed the R2021-12 Talend Studio Monthly update or a later one delivered by Talend. For more information, check with your administrator.
  8. Do the following according to your selection in the previous step.
    • If you select HANA JDBC in the previous step and click Next, specify the SAP HANA database connection parameters if you need to retrieve the metadata of Advanced Data Store Objects using this centralized connection later. You can optionally click Check to validate the SAP HANA database connection details.
      Update SAP Connection - Step 3/3 dialog box.
      The following table describes the fields listed in the dialog box.
      Property Description
      Db Host The IP address or hostname of the database.
      Db Port The listening port number of the database.
      Db Schema The table schema name.
      Db Username and Db Password The database user authentication data.
      Db Additional Parameters The additional parameters for connecting the SAP HANA database.
    • Select SAP JCO 3 from the ADSO SAP Connection drop-down list if you want to create the connection using SAP JCO3.
  9. Click Finish to save the settings.

    The newly created SAP connection metadata will be saved under the Metadata > SAP Connections node in the Repository tree view. Now you can drag and drop the SAP connection node onto your Job design workspace as an SAP component, with the connection details automatically filled.

    If you need to further edit an SAP connection, right-click the connection node and select Edit SAP Connection from the contextual menu to open this wizard again and make your modifications.