TSugarCRMOutput component

One Star

TSugarCRMOutput component

Hi,
I need to synchronize a Mysql-based CRM with SugarCRM.
I'm using TSugarCRMOutput component and I need to do multiple table inserts, but it seems not to support them.
For example I need to insert an Account and a Contact linked to it.
Should I develop a new customized component or does it exists anywhere ?
Or should I use a generic Mysql output component that manually inserts a row in the SugarCRM's "account_contacts" table ?
Employee

Re: TSugarCRMOutput component

Hello,

SugarCRM components are limited by the API of SugarCRM.

You can directly use tMySQLOutput component to insert into account_contacts.
This is not really risky, but keep in mind thaht any direct modification is at your own risks

Regards,
One Star

Re: TSugarCRMOutput component

I've tried, but there's still a problem.
I need to insert a new row with a 36-chars id, generated by a SugarCRM function.
How can I do it without using the specific SugarCRM component ?

Regards,
Employee

Re: TSugarCRMOutput component

The ID inserted is put in the globalMap.

You can get it trough the following code :
globalMap.get("SUGAR_COMPONENT_NAME_ID") where SUGAR_COMPONENT_NAME can be something like tSugarCRMOutput_1

or you can use the Ctrl+Space shortcut

Regards,

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog