Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
Please,
It is possible to scheduling a job using Talend Open Studio for Data Integration ?
I want to read data from Oracle and, if not exists, to insert it in Postgresql. It is possible ?
Thank you !
Valentin
hi @valentinbadea,
as per your scenario... reading data from Oracle and loading it to Postgresql....
Well in talend open studio you can schedule the job..however you would be needing Talend Administrator Center(TAC) where you can scehdule your jobs... this is also known as Job scheduler tool.. but to use this you must have an enterprise edition of the Talend... which is the licensed version and cloud version...
However you can schedule your job in Talend Open studio..but not within the studio... you must use Windows task scheduler for the scheduling the job...
Firstly in the repository tab, go to Job designs and right-click on it...where in you get list of options for job...click on Build Job.. on clicking you get a dialog box where select the job as Standalone Job...the job will get exported as zip format or anythin.. also some add-in information must be included like Job-version,log level,contexts etc stuff.. after that click on finish. The job will be exported as zip format in your desired location after that open Windows Task Scheduler from your start menu and then create a task by scheduling a task...you can create a basic task and add the necessary details of when you would like to schedule your job and click finish..
Pls get back to the community, if in case you need something.
of course
You need build Job - mouse right click "Build"
store zip in specific folder, unzip archive
and than use any of available schedulers:
- windows scheduler
- linux cron
- any other open source or commercial schedulers, like - SOS-Berlin, Schedulix, Airflow, JAMS, etc (any)
any builded job contain .sh, .bat and .pssh files for start same job in target OS.
hi @valentinbadea,
as per your scenario... reading data from Oracle and loading it to Postgresql....
Well in talend open studio you can schedule the job..however you would be needing Talend Administrator Center(TAC) where you can scehdule your jobs... this is also known as Job scheduler tool.. but to use this you must have an enterprise edition of the Talend... which is the licensed version and cloud version...
However you can schedule your job in Talend Open studio..but not within the studio... you must use Windows task scheduler for the scheduling the job...
Firstly in the repository tab, go to Job designs and right-click on it...where in you get list of options for job...click on Build Job.. on clicking you get a dialog box where select the job as Standalone Job...the job will get exported as zip format or anythin.. also some add-in information must be included like Job-version,log level,contexts etc stuff.. after that click on finish. The job will be exported as zip format in your desired location after that open Windows Task Scheduler from your start menu and then create a task by scheduling a task...you can create a basic task and add the necessary details of when you would like to schedule your job and click finish..
Pls get back to the community, if in case you need something.
Thank you all very much !