Using Talend components to access SAP tables - 7.0

SAP

EnrichVersion
7.0
EnrichProdName
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend SAP RFC Server
Talend Studio
task
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

This section explains how to use Talend components to access SAP tables.

Talend offers many components which can leverage the RFC functionality. Talend does not support direct communication with SAP tables, it requires the generation of SAP Open SQL.

Procedure

  1. Read the readme.txt file located at TalendInstallDirectory>\studio\plugins\org.talend.libraries.sap_******\resources.
  2. Install the function modules Z_TALEND_READ_TABLE, Z_TALEND_READ_JOIN_BATCH, and Z_TALEND_ODP_EXTRACT_COLUMN.
    This is done by the SAP admin. With Talend Custom RFC Module, the caller can get more than 512B of data, which is the default limitation for the RFC module in SAP.
  3. Set “api.use_talend_z_read_table” to “true” in the SAP Properties for the tSAPTableInput component.
  4. Import the SAP Table metadata into Talend Studio.
    Once the metadata is retrieved, the same metadata can be reused for multiple jobs in the project.