Skip to main content

Centralizing SAP metadata

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.

Information noteNote: 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.


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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!