Centralizing SAP metadata - 8.0

Talend Data Integration Studio User Guide

Version
8.0
Language
English (United States)
EnrichDitaval
Data Integration
Product
Talend Data Integration
Module
Talend Studio
Content
Design and Development

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.

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

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