Centralizing SAP metadata - 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
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 schema.
  • Retrieve the metadata of the SAP BW Advanced Data Store Object, Data Source, Data Store Object, InfoCube, or InfoObject objects.
  • Create a file from SAP IDoc.

This feature is not shipped with Talend Studio by default. You need to install it using the Feature Manager. For more information, see Installing features using the Feature Manager.

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 Talend Studio.

For Windows 64-bit:

  1. Copy the sapjco3.dll file that comes 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.