August 15, 2023

Configuring the database connection – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the database connection – Docs for ESB 6.x

Configuring the database connection

  1. Double-click the tMysqlConnection
    component to open its Basic settings
    view.

    components-tmysqlconnection_s2_2.png

  2. With the Property Type set to Built-In, specify the connection details in the
    relevant fields, including:

    • the host name or IP address of your database server

    • the listening port number

    • the database name

    • the user name and password for your database
      authentication.

    If you have stored your connection details under the Metadata node in the Repository tree view, you can simply drop your centralized
    metadata item onto the tMysqlConnection
    component. For information on how to centralize a database connection, see
    the chapter on managing metadata of the
    Talend Studio
    User Guide    .
  3. Select the Use or register a shared DB
    Connection     check box so that the database connection open by
    this component can be shared across different Jobs. Then, enter a name for
    the shared connection between double quotes in the Shared DB Connection Name field, shared_mysql_connection in this example.
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