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

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 78 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 9 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 108 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 36 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 228 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 270 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 119 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 103 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

Only alphabetical characters not empty

 1.0 dcortinovis 2013-06-19
1

Only alphabetical characters not empty.
And at least one (empty forbidden)

Indicator

EMail validation via mail server

 5.3.0 mzhao 2013-06-03
190

This Java UDI check emails by sending a SMTP request to mail server. the code sample can be found at: http://www.rgagnon.com/javadetails/java-0452.html

Indicator

Frequency table of hours

 2.0 scorreia 2013-04-25
277

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
195

This indicator computes the sample standard deviation of any numerical column

Indicator

Variance

 1.1 scorreia 2013-04-25
182

This indicator computes the variance of numeric columns

Indicator

Trimmed

 1.0 scorreia 2013-04-25
17

evaluate the number of data which are correctly trimmed

Indicator

Week Frequency

 2.0 scorreia 2013-04-25
173

aggregates Date fields into weeks

Indicator

Duplicate Rows

 2.0 scorreia 2013-04-25
599

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
48

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
58

measure the order of magnitude of numerical data

Version Author Released on Rating Downloads
Export

Product Demo

 3.0 ctoum 2012-05-31
433

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

 1.0 jaymce 2010-11-22
288

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm
Data-Model

D* Demo Model

 1.0 ctoum 2010-08-13
516

Model used in the D* Demo.

Export

Talendshop Demo

 1.0 ctoum 2010-08-04
1066

Talendshop Demo (Demo Project)


54 ms