Talend Document Version 7.3.1

tHDFSConnection – Docs for ESB 7.x

tHDFSConnection Connects to a given HDFS so that the other Hadoop components can reuse the connection it creates to communicate with this HDFS. tHDFSConnection provides connection to the Hadoop distributed file system (HDFS) of interest at runtime. tHDFSConnection Standard properties These properties are used to configure tHDFSConnection running in the Standard Job framework. The Standard…

tIngresOutput – Docs for ESB 7.x

tIngresOutput 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. tIngresOutput writes, updates, makes changes or suppresses entries in a database. tIngresOutput Standard properties These properties are used to configure tIngresOutput running in the Standard Job framework….

tTeradataLookupInput – Docs for ESB 7.x

tTeradataLookupInput Executes a database query with a strictly defined order which must correspond to the schema definition. 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…

tMicrosoftCrmOutput – Docs for ESB 7.x

tMicrosoftCrmOutput Writes data into a Microsoft CRM database. tMicrosoftCrmOutput Standard properties These properties are used to configure tMicrosoftCrmOutput running in the Standard Job framework. The Standard tMicrosoftCrmOutput component belongs to the Business family. The component in this framework is available in all Talend products. Basic settings Authentication Type Select the authentication type that corresponds to…

tS3List – Docs for ESB 7.x

tS3List Lists the files on Amazon S3 based on the bucket/file prefix settings. tS3List Standard properties These properties are used to configure tS3List running in the Standard Job framework. The Standard tS3List component belongs to the Cloud family. The component in this framework is available in all Talend products. Basic settings Use existing connection Select…

tSAPDSOInput – Docs for ESB 7.x

tSAPDSOInput Retrieves DSO data from an SAP BW system. tSAPDSOInput retrieves DSO (Data Store Object) data from an SAP BW system. tSAPDSOInput Standard properties These properties are used to configure tSAPDSOInput running in the Standard Job framework. The Standard tSAPDSOInput component belongs to the Business family. The component in this framework is available in all…

tGreenplumInput – Docs for ESB 7.x

tGreenplumInput Reads a database and extracts fields based on a query. tGreenplumInput executes a DB query with a strictly defined order which must correspond to the schema definition and then it passes on the field list to the next component via a Main row link. tGreenplumInput Standard properties These properties are used to configure tGreenplumInput…

tMSSqlRow – Docs for ESB 7.x

tMSSqlRow Acts on the actual DB structure or on the data (although without handling data). tMSSqlRow executes the SQL query stated onto the specified Microsoft SQL Server or Azure SQL database, depending on the nature of the query and the database. The row suffix means the component implements a flow in the job design although…

tFileStreamInputRegex – Docs for ESB 7.x

tFileStreamInputRegex Listens on a given directory for new files, then reads data from these files, row by row, in order to split the data into fields using regular expressions. Using this component requires some advanced knowledge of regular expression syntax. tFileStreamInputRegex properties for Apache Spark Streaming These properties are used to configure tFileStreamInputRegex running in…

tDataMasking – Docs for ESB 7.x

tDataMasking Hides original data with random characters or figures to protect the actual data while having a functional substitute for occasions when it is not advisable to show sensitive real data. tDataMasking reads a data set row by row and creates a structurally similar but inauthentic version of the data after having applied specific functions…