August 15, 2023

Extracting data from the database table and writing it into an LDIF file – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Extracting data from the database table and writing it into an LDIF file – Docs for ESB 6.x

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

  1. Double-click tMysqlInput to open its
    Basic settings view.

    Use_Case_tFileOutputLDIF2.png

  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.

    Use_Case_tFileOutputLDIF3.png

  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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x