Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


SAP Connection/Table Metadata Wizard


  • Author: tfoldi
  • Categories: Java
  • First revision date: 2012-01-15
  • Latest revision date: 2013-05-16
  • Compatible with: Data Integration releases 4.2.3, 5.0.1, 5.0.2, 5.1.1, 5.1.2, 5.2.0, 5.2.2, 5.3.0
  • Downloads: 870

About: This Talend plug-in completes the Talend Open Studio with the SAP Connection and SAP Table wizards, allowing smooth metadata handling for SAP Tables. The plug-in also contains the required components to download tables from SAP by RFC_READ_TABLE or PLSAP Connector\'s RFCs.

Related links

Revision list

expand/collapse all

Revision 5_3_0 19 Downloads, Released on 2013-05-16
Download revision 5_3_0

Compatible with: 5.3.0

Release for Talend DI 5.3.0

Revision 5_2_2 2 Downloads, Released on 2013-05-16
Download revision 5_2_2

Compatible with: 5.2.2

Support release for Talend DI 5.2.2

Revision 5_2_0_r75 105 Downloads, Released on 2012-11-22
Download revision 5_2_0_r75

Compatible with: 5.2.0

Support release for Talend DI 5.2.0

Revision 5_1_2_r74 33 Downloads, Released on 2012-11-15
Download revision 5_1_2_r74

Compatible with: 5.1.2

SAP Connection Wizard and PL/SAP components for Talend Open Studio 5.1.2

Revision 5_1_1_r69 225 Downloads, Released on 2012-07-16
Download revision 5_1_1_r69

Compatible with: 5.1.1

Support release for Talend DI V5.1.1

Revision 5_0_2_r66 267 Downloads, Released on 2012-03-09
Download revision 5_0_2_r66

Compatible with: 5.0.2

PLSAP for Talend Open Studio 5.0.2. Fixed bug when the user retrieve the SAP Table twice, and handling of the complex where statements. Also supports ignore all errors on SAP side option.

Video on usage: http://www.youtube.com/watch?v=ucT_XXHmi0E

Revision 5_0_1_r63 118 Downloads, Released on 2012-01-15
Download revision 5_0_1_r63

Compatible with: 5.0.1

Installer for Talend Open Studio DI 5.0.1, ALL platforms. Simply unzip into your Talend installation directory.

Revision 4_2_3_r63 101 Downloads, Released on 2012-01-15
Download revision 4_2_3_r63

Compatible with: 4.2.3

Installer for Talend Open Studio 4.2.3, ALL platforms. Simply unzip into your Talend installation directory.

Reviews (8)

 RE: datafile.jar missing By tfoldi on March 19, 2013
The datafile.jar is included in the zip, if you followed the install instructions it should be loaded by talend. If you still have that problem please send me a mail to tfoldi at starschema . net.
Was this review helpful to you? Yes No Report
 Module datafile.jar required By Bob on March 8, 2013
After successfully setting up a connection to SAP, I get a \"Module datafile.jar required\" error on my job (tPLSAPSimpleInput). I tried to download it via Talend modules window but it did not give me anything.
Any idea what is wrong ?
Was this review helpful to you? Yes No Report
 Free version By tfoldi on November 22, 2012
Dear Hans Hack,

This plugin works pretty well without the server side ABAPs, with the same RFC_READ_TABLE which can be found on every SAP system. So your argument is invalid, it is used by many people in production.

Regards
Tamas
Was this review helpful to you? Yes No Report
 Mr. By Hans Hack on November 22, 2012
This component needs additional SAP ABAP RFC Functions which has to be bought in addition and has noting to do with this community.
Further this wizard would not work with a subscription based enterprise version!
Was this review helpful to you? Yes No Report
 Thanks By Fitsch on June 28, 2012
Hey,

thank you so much for providing us with this useful tool.
The only thing is that you might inform us that we need the sapjco3.jar Connector from SAP.
Was this review helpful to you? Yes No Report
 SAP Certification By tfoldi on May 7, 2012
First of all, this version also works with RFC_READ_TABLE with is SAP's default data access program.

Second, the PLSAP does not use *external ABAP* program, instead, it uses a small RFC BAPI (100 lines of code, source included) for data transportation. Also, it has been code reviewed many times.

The connector only uses licensed features, approved by SAP. So it does not broke your support contracts.
Was this review helpful to you? Yes No Report
 What about my SAP support? By bob23 on May 7, 2012
Don\'t get me wrong but If I understand correctly your web site, your PLSAP provides *external ABAP* routines and these ABAP Routines have not been certified by SAP.

Normally, if somebody delivers external ABAP Routines this has to be certified from SAP if you want continue to get your SAP support in place...
Was this review helpful to you? Yes No Report
 Mr By Kumarbabu on January 24, 2012
Hi,

It's very nice concept, we can reduce the download time alot....

Gud Idea.. Congrates..

Thanks,
Kumarbabu.
Was this review helpful to you? Yes No Report
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Regex

Unaccented Words

 1.0 scorreia 2013-01-30
13

match words without accent.
matches \"hello guys\" \"Jean-Jacques\"
does not match \"télévision\" \"Jean -Paul\"

Regex

Words

 1.0 scorreia 2013-01-30
13

match words.
matches \"hello guys\" \"Jean-Jacques\" \"télévision\"
does not match \"Jean -Paul\" \"hi !\" \"hello, mom\"

Regex

Text

 1.0 scorreia 2013-01-30
21

match regular text with punctuation correctly placed.

Regex

Correctly Encoded Characters

 1.0 scorreia 2013-01-30
37

Finds out any badly encoded character

Regex

Extract or Validate an Email Address

 1.0 Mbaroudi 2013-01-28
73

Find or Validate an Email AddressThis regular expression, I claim, matches any email address. Most of the feedback I get refutes that claim by showing one email address that this regex doesn\'t match. Usually, the \"bug\" report also includes a suggestion to make the regex \"perfect\".

Regex

Repeated Character

 1.1.1 scorreia
sizhaoliu 		2013-01-02
303

will find data such as "aaa"

SQL

Email (test only)

 1.0 sizhaoliu 2012-12-17
47

General SQL pattern for Email

Regex

Regular Text

 1.0 scorreia 2012-12-11
39

match regular text

matches regular text such as \"hello Jean-Baptiste\".
does not match text with any special character such as \"# num\", \"test;\"

Indicator

BenfordLawFrequencyIndicator

 1.3 mzhao 2012-10-15
78

This Class provide the function to compute a group of data by Benford\'s Law and output the leading
digits with its distribution in this dataset. Then the user can use it to compare with the standard, to detect
possible cases of Fraud.

Indicator

UDI_Count

 0.2 xqliu 2012-09-25
227

TEST User Defined Count

Version Author Released on Rating Downloads
Export

DStar

 1.0 ctoum 2010-08-04
1096

D* Industries Demo Model


50 ms