August 15, 2023

Configuring the connection to the database – Docs for ESB 6.x

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

Configuring the connection to the database

To configure the connection to the MySQL database of interest, proceed as
follows:

  1. Double-click tMysqlConnection to open its
    Component view.

    use_case-tmysqlinvalidrows-dq_rules2.png

  2. In the DB version field, select the
    version of your MySQL database. It is Mysql
    5     in this example.
  3. In the Host field, type in the server IP
    address of the database to which you want to connect, localhost in this example.
  4. In the Port field, type in the port
    number of the database to which you want to connect, 3306 in this example.
  5. In the Database field, enter the name of
    the database in which you need to check the customer table, crm in this example.
  6. In the Username and the Password fields, enter the authentication
    information to connect to the database of interest.
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