Ben Hamilton

How to resolve a Talend Execution failed due to access is denied error

Have Talend Open Studio running on a Windows server, however, when we run a job, it gives an error similar to the below: Execution failed : Failed to generate code. [No .class file created for file org\talend\designer\codegen\translators\processing\TMapMainJava$1.class in C:/Talend/TOS_DI-Win32-r111943-V5.4.1/workspace/.JETEmitters/runtime because of an IOException: C:\Talend\TOS_DI-Win32-r111943-V5.4.1\workspace\.JETEmitters\runtime\org\talend\designer\codegen\translators\processing\TMapMainJava$1.class (Access is denied) It turns out that the windows file permissions […]

Posted in How to | Tagged | Comments Off on How to resolve a Talend Execution failed due to access is denied error

Java for Talend Tips

Java for Talend Tips.

Posted in How to | Tagged , | Comments Off on Java for Talend Tips

Using a ternary expression to check if a value is null

Simple test to see if a field is null. I’m using this in Talend to determine if I copy the value into a new note field. You could use a length test, but if the field is a date, then you need to do it this way. row1.field1 != null ? do_this_if_true : do_this_if_false

Posted in How to | Tagged , , | Comments Off on Using a ternary expression to check if a value is null

Multiple ternary expressions

This is how to use Talend to concatenate multiple columns (fields) into one field neatly. Say we have three fields, row1.field1, row1.field2, row1.field3 that we want to insert into a output.notes column. In the tMap component, use the following expression: (StringHandling.LEN(row1.field1) > 0 ? “Field 1: “+row1.field1+” ” : “”)+(StringHandling.LEN(row1.field2) > 0 ? “Field 2 […]

Posted in How to | Tagged , , | Comments Off on Multiple ternary expressions

Using a ternary operator in Talend Open Studio

I’m currently preparing some data for import into SugarCRM for a client. The source data has a column that contains the given names (i.e. “Jane Mary”) and a second column containing the surname (i.e. “Doe”). Using Talend Open Studio we want to separate the given names into first_name and middle_names columns. So, how do we […]

Posted in How to | Tagged , , | Comments Off on Using a ternary operator in Talend Open Studio

Talend phone number handling example

Talend phone number handling example.

Posted in How to | Tagged , , , | Comments Off on Talend phone number handling example

Talend by example

Talend by example. Useful resource if you’re learning to use Talend.

Posted in How to | Tagged , | Comments Off on Talend by example

2013-10-30 Open loops

Why PowerBI use Talend. An explaination of the Four types of Enterprise Architecture. Fanboi’s step aside, the sheer number of iPads in education is impressive. Documentation on how to map an Alfresco space to a drive. Alfresco and Client WebDAV. Geeky podcast. Brett Terpstra in Systematic. OS X and iOS oriented, productivity geek heaven. Off-topic, […]

Posted in General | Tagged , , , , | Comments Off on 2013-10-30 Open loops