You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2006-11-21 10:01:33

Paf
Guest

Paf said:

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

#2 2006-11-21 12:28:14

plegall
Talend Team


plegall said:

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.

Offline

#3 2006-11-21 16:19:00

Paf
Guest

Paf said:

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

#4 2006-11-26 23:47:26

ccarbone
Member
1223 posts

ccarbone said:

Re: Talend server architecture

Paf wrote:

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.

Hi Paf,

I will answer to your tuesday post, sorry for the delay!
dbOp.pm is a T.O.S. Perl modules. It handles common operations on Database.
To avoid problem when you want to deploy your talend jobs, don't forget to copy T.O.S. module directory.
This directory is located at 
"<T.O.S. directory>/plugins/org.talend.designer.codegen.perlmodule_1.0.0.20061004-2013-V1/perl"

Paf wrote:

Now, I would like to run this program in a other PC or rather unly using perl without talend this time.

For more explanations about all the files you need to deploy, please see https://www.talendforge.org/forum/viewtopic.php?id=33


Regards,
Cedric Carbone
Talend CTO
https://twitter.com/carbone

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy