Centralizing SAP metadata - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
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-13

From Talend Studio, you can create a connection to an SAP BW system and an SAP HANA database and store this connection in the Metadata folder in the Repository tree view. Once connected to the SAP system, you can retrieve SAP tables and table schemas, preview data in tables, retrieve SAP Business Content Extractors, retrieve SAP RFC and BAPI functions and their input and output schemas, retrieve the metadata of the SAP BW Advanced Data Store Object, Data Source, Data Store Object, InfoCube or InfoObject objects, or create a file from SAP IDoc.

Note: If you are working in the shared mode for Talend Studio and do not have write permission to the Talend Studio installation folder, you need to add the line jco.destinations.dir=<a_writable_folder_path> in the config.ini file under your configuration folder for the shared mode and restart Talend Studio, for example, jco.destinations.dir=C:/Users/user1/studio/workspace.

Prerequisites:

To use the SAP IDoc connectors and the SAP IDoc wizard, you must install specific jar and dll files provided by SAP and then restart the Studio.

For Windows 64-bit:

  1. Copy the dll files librfc32.dll and sapjcorfc.dll that come with the SAP Java Connector into the folder C:\WINDOWS\system32\ or replace the existing dll files with the new ones.

  2. Install the jar files sapjco.jar, sapjco3.jar and sapidoc3.jar in the Java library of Talend Studio.

For Linux:

  1. Copy the appropriate distribution package (sapjco-linuxintel-x.x.x.tgz or sapjco-linuxintel-x.x.x.tar.Z, where x.x.x is the version of the SAP Java Connector) into an arbitrary directory {sapjco-install-path}.

  2. Go to the installation directory by executing the following command:

    cd {sapjco-install-path}
  3. Extract the archive tar zxvf sapjco-linux*x.x.x.tgz, where x.x.x is the version of the SAP Java Connector.

  4. Add {sapjco-install-path} to the environment variable LD_LIBRARY_PATH by executing the following command:

    export LD_LIBRARY_PATH={sapjco-install-path}
  5. Add {sapjco-install-path}/sapjco.jar in the Java library of Talend Studio.