Data synchronization with Talend open studio

parttea - May 28, 2009 at 04:42 AM
 M - Mar 25, 2010 at 04:46 PM
Hi everyone,

After building a database for our growing company, we have a problem with our data and its synchronization. Our company has a rather small, but growing, book warehouse and sells books online. We have been able to deal with orders and stock because sales were not that large.

But today we sell more and more books and the addition of a database means we need to synchronize our data from the warehouse database to the main office one, mainly to be able to know what kind of stock we have. I think we will have to go with a batch syncing scheduled twice a day for now. We have been dealing with Talend open studio so far and enjoy pretty much the product.

Do you think Talend will be able to stand that type of operation? What kind of software could be used in this case?

Thanks all!

2 responses

May 28, 2009 at 05:13 AM
Hi, Talend is *exactly* the right type of product for this task. It's what it's designed for.

Check out our web site for more info:
As Talendsolutions says it is the right solution for your needs.

So basically what you want to do is sync up two databases several times a day. Talend Open Studio can efficiently do what you are asking, so stay with the tool. The best thing to do would be to go check Talend 's page on data synchronization:

Just the fact you already know the software and use it, you'll save a lot of time (and money) on this. It is much easier for you than taking a new one.
Thanks a lot for your answers, I will go on talend's website and find some information about synchronisation with Talend open studio. As soon as I have tried it out, I will give you some feedback.
You may need something more than Talend Open Studio. They have Talend Integration Suite (built on top of Talend Open Studio) that supports Change Data Capture (CDC). With CDC you can move only data that has changed and not all data each time. This will increase your productivity. I believe this is what you are looking for.