In this post I quickly go through 3 best practices you should know before you start using Talend. They might seem a bit abstract at first, but they will save you a lot of time in the (not so) long run.
Tag: Talend
Dealing with non-primitive types with Talend tPostgresqlOuput component
Batch entry 0 INSERT INTO "public"."log" ("source","logged") VALUES ('123.45.56.78','2017-06-21 13:52:23') was aborted. Call getNextException to see the cause.
Ever bump into this kind of exception? This issue drove me crazy, and it took me a good few hours to figure out how to deal with it. The solution is actually very simple… once you know it!
Continue reading Dealing with non-primitive types with Talend tPostgresqlOuput component
Using Talend tRowGenerator to populate tables with foreign key constraints
Many tutorials show how to use the tGeneratorRow component, but most of them (if not all of them) consider ad-hoc examples. Therefore, they’re often hard to apply in real-world situations. In this post I’m going to explain how to populate a table referencing another table.
Continue reading Using Talend tRowGenerator to populate tables with foreign key constraints