Free SAP Wizard for Talend Open Studio

[_AnonymousUser]

Our company develops several Talend Open Studio plugins, including this SAP Connection wizard for TOS. The connection wizzard part looks like and behaves like the Integration Studio's SAP Connection wizard but of course it is built on a different code basis. For the table downloading it uses PLSAP Connector's technology, which is approximately 10-20 times faster than calling RFC_READ_TABLE or other BAPIs. However, it is also support RFC_READ_TABLE out of the box.
If someone is interested, the source code is available here (feel free to fork):
https://github.com/starschema/starschema-talend-plugins/
https://github.com/starschema/starschema-talend-plugins/tree/wizard_only-0.1
While the precompiled binaries are available for download on talendforge:
http://www.talendforge.org/exchange/index.php?eid=463&product=tos&action=view (ALL platforms)

To install simply unzip it to TalendOS plugins directory.

[_AnonymousUser]

Some screenshots about the plugin, maybe it is interesting for those, who are working with SAP tables and find Talend Open Studio a bit complicated for this task:
SAP Repository view in Talend Open Studio:

The free SAP Connection wizard:

The SAP Table wizard for generating schema/components for data fetch:

And how the component looks like:

The new version will support:
* Table joins in SAP Side. It means for instance, that you can join any table with , so you can make real incremental jobs.
* Standalone installer for last support talend os versions
If someone is interested, just contact me.

[Anonymous]

Thanks for your component.
i have a question, after installing the plugin in the plugin directory in do not see anything in the Metadata SAP
Did I miss something ?
Thanks
Attached a screen shot.

[_AnonymousUser]

Thanks for your component.
i have a question, after installing the plugin in the plugin directory in do not see anything in the Metadata SAP

The attached binary works only with Talend OS 4.1.xx. What version do you use? I can also upload the jars for TOS v4.2.2 as well, if you'd like to use it

[Anonymous]

Hello,
I will be very interisted in the 4.2.2 jars version.
Many thanks !!!

[Anonymous]

I can also upload the jars for TOS v4.2.2 as well, if you'd like to use it

Hi,
could you please upload the jars as you told before. Thank you very much!
Regards,
Billy

[Anonymous]

Congratulations for the Plugin.
Is anybody able to describe the prerequesits within SAP? Are there any special RFC
or BAPI's needed or does the whole connector works over "RFC_ABAP_INSTALL_AND_RUN"?
If additional functions within SAP are needed could somebody describe where the ABAP
Code is located?
Regards
Martin

[_AnonymousUser]

Sorry for the late response, but I am porting the stuff and the installer to 4.2.3 ... As with the new version we have changed some of the core Talend modules, a full installer will be required to make the plugin install process easier.

Is anybody able to describe the prerequesits within SAP? Are there any special RFC
or BAPI's needed or does the whole connector works over "RFC_ABAP_INSTALL_AND_RUN"?
If additional functions within SAP are needed could somebody describe where the ABAP
Code is located?

For the standard wizards (eg. sap connection wizard) you do not need any RFC, you can use the talend metadata to store connections and drag-and-drop talend tSAPInput/Output components. It is free, and does not have any external dependencies.
For the high performance table downloads (including simple table fetching and SAP side transformations like table joins, CDPOS based change tracking) you will need a copy of the PL/SAP Connector package, which costs around 1000EUR. It contains the required abap codes and install instructions.

[_AnonymousUser]

Where can i download the installer for Talend 4.2? I do not see the link in this post.

[Anonymous]

Hi
I would be very interested if you could send me by email or post here the link to download the Free wizard SAP zip file for version 4.2.3 of Talend Open Studio.
Thnak you for helping me.
yda