Extracting data from the database table and writing it into an LDIF file

LDIF

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

Procedure

  1. Double-click tMysqlInput to open its Basic settings view.
  2. Fill in the Host, Port, Database, Username, and Password fields with your MySQL database connection details.
  3. Click the [...] button next to Edit schema and in the pop-up window define the schema by adding four columns: dn, id_owners, registration, and make, all of String type.
  4. In the Table Name field, enter the name of the table from which the data will be read. In this example, it is ldifdata.
  5. Click the Guess Query button to fill in the Query field with the auto-generated query.
  6. Double-click tFileOutputLDIF to open its Basic settings view.
  7. In the File Name field, browse to or enter the path to the LDIF file to be generated. In this example, it is E:/out.ldif.
  8. Select the operation Add from the Change type list.
  9. Click the Sync columns button to retrieve the schema from the preceding component.