August 15, 2023

Modifying the CRM data – Docs for ESB 6.x

Modifying the CRM data

Modify the data of your customers in your CRM, for example, convert all customer
names to upper case.

  1. Double-click the tMap component and
    enter row1.CustomerName.toUpperCase()in front of the CustomerName column to convert all customer names
    to upper case.
  2. Click Ok.
  3. Double-click the tMysqlOutput
    component.
  4. In the Action on table field, select
    None.
  5. In the Action on data field, select
    Insert or update to insert or update
    table data.
  6. Save your job and press F6 to execute
    the job.

To view all changes done on data, right-click the Leadfact
table and select View All Changes to open the
relevant dialog box.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x