• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Help required: data integration between sql server and mysql...

#1 2009-12-29 03:28:43

Sarvajith
Guest

Help required: data integration between sql server and mysql...

Tags: [DB, synchronize]

Hi,

I am a new Talend user. I am trying to synchronize a sql server DB with a mysql DB. The way I want the end result to be is:

      - When data on the sql server DB is updated, I want this, updated data, to be sent and stored in the mysql DB.
 
      - I know the schemas of both the DBs.

      - I have connected to the sql server DB from talend.

I am trying to create a job to accomplish this. My question is:

     - is this type of synchronization possible on Talend?

     - How do i go about starting a project like this?

#2 2009-12-29 04:32:31

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: Help required: data integration between sql server and mysql...

Hello

- is this type of synchronization possible on Talend?

It is easy to synchronize different DB with commerical version Talend Integration Suite.

Best regards

        shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2012-10-25 13:51:39

CristinaRosca
Guest

Re: Help required: data integration between sql server and mysql...

I have another question. I've made a talend job that uses a mysql schema. Is it possible to easily switch that job to a mssql schema with the same structure (same table structure) ??

#4 2012-10-25 14:15:23

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1137

Re: Help required: data integration between sql server and mysql...

Copy the schema and paste it into a mssql database component.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Help required: data integration between sql server and mysql...

Board footer

Powered by FluxBB