Create directory in Talend

Today, I'm goint to tell you, how we can create folders/directory in Talend

We use tSystem componet with commend-

"cmd /c mkdir C:\\path\\dir_to_make"

we can use many commend as per our requirement using tSystem component.

Connect MS SQL Server from Oracle SQL Developer 3.2 using JDBC

Hello,

Here are the step to connect MS SQL Server from Oracle SQL Developer 3.2 using jtds-1.2.7.jar file (plugin)

1.       Open Oracle SQL Developer to go Tools Menu >> preferences

2.       In pop up window go to tree view explorer >> Database >> Third party JDBC Drivers

3.       Click on Add Entry >> select jtds-1.2.7-dist folder >> jtds-1.2.7.jar click ok

4.       Restart SQL Developer.

Now click on + button (new connection) and you will be able to connect SQL Server databases as well.

Use this link to download jtds driver

Below is the screenshot of preferences options.

How to read password value from context variable in Talend

Hello,

By using tContextDump we can read all context values except passwords, tContextDump print passwords as ********** so how we can read that.

Let say we have a context variable CAT_Prod_Password which contains the password value.

So in order to read its value we can use tJava with below code-

System.out.println(context.CAT_Prod_Password);

Sample job screen shot-

Write table name automatically for table input/output components

Hello friends,
Today I'm going to tell you how we can save out time while working with table input and output components.

Its simple, just go to component Tab>>View and writhe __TABLE__ as label format and you will see table component will show table name automatically.

Memory allocation for talend

I updated my talend 5.4 version memory setting to get maximum speed for 4GB RAM



I used below values-

-vmargs
-Xms512m
-Xmx1536m
-XX:MaxPermSize=1024m
-Dfile.encoding=UTF-8


Try, it works!