Talend server architecture

Highlighted
One Star

Talend server architecture

Hello,
Searching for the best solution to migrate and transform datas from an Oracle database to a sybase database. (Not a one shoot integration, but a regular one). I am strongly looking at talend solution.
My question should be trivial, but even if the Talend open studio looks like fully covering our needs, I really don't understand how the construction of an integration is load (migrated ? saved ? build ?) on servers that will finally running the intégration. How the generation worked ? Are there libraries, binaries or others things to install on unix/linux servers ?
Could you please expose it in severals words how did it works ?
Thanks in advance
Regards
Employee

Re: Talend server architecture

Talend Open Studio has a "Job design" module. This graphical module let you design the job that will migrate your data from Oracle to Sybase. Once designed, the job is translated to a Perl script. This Perl script can be run from Talend Open Studio but can also be sent to another computer, not running Talend Open Studio but where Perl is installed, of course.
Depending on the components you've selected for your job, the Perl script might require some external Perl modules. For example, if you want to read/write in databases, you'll need the "DBI" perl module.
One Star

Re: Talend server architecture

With a really simple test, is generated several perl file :
21/11/2006 16:07 205 .includepath
21/11/2006 13:53 260 .project
21/11/2006 16:07 9ÿ300 TEST.process_MyFirstJob.pl
21/11/2006 16:07 8 TEST.process_MyFirstJob_Default.pl
21/11/2006 13:53 0 TEST.process__PP0qQHlfEduNaacAYM-SzA.pl
21/11/2006 16:16 0 test.txt
21/11/2006 16:07 4ÿ900 TEST__Routines.pm
Now, I would like to run this program on another PC or rather unly using perl without talend this time.
C:\TOS-Win32-20061004-1934-V1\workspace\.Perl>perl TEST.process_MyFirstJob.pl
Can't locate talend/dbOp.pm in @INC (@INC contains: c:/Perl/site/lib c:/Perl/lib .) at TEST.process_MyFirstJob.pl line 134.
BEGIN failed--compilation aborted at TEST.process_MyFirstJob.pl line 134.
WHy doesn't this correctly run ?
This is really my goal to do that, no intégration will work with talend, only the generated code

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download