tGreenplumRow – Docs for ESB 7.x
tGreenplumRow Acts on the actual DB structure or on the data (although without handling data), depending on the nature of the query and the database. The SQLBuilder tool helps you write easily your SQL statements. tGreenplumRow is the specific component for this database query. It executes the SQL query stated onto the specified database. The…
tStandardizeRow – Docs for ESB 7.x
tStandardizeRow Normalizes the incoming data in a separate XML or JSON data flow to separate or standardize the rule-compliant data from the non-compliant data. tStandardizeRow tokenizes the data flow it has received from the preceding component and applies user-defined parser rules to analyze the data. Based on this analysis, this component normalizes and writes analyzed…
tDBBulkExec – Docs for ESB 7.x
tDBBulkExec Offers gains in performance while executing the Insert operations on a database. This component works with a variety of databases depending on your selection. The tDBOutputBulk and tDBBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used…
tParAccelOutputBulk – Docs for ESB 7.x
tParAccelOutputBulk Prepares the file to be used as parameter in the INSERT query to feed the ParAccel database. The tParAccelOutputBulk and tParAccelBulkExec are generally used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation used to feed…
tOracleTableList – Docs for ESB 7.x
tOracleTableList Lists the names of specified Oracle tables using a SELECT statement based on a WHERE clause. tOracleTableList iterates on a set of tables through a defined Oracle connection. tOracleTableList Standard properties These properties are used to configure tOracleTableList running in the Standard Job framework. The Standard tOracleTableList component belongs to the Databases family. The…
tSAPIDocInput (deprecated) – Docs for ESB 7.x
tSAPIDocInput (deprecated) Extracts IDoc data set that is used for asynchronous transactions between SAP systems or between a SAP system and another application. tSAPIDocInput connects to an RFC destination in the SAP system through authentication of the SAP gateway server and outputs IDoc files (Intermediate Documents in XML or HTML format) to the user-defined location….
tDBOutputBulk – Docs for ESB 7.x
tDBOutputBulk Writes a file with columns based on the defined delimiter and the standards of the selected database type. This component works with a variety of databases depending on your selection. The tDBOutputBulk and tDBBulkExec components are used together in a two step process. In the first step, an output file is generated. In the…
tSAPADSOInput – Docs for ESB 7.x
tSAPADSOInput Retrieves data of an active ADSO (Advanced Data Store Object) from an SAP BW system on an SAP HANA database. tSAPADSOInput Standard properties These properties are used to configure tSAPADSOInput running in the Standard Job framework. The Standard tSAPADSOInput component belongs to the Business family. The component in this framework is available in all…
tPartitioner – Docs for ESB 7.x
tPartitioner Partitions the input data before tCollector can transfer them to the parallel execution processes. The tPartitioner splits the input records into a given number of threads which tCollector sends for parallel execution. Note that Talend Studio also enables the automatic implementation of parallelization across a Job without use of the parallelization components and we…
tDBConnection – Docs for ESB 7.x
tDBConnection Opens a connection to a database to be reused in the subsequent subJob or subJobs. This component works with a variety of databases depending on your selection. tDBConnection Standard properties These properties are used to configure tDBConnection running in the Standard Job framework. The Standard tDBConnection component belongs to the Databases family. The component…