Talend Component working with SAP RFC calls to the default function RFC_READ_TABLE
This component established the connection. There are to different ways to connect to SAP (configured with the setting Connection Type):
It can connect directly to the SAP server. This requires the component (and therefore the job must carry the sapjco3.jar library. This library requires the installation of the native library and the path to this lib must be referenced with the environment library JNI_LIBRARY_PATH
This server has the advantage the sapjco3.jar must only by installed (along with the native lib) within this service and not in the amount of jobs. The service is described and published here: https://github.com/jlolling/SAPRFCProxyServer
As URL for the service http://your-server:9999 (assuming the service runs on this port)
Runs the query. The component expects mandatory the name of the table. You can setup a filter. Filter extressions are actually limited by 72 chars. You can configure much longer expressions. To allow the component to cut the expressions in 72 or less pieces you have to add semicolon and the component will cut the expressions here.
Please note the semicolons in the filter expression
If the actual query have fields with / or spaces in such case set the actual database column as database column and rename it for the schema
Note: In case of there are exceptions caused by a missing CFLF. It turns out, a change of the port helps because e.g. the MySQL driver use this port as internal port for communication.