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 …. Continue Reading »

tJDBCSP Centralizes multiple or complex queries in a database in order to call them easily. tJDBCSP Standard properties These properties are used to configure tJDBCSP running in the Standard Job framework. The Standard tJDBCSP component belongs to the Databases family. The component in this framework is available in all Talend …. Continue Reading »

Inserting data in mother/daughter tables The following Job is dedicated to advanced database users, who want to carry out multiple table insertions using a parent table id to feed a child table. As a prerequisite to this Job, follow the steps described below to create the relevant tables using an …. Continue Reading »

Using PreparedStatement objects to query data This scenario describes a four component job which allows you to link a table column with a client file. The MySQL table contains a list of all the American States along with the State ID, while the file contains the customer information including the …. Continue Reading »

tJDBCClose Closes an active JDBC connection to release the occupied resources. tJDBCClose Standard properties These properties are used to configure tJDBCClose running in the Standard Job framework. The Standard tJDBCClose component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component …. Continue Reading »