tDotNETRow Standard properties
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
| Schema and Edit schema | A schema is a row description, it defines the number of fields to be processed and passed on to the next component. The schema is either built-in or remotely stored in the Repository. |
| Built-in: No property data stored centrally. | |
| Repository: Select the Repository file where properties are stored. The following fields are pre-filled in using fetched data | |
| Use a static method | Select this check box to invoke a static method in .NET and this will disable Use an existing instance check box. |
| Propagate a data to output | Select this check box to propagate a transformed data to output. |
| Use an existing instance | Select this check box to reuse an existing instance of a .NET object from
the Existing instance to use list.
Existing instance to use: Select an
existing instance of .NET objects created by the other .NET components from the
list.
Information noteNote: This check box will be disabled if you have
selected Use a static method and
selecting this check box will disable Dll to
load, Fully qualified class
name(i.e. ClassLibrary1.NameSpace2.Class1) and Value(s) to pass to the
constructor.
|
| Dll to load | Type in the path, or browse to the DLL library containing the class(es) of interest or enter the assembly's name to be used. For example, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 for an OleDb assembly. |
| Fully qualified class name(i.e. ClassLibrary1.NameSpace2.Class1) | Enter a fully qualified name for the class of interest. |
| Method name | Fill this field with the name of the method to be invoked in .NET. |
| Value(s) to pass to the constructor | Click the plus button to add one or more lines for values to be passed to
the constructor for the object. Or, leave this table empty to call a default
constructor for the object. The valid value(s) should be the parameters required by the class to be used. |
| Method Parameters | Click the plus button to add one or more lines for parameters to be passed to the method. |
| Output value target column | Select a column in the output row from the list to put value into it. |
Advanced settings
| Create a new instance at each row | Select this check box to create a new instance at each row that passes through the component. |
| Method doesn't return a value | Select this check box to invoke a method without returning a value as a result of the processing. |
| Returns an instance of a .NET Object | Select this check box to return an instance of a .NET object as a result of a invoked method. |
| Store the returned value for later use | Select this check box to store the returned value of a method for later reuse in another tDotNETRow component. |
| tStatCatcher Statistics | Select this check box to collect log data at the component level. |
Global Variables
| Global Variables |
NB_LINE: the number of rows processed. This is an After variable and it returns an integer. ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box. A Flow variable functions during the execution of a component while an After variable functions after the execution of the component. To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it. For further information about variables, see Talend Studio User Guide. |
Usage
| Usage rule | This component is utilized to integrate with .NET objects. To use this component, you must first install the runtime DLLs, for example janet-win32.dll for Windows 32-bit version and janet-win64.dll for Windows 64-bit version, from the corresponding Microsoft Visual C++ Redistributable Package. This allows you to avoid errors like the UnsatisfiedLinkError on dependent DLL. So ensure that the runtime and all of the other DLLs which the DLL to be called depends on are installed and their versions are consistent among one another. Information noteNote:
The required DLLs can be installed in the System32 folder or in the bin folder of the Java runtime to be used. If you need to export a Job using this component to run it outside the Studio, you have to specify the runtime container of interest by setting the -Djava.library.path argument accordingly. For users of Talend solutions with ESB, to run a Job using this component in ESB Runtime, you need to copy the runtime DLLs to the %KARAF_HOME%/lib/wrapper/ directory. |