Integrating .Net into Talend Studio: Introduction

Based on the runtime dlls (such as janet-win64.dll), Talend Studio provides the capability of integrating .NET and Java, through which you can access C++ libraries and invoke their methods easily in Java. Normally, for a Talend Studio user, this can be implemented in two ways: utilizing the components in the DotNET family (that is, tDotNetInstantiate and tDotNetRow) in Talend Studio and custom code. This article discusses the first method.

In a Talend Studio Job, the tDotNetInstantiate component can be used as a start component in a flow or an independent subJob. It loads a system assembly or a custom dll by creating a .NET object. The object can then be used by the subsequent tDotNetRow components for invoking the methods. You need also to specify the class and set parameters of the constructor for a tDotNetInstantiate component.

The tDotNetRow component references a .NET object created by a tDotNetInstantiate component. It can be used mid-flow, start the flow, or end the flow. You need to specify the method to be invoked and set the parameters for the method. This component also passes the output of the method to a specified column defined in the schema. So, you need to add columns in the schema of the component and specify the column which the output values are passed to.

This article shows the way to invoke dll methods in a Talend Studio Job, which uses the two DotNet family components.