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

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.

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.

In this section

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 – please let us know!

Leave your feedback here