tAdvancedFileOutputXML – Docs for ESB 5.x
tAdvancedFileOutputXML tAdvancedFileOutputXML properties Component family XML or File/Output Function tAdvancedFileOutputXML outputs data to an XML type of file and offers an interface to deal with loop and group by elements if needed. Purpose tAdvancedFileOutputXML writes an XML file with separated data values according to an XML tree structure. Basic settings Property type Either Built-in…
tAggregateRow – Docs for ESB 5.x
tAggregateRow tAggregateRow properties Component family Processing Function tAggregateRow receives a flow and aggregates it based on one or more columns. For each output line, are provided the aggregation key and the relevant result of set operations (min, max, sum…). Purpose Helps to provide a set of metrics based on values or calculations. Basic settings…
tAddCRCRow – Docs for ESB 5.x
tAddCRCRow tAddCRCRow properties Component family Data Quality Function tAddCRCRow calculates a surrogate key based on one or several columns and adds it to the defined schema. Purpose Providing a unique ID helps improving the quality of processed data. Basic settings Schema and Edit Schema A schema is a row description. it defines the number…
tAddLocationFromIP – Docs for ESB 5.x
tAddLocationFromIP tAddLocationFromIP Properties Component family Misc Function tAddLocationFromIP replaces IP addresses with geographical locations. Purpose tAddLocationFromIP helps you to geolocate visitors through their IP addresses. It identifies visitors’ geographical locations country, region, city, latitude, longitude, ZIP code…etc.using an IP address lookup database file. Basic settings Schema and Edit schema A schema is a row…
tAddressRowCloud – Docs for ESB 5.x
tAddressRowCloud Warning This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend Platform products. tAddressRowCloud properties Component family Data Quality Function tAddressRowCloud verifies and formats international addresses in the Cloud by using online services. Purpose tAddressRowCloud enables you to parse address…
tAmazonAuroraCommit – Docs for ESB 5.x
tAmazonAuroraCommit tAmazonAuroraCommit Properties Component family Cloud/AmazonRDS/Aurora Function This component validates the data processed through the Job into the connected Amazon Aurora database. Purpose Using a unique connection, this component commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance. Note that if…
tAmazonAuroraClose – Docs for ESB 5.x
tAmazonAuroraClose tAmazonAuroraClose properties Component family Cloud/AmazonRDS/Aurora Function This component closes an active connection to an Amazon Aurora database instance. Purpose This component allows you to close an active connection to an Amazon Aurora database instance to release the occupied resources. Basic settings Component List Select the tAmazonAuroraConnection component that opens the connection you need to…
tAlfrescoOutput – Docs for ESB 5.x
tAlfrescoOutput tAlfrescoOutput Properties Component family Business Function Creates dematerialized documents in an Alfresco server where they are indexed under meaningful models. Purpose Allows to create and manage documents in an Alfresco server. Basic settings URL Type in the URL to connect to the Alfresco Web application. Login and Password Type in the user…
tAggregateSortedRow – Docs for ESB 5.x
tAggregateSortedRow tAggregateSortedRow properties Component family Processing Function tAggregateSortedRow receives a sorted flow and aggregates it based on one or more columns. For each output line, are provided the aggregation key and the relevant result of set operations (min, max, sum…). Purpose Helps to provide a set of metrics based on values or calculations. As…
tAmazonAuroraOutput – Docs for ESB 5.x
tAmazonAuroraOutput tAmazonAuroraOutput properties Component family Cloud/AmazonRDS/Aurora Function This component writes, updates, makes changes or suppresses entries in an Amazon Aurora database. Purpose This component executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the Job. Basic settings Property Type…