Configuring tJDBCOutput - 6.5

Deduplication

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Deduplication components
Data Quality and Preparation > Third-party systems > Data Quality components > Deduplication components
Design and Development > Third-party systems > Data Quality components > Deduplication components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tJDBCOutput to open its Component view.
  2. In the JDBC URL field, enter the URL of the database in which you need to write the duplicate entries. In this example, it is jdbc:mysql://10.42.10.13:3306/Talend, a MySQL database called Talend.
  3. In the Drive JAR table, add one row to the table by clicking the button.
  4. Click this new row and then click the button to open the [Select Module] dialog box from which to import the jar file required by the MySQL database.
  5. In the Class name field, enter the class file to be called. In this example, it is org.gjt.mm.mysql.Driver.
  6. In the User name and the Password fields, enter the authentication information to that database.
  7. In the Table name field, enter the name of the table in which you need to write data, for example, Namelist. This table must already exist.