Monday 15 August 2016

Setting a Batch Job in Talend

We can set a batch job using a Task scheduler provided by windows.
To do this we need to follow the following steps:

  1. Go to Talend->Job Designs and right click on the job you want to run as a batch job.
  2. Click 'Build Job' and check the button which says zip file.
  3. Follow the wizard and put the job in a location of your preference.
  4. Now go to the location where you put this job and go inside the folders.
  5. Go to the 'JobName.bat' file. 
  6. Choose that file location with the job name and copy it.
  7. Now search in windows for 'Task Scheduler'
  8. Create a new task from the window on the right. 
  9. Under 'Actions' choose the location of the job. If you copied the location as mentioned above, just paste it. 
  10. Choose the other preferences like triggers and schedule the time of the jobs and save it. 
Congratulations! Now you have successfully created an Automated Batch job running on Talend.

Talend 6.2 Metadata issue

I was trying to create a job on Talend. I downloaded the new version, 6.2 from their site and started the build. I was trying to build a job having SQL Server as a source and Salesforce as a target.
I found a bug in their software while trying to pull the target metadata.

  • On the salesforce component we need to choose 'create Salesforce' option
  • This will lead us to the screen to give the salesforce credentials and the type of connection you have setup. After providing those details, we click 'test connection' to check if the credentials are valid. Only then will Talend allow you to proceed by clicking 'Next'.
  • On validation I realized that there was a bug and the Salesforce objects are not visible. It says new schema in current connection but does not show anything. This is a change in UI from Talend 6.1 and has a bug. 
  • If you are facing a similar issue, I would suggest, you use a stable version such as Talend 6.1 for the time being till the Talend team resolves the issue.
Hope this helped. Cheers! Please leave your comments/suggestions below.