ETL

Tips and Troubleshooting For Uploading CSV to Database In Talend

There will be time when you want to upload a big csv file (with many rows and hundreds of columns) to a relational database table. Talend Open Studio is an open source ETL tool that I use regularly to do odd jobs like that. I like using it because it …

ETL

Talend: How To Resolve OutOfMemoryError: Java heap space

When we try to process large data with Talend Studio on your computer, you may get OutOfMemoryError. Exception in thread “main” java.lang.OutOfMemoryError: Java heap space To resolve this error, you need to increase the Xmx parameter in the config file (such as Talend-Studio-win-x86_64.ini or TOS_DI-win-x86_64.ini). By default, the value is set …

ETL

Talend: How To Resolve ‘Failed to load the JNI shared library’ Error

When you try to open Talend application, you might get the error message below. Let’s resolve it. Failed to load the JNI shared library “C:\IBM\InformationServer/jdk32\jre\bin\j9vm\jvm.dll”. Talend (both free and licensed) requires Java 1.8. If you still have Java 1.7, you need to upgrade it to 1.8 and set the Java_Home …