topic Re: Sync between SugarCRM and another MySQL Database in Talend Studio

Sync between SugarCRM and another MySQL Database

Anonymous — Sat, 16 Nov 2024 13:51:21 GMT

Hi,
I need to synchronize SugarCRM with a MySQL database (for contacts, accounts, opportunities) but i couldn't find the good operation.
How can I proceed? Do I must map data in one direction and in a second time, map data in the other direction or is there an object which can do synchronization ?
Thanks

Re: Sync between SugarCRM and another MySQL Database

Anonymous — Tue, 28 Jul 2009 04:07:29 GMT

Hello
There is not a component to synchronize records directly. You need do several processing to synchronize records in database:
1)delete records
Query all records from database, then do a inner join with records from SugarCRM and get the reject id, which exist in database but does't exist in SugarCRM, finnaly, use a txxxRow to delete records in database when id equals to these reject id.
2)insert or update
Query all records from Sugarcrm, then insert into database, set id column as key and select 'insert or update' action on db output component.
Best regards
shong

Re: Sync between SugarCRM and another MySQL Database

Anonymous — Mon, 25 Jan 2010 06:17:34 GMT

hi all,
i need to do the same (delete and update ) operatoion for my ETL job. I am using infobright as my database which doesn't support any keys. Delete and update operations are performed based on the key. How can i achieve this in infobright.

Thanks,
Raja K

Re: Sync between SugarCRM and another MySQL Database

_AnonymousUser — Fri, 19 Feb 2010 14:43:10 GMT

Hi Raja,
Infobright Enterprise Edition has delete and update capability. This is not available in the Community Edition (ICE).
Infobright does not have the concept of keys. Every column has the same status as every other column. It is also intended to be used mostly as a "read-only" database. Most of our customers have a source system (transactional OLTP database or ODS) and then bulk load the data across into Infobright.
For slowly-changing dimensions, we recommend building a new copy of the dimension in a temporary table, dropping the original dimension table, and then copying the data back to the original dimension table.
Geoffrey

Re: Sync between SugarCRM and another MySQL Database

Anonymous — Wed, 17 Mar 2010 13:37:53 GMT

Hi cl.grange,
Im' new to Talend Open Studio, and like you, i want to synchronize two oracle databases.
So can you plz tell us how you did to synchronize SugarCRM with your MySQL database ?

Re: Sync between SugarCRM and another MySQL Database

Anonymous — Thu, 18 Mar 2010 03:51:49 GMT

Hi Geoffrey,

Thank you so much for your reply. i am using Infobright Enterprise edition. we have insert,insert or update, update or insert,delete ...these operations are come along with mysql component in talend. How can i use (nsert or update, update or insert,delete) these options directly on inforbright database ?
Thanks,
Raja K

Re: Sync between SugarCRM and another MySQL Database

_AnonymousUser — Wed, 13 Oct 2010 20:11:38 GMT

Hi Raja,
Yes, with Infobright Enterprise Edition, you can do that. It may be more effective and efficient, however, to use the contributed tInfobrightOutput component for loads instead of the standard MySQL components, which rely on INSERT.
Geoffrey