These properties are used to configure tDotNETRow running in the Standard Job framework.

The Standard
tDotNETRow component belongs to the DotNET family.

The component in this framework is available in all Talend
products.

Basic settings

Advanced settings

Global Variables

Usage

1. Specifying the dll to load in the DDL to load field. The
   DLL can be a system assembly or a custom DLL.
   

   For system assemblies, you can specify the name of the desired system
   assembly (for example, “System.Data, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089”); for custom
   dlls, you need to provide the absolute path to the dll (for example,
   "C:\WINDOWS\system32\ClassLibrary1.dll)".
2. Specify the class name and the name space in the Fully qualified
   class name field
3. Set parameter values for the constructor in the Value(s) to pass to the constructor field.

1. Add columns in the schema by clicking the Edit schema
   button or using the schema propagated to this component. You need to specify one
   of the columns of the schema for holding the output value (if any) using the
   Output value target column drop-down list.
   

2. Select Propagate data to output to pass the data from
   input to output.
3. Take either of the following two options.
   • If you have deployed a tDotNetInstantiate component for creating the
     .Net object, select Use an existing instance and
     select the component from the Existing instance to
     use drop-down list to refer the corresponding .Net
     object.
   • You can also create a new .Net object for use. To achieve this, make
     sure Use an existing instance is not select, set
     DLL to load, Fully qualified class
     name, Method Name, and
     Value(s) to pass to the constructor options
     as needed.
4. Provide the name of the method to invoke in the Method
   Name field.
5. Provide the parameter values for the method in rows of the Method
   Parameters filed. As prompted, you can use input row values as
   parameter values (for example, input_row.column_name).
   Note:

   • For information about other options of this component, refer to
     Talend Components Reference Guide.
   • See Utilizing .NET in Talend section in Talend Components Reference
     Guide for an example of this article.

Before replicating this scenario, you need first to build up your runtime
environment.

• Create the DLL to be loaded by tDotNETInstantiate

  This example class built into .NET reads as follows:

  using System; using System.Collections.Generic; using System.Text; namespace Test1 { public class Class1 { string s = null; public Class1(string s) { this.s = s; } public string getValue() { return "Return Value from Class1: " + s; } } }

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

  using System; using System.Collections.Generic; using System.Text;     namespace Test1 {     public class Class1     {         string s = null;         public Class1(string s)         {             this.s = s;         }           public string getValue()         {             return "Return Value from Class1: " + s;         }       }     }

  This class reads the input value and adds the text Return Value from Class1: in front of this value. It is
  compiled using the latest .NET.

• Install the runtime DLL from the latest .NET. In this scenario, we use
  janet-win32.dll on Windows 32-bit version and place it in the
  System32 folder.

  Thus the runtime DLL is compatible with the DLL to be loaded.

1. Drop the following components from the Palette to the design workspace: tDotNETInstantiate, tDotNETRow and tLogRow.
2. Connect tDotNETInstantiate to tDotNETRow using a Trigger
   On Subjob OK connection.
3. Connect tDotNETRow to tLogRow using a Row
   Main connection.

1. Double-click tDotNETInstantiate to
   display its Basic settings view and define
   the component properties.
   

2. Click the three-dot button next to the Dll to
   load field and browse to the DLL file to be loaded.
   Alternatively, you can fill the field with an assembly. In this example, we
   use :
   “C:/Program
   Files/ClassLibrary1/bin/Debug/ClassLibrary1.dll””
3. Fill the Fully qualified class name field
   with a valid class name to be used. In this example, we use:
   “Test1.Class1”
4. Click the plus button beneath the Value(s) to pass
   to the constructor table to add a new line for the value to
   be passed to the constructor.
   In this example, we use:
   "Hello world"

1. Double-click tDotNETRow to display its
   Basic settings view and define the
   component properties.
   

2. Select Propagate data to output check
   box.
3. Select Use an existing instance check box
   and select tDotNETInstantiate_1 from the
   Existing instance to use list on the
   right.
4. Fill the Method Name field with a method
   name to be used. In this example, we use “getValue”, a
   custom method.

5. Click the three-dot button next to Edit
   schema to add one column to the schema.
   

   Click the plus button beneath the table to add a new column to the schema
   and click OK to save the setting.
6. Select newColumn from the Output value target column list.

1. Double-click tLogRow to display its
   Basic settings view and define the
   component properties.
   

2. Click Sync columns button to retrieve the
   schema defined in the preceding component.
3. Select Table in the Mode area.

Save your Job and press F6 to execute it.

From the result, you can read that the text Return Value from Class1
is added in front of the retrieved value Hello world.