tSCPGet – Docs for ESB 7.x
tSCPGet Copies files from the defined SCP server. tSCPGet transfers defined files via an SCP connection over a fully encrypted channel. tSCPGet Standard properties These properties are used to configure tSCPGet running in the Standard Job framework. The Standard tSCPGet component belongs to the Internet family. The component in this framework is available in all…
tFileInputDelimited Standard properties – Docs for ESB 7.x
tFileInputDelimited Standard properties These properties are used to configure tFileInputDelimited running in the Standard Job framework. The Standard tFileInputDelimited component belongs to the File family. The component in this framework is available in all Talend products. Basic settings Property type Either Built-In or Repository. Built-In: No property data stored centrally. Repository: Select the…
tOracleRow – Docs for ESB 7.x
tOracleRow Executes the stated SQL query on the specified Oracle database. Depending on the nature of the query and the database, tOracleRow acts on the actual DB structure or on the data (although without handling data). The SQLBuilder tool helps you write easily your SQL statements. tOracleRow is the specific component for this database query….
tPatternMasking – Docs for ESB 7.x
tPatternMasking Masks data that follows a specific pattern and can transform the original data in consistent manner, if needed. If you need to mask heterogeneous data, you can use the tDataMasking component. For more information, see the tDataMasking documentation on Talend Help Center (https://help.talend.com). tPatternMasking replaces pattern-specific and generic data with random characters from a…
tPersonator – Docs for ESB 7.x
tPersonator Ensures the quality of a US and Canadian contact database by checking, verifying, moving and appending contact data. This component is the result of Talend collaboration with Melissa Data, one of the world leaders for global address validation. For more information about Melissa Data and its software tools, visit the website. Using the Personator™…
tEXistDelete – Docs for ESB 7.x
tEXistDelete Deletes specified resources from a remote eXist database. tEXistDelete Standard properties These properties are used to configure tEXistDelete running in the Standard Job framework. The Standard tEXistDelete component belongs to the Databases family. The component in this framework is available in all Talend products. Basic settings Use an existing connection/Component List Select this check…
tMDMRouteRecord – Docs for ESB 7.x
tMDMRouteRecord Helps Event Manager to identify the changes you have made on your data so that correlative actions can be triggered. tMDMRouteRecord submits the primary key of a record stored in your MDM Hub to Event Manager in order for Event Manager to trigger the due process(es) against some specific conditions that you can define…
tRunJob – Docs for ESB 7.x
tRunJob Manages complex Job systems which need to execute one Job after another. tRunJob executes the Job called in the component’s properties, in the frame of the context defined. Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks: Standard: see tRunJob…
tJDBCLookupInput – Docs for ESB 7.x
tJDBCLookupInput Reads a database and extracts fields based on a query. It passes on the extracted data to tMap in order to provide the lookup data to the main flow. It must be directly connected to a tMap component and requires this tMap to use Reload at each row or Reload at each row (cache)…
Encrypting and decrypting back sensitive data – Docs for ESB 7.x
Encrypting and decrypting back sensitive data This scenarios uses two Jobs. The first Job encrypts last names, postal codes and dates of births. The second Job decrypts back the encrypted sensitive data. Setting up the encryption Job Configuring the input component Configuring the encryption operation Protecting sensitive data with encryption Setting up the decryption Job…