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 path to the new version.

When you install IBM DataStage, it sets the JRE path to its own Java JRE on version 1.7. The error happens because any Eclipse-based application like Talend tries to use the default JRE path even when your computer only has 1.8 Java. To override the default path, you need to add a few lines. in the configuration setting (Talend-Studio-win-x86_64.ini or TOS_DI-win-x86_64.ini) file.

1
2
3
4
-vm
C:\Program Files\Java\jdk1.8.0_101\bin\javaw.exe
-vmargs
-Dosgi.requiredJavaVersion=1.8

The config file has the same name as the application. It is found here:

How can I find my JER path?

Here are the steps for finding the JER path on your computer (Windows)

(1) Type Java in the search

(2) Choose ‘About Java’ or ‘Configure Java’

(3) Once you go into Java Control Panel, hit the Java tab and click ‘View’.

(4) You will see your JREs. You can copy and paste the right path into the Talend config file.

ETL
Running Jobs with Informatica Cloud REST API

Informatica Cloud offers REST API for us to interact with the platform programmatically. At this point in time, the latest official reference is found here. In this post, we are going to use Python to trigger jobs through API. Triggering a job is a 2-step process. We need to authenticate …

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
How To Rename Mapping Job In Informatica Cloud

Mappings are where all the magic happens in Informatica Cloud. When I started using it, it took me a while to work out how to rename a mapping job. Since then, a few people asked me the same question. So, I decided to write about it. This is probably the …