Procedure – Talend Open Studio for ESB Document Jdbc 7.x

Procedure

  1. Drag and drop a tDBSQLRow component from the
    Palette to the design workspace.

    Procedure_1.png

  2. Double-click tDBSQLRow to open its Basic settings view.

    Procedure_2.png

  3. Select Repository in the Property Type list as the ODBC connection has been
    configured and saved in the Repository. The follow-up fields gets filled in
    automatically.

    For more information on storing DB connections in the Repository, see

    Talend Studio User Guide    .
  4. The Schema is built-in for this Job and it
    does not really matter in this example as the action is made on the table
    auto-increment and not on data.
  5. The Query type is also built-in. Click on the
    […] button next to the Query statement box to launch the SQLbuilder editor,
    or else type in directly in the statement box:

    Alter table <TableName> auto_increment = 1
  6. Press Ctrl+S to save the Job and F6 to run.

    The database autoincrement is reset to 1.
Document get from Talend https://help.talend.com
Thank you for watching.
Tagged:

Related Post:

  1. tSplunkEventCollector – Talend Open Studio for ESB Document Splunk 7.x
  2. tSnowflakeOutputBulk – Talend Open Studio for ESB Document Snow Flake 7.x
  3. tDBRow – Talend Open Studio for ESB Document Snow Flake 7.x
  4. tMysqlBulkExec Standard Properties – Talend Open Studio for ESB Document Snow Flake 7.x
  5. tS3Configuration properties for Apache Spark Batch – Talend Open Studio for ESB Document Snow Flake 7.x
  6. tSnowflakeRollback Standard properties – Talend Open Studio for ESB Document Snow Flake 7.x
  7. tDBCDC – Talend Open Studio for ESB Document Snow Flake 7.x
  8. tSnowflakeBulkExec – Talend Open Studio for ESB Document Snow Flake 7.x
  9. tDBOutput – Talend Open Studio for ESB Document Snow Flake 7.x
  10. tSnowflakeInput – Talend Open Studio for ESB Document Snow Flake 7.x
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments