Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend Open Studio for Data Integration scheduling

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 

Labels (2)
1 Solution

Accepted Solutions
ankit7359
Creator II
Creator II

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.

View solution in original post

3 Replies
vapukov
Master II
Master II

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.

ankit7359
Creator II
Creator II

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.

Anonymous
Not applicable
Author

Thank you all very much !