Showing posts with label ETL. Show all posts
Showing posts with label ETL. Show all posts

Monday, 31 July 2017

Talend Build Failure issue. Talend 5.6 and 6.1.2 x86 versions

An error occurred (job was not built successfully please check logs for more details available on the workspace/ .java /last generated.log)




Whenever this issue happens, do not panic. As the jobs should run fine but just the build will not work.
Do a java - version in CMD. If it has a single version and does not throw an error then you are good to go.
All you have to do is go to the talend site and download the newer version of talend and run the build again and it should work. This however, does not always happen. As you may know Talend can be buggy and times with no reasoning whatsoever.
Solution:
I downloaded v 6.2.2 and imported the talend jobs and it worked smooth.

Thursday, 23 February 2017

Magic of CliQ Data Loader

CliQ is a software hosted on google code Archive. It can be found at
https://code.google.com/archive/p/dataloadercliq/downloads

This is really helpful for loading and extracting data from salesforce. We can use this to load data from and to a staging table in an ETL tool. I use this in Talend as this helps in error logging which is not available with the standard salesforce component.

There is a dependency on Data Loader provided by salesforce for this.
Currently you need Apex Data Loader 36+ for Cliq 2.3 which is the last available version.
Its better not to use an older version as this is TLS 1.1 compatible which will be the standard in salesforce production orgs from next month.