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: 860

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 11 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 1 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 266 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.
 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 ?
 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
 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!
 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.
 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.
 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...
 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.
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Indicator

Frequency table of hours

2.0 scorreia 2013-04-25
270

This indicator helps to analyze the most frequent day hours that appear in date time columns.

Indicator

Sample Standard Deviation

1.1 scorreia 2013-04-25
185

This indicator computes the sample standard deviation of any numerical column

Indicator

Variance

1.1 scorreia 2013-04-25
176

This indicator computes the variance of numeric columns

Indicator

Trimmed

1.0 scorreia 2013-04-25
6

evaluate the number of data which are correctly trimmed

Indicator

Week Frequency

2.0 scorreia 2013-04-25
168

aggregates Date fields into weeks

Indicator

Duplicate Rows

2.0 scorreia 2013-04-25
567

this indicator counts the number of duplicate rows.
It's different from the system indicator called "duplicate count" because it counts the number of duplicate rows, not the number of duplicate values.

Indicator

Length Range Frequency

1.1 scorreia 2013-04-25
38

get length ranges of data.

group data according to their length range.
Ranges are the following:
data of length < 10
data of length < 20
data of length < 30
data of length >= 30
null data

Indicator

Order of Magnitude

1.1 scorreia 2013-04-25
49

measure the order of magnitude of numerical data

Indicator

phone_area_code_freq

1.0 scorreia 2013-04-24
4

Area codes of American phone numbers

Indicator

udi_average_yearly_income

1.0 scorreia 2013-04-24
3

parses $50K - $70K and return the average value

Version Author Released on Rating Downloads
Export

DStar

1.0 ctoum 2010-08-04
1096

D* Industries Demo Model


51 ms