tFBSL routine for Talend by Gérôme GUILLEMIN

Created with the Freeware Edition of HelpNDoc: Easily create CHM Help documents

tFBSL routine for Talend This document was written by Gérôme GUILLEMIN aka the FBSL (FreeStyle Basic Script Language) author. For more information please have a look at the official FBSL's Wiki page.

Welcome to the the tFBSL routine code for Talend 3.x series ! This manual will explain to you how to install and use the tFBSL routine for Talend software.

BTW, what does FBSL for Talend? Talend is a great ELT software,that runs under Java platform, but unfortunately we can not make graphical plugins easily, nor windows, nor dialogs on the fly with it! People that are familiar with Windows environment are always using their mouse and click onto graphical widgets to interact with this operating system, that seems quite natural. But if you are familiar with Windows and fond of Talend, you've probably been noticed that no widget tool is actually provided for developing nice and sweet graphical interfaces! So, my programming language project called FBSL (development started in 2001) has evolved since years and is capable of interpreting and creating powerful and complex graphical user interfaces with ease by the way of one of its two engine, and FBSL.DLL is the one that we'll use via Talend / Java class! Are you ready? Ok let's go!

At first you have to download JNA (Java Native Access) here. JNA provides Java programs easy access to native shared libraries (DLLs on Windows) without writing anything but Java code—no JNI or native code is required. This functionality is comparable to Windows' Platform/Invoke and Python's ctypes. Access is dynamic at runtime without code generation. JNA allows you to call directly into native functions using natural Java method invocation. The Java call looks just like it does in native code. Most calls require no special handling or configuration; no boilerplate or generated code is required. The JNA library uses a small native library stub to dynamically invoke native code. The developer uses a Java interface to describe functions and structures in the target native library. This makes it quite easy to take advantage of native platform features without incurring the high overhead of configuring and building JNI code for multiple platforms.

Then you have to download the FBSL library engine aka FBSL.DLL. For more information regarding the FBSL license file, please read it carefully here.

If you want to get at once the whole things that is to say JNA.JAR + FBSL.DLL then click here.

Once you've downloaded both files, then put them onto your \lib\java directory.

Now you've got the two libraries, you have to get the Java code to be able to run FBSL scripts into

Created with the Freeware Edition of HelpNDoc: Easily create CHM Help documents

your TOS/TIS. You can get the tFBSL.java code here and once downloaded, just open the Code\Routines panel and right click to add a newest routine named tFBSL (see the capture below).

Now to the last step : interaction between Talend/Java and FBSL! Please go the the Job Designs panel and create a newest job called tFBSL_Test, then from the TOS/TIS Palette add two components onto your newest job : a tJava and a tMsgBox. - Double click onto the tJava component and add the following code : String FBSLCode = "\n Center(Me)" + "\n Show(Me)" + "\n Begin Events" + "\n End Events" + "\n Return Base64_Decode(\"UGxlYXNlIHZpc2l0IGh0dHA6Ly93d3cuZmJzbC5uZXQ=\") "; globalMap.put("tJava_1_ERROR_MESSAGE", routines.tFBSL.tExecuteCode(FBSLCode) ); - Double click onto the tMsgBox1 component and add the following code : ((String)globalMap.get("tJava_1_ERROR_MESSAGE")) Save the job, click onto Run Job and then tadaaaa!!! FBSL's code is running onto your PC, creates a graphical interface under Talend!!! Now it's up to you to develop easy and nice interfaces to interact with TOS/TIS and the fruit of your imagination!

Created with the Freeware Edition of HelpNDoc: Easily create CHM Help documents

And here's the result :

If you want to get more about FBSL graphical user interface creation, you can get free online tutorials : - Bob Miller's excellent FBSL GUI tutorials here.

Created with the Freeware Edition of HelpNDoc: Easily create CHM Help documents

- FBSL's official tutorial PDF here. Enjoy Talend and FBSL under Windows! Gérôme GUILLEMIN and the (c.)2001-2009 FBSL Team.

Created with the Freeware Edition of HelpNDoc: Easily create CHM Help documents

FBSL License and Copyright FBSL LICENSE AND COPYRIGHT READ THE FOLLOWING TERMS AND CONDITIONS CAREFULLY. USING THE PROGRAM SHALL BE DEEMED AS ACCEPTANCE OF THESE TERMS AND CONDITIONS. IF YOU DO NOT AGREE WITH THESE TERMS AND CONDITIONS, DELETE ALL COPIES OF THE PROGRAM IN YOUR POSSESSION. The FREESTYLE BASIC SCRIPT LANGUAGE ( FBSL ) is the copyrighted property of Gerome GUILLEMIN. Gerome GUILLEMIN grants you a non-exclusive license to use the program. You may not modify, decompile, disassemble or create derivative works based upon the program. Unaltered copies of the program may be distributed without requiring a distribution agreement or royalty fees provided that the program is distributed without charge or profit. The program is distributed as FREEWARE and DOES require license fees for use or distribution for Companies or if you make commercial programs using FBSL. The license must be applied for by contacting the author -- Gerome GUILLEMIN [ mailto : [email protected] ]. FBSL is free of charge ONLY when used for PERSONAL purposes! THIS PROGRAM IS LICENSED AS IS WITHOUT WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL Gerome GUILLEMIN BE LIABLE FOR ANY DAMAGES, INCLUDING BUT NOT LIMITED TO, LOST PROFITS, DAMAGE TO COMPUTER HARDWARE OR SOFTWARE, LOSS OF DATA OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM EVEN IF Gerome GUILLEMIN OR HIS EMPLOYEES HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. BECAUSE SOME STATES DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES OR THE LIMITATIONS OF EXCLUSION OF LIABILITY FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES, THE ABOVE LIMITATIONS OR EXCLUSIONS MAY NOT APPLY TO YOU. YOU AGREE THAT THE LIABILITY OF Gerome GUILLEMIN ARISING OUT OF ANY LEGAL CLAIMS SHALL NOT EXCEED THE AMOUNT PAYED FOR THE PROGRAM. Thanks a lot for all your attention, Gerome GUILLEMIN, Mehdi BOUAZIZ and Mike LOBANOVSKY.

Created with the Freeware Edition of HelpNDoc: Easily create CHM Help documents