• Index
  •  » Talend Open Studio for Data Integration » Suggestions
  •  » Data Synchronization

#1 2012-04-24 16:44:26

pratik.borkar
Member
Registered: 2012-04-18
Posts: 11

Data Synchronization

Hi all, I'm new to Talend. I'm currently developing a project that will synchronize real time transactional data from MSSQL to Cassandra at specific intervals. So my concern is:-

- how can start my project?
- what are the basic requirements?
- Is it the efficient ETL tool for this project? Considering Latency period, processor, Bandwidth, Hard Disk space.

Best Regards

Offline

#2 2012-04-25 08:11:20

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Data Synchronization

Hi

Talend Data Integration can support database synchronization at specific intervals and offer many ways to optimize performance.
You might simply create an ETL job and drag&drop the components you need: tMSSQLInput, tCassandraOutput and so on so forth.

But the problem is that official component Cassandra is not available. There is only a custom component developed by Cantoine on Exchange.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-04-26 10:16:12

pratik.borkar
Member
Registered: 2012-04-18
Posts: 11

Re: Data Synchronization

HI Thanks,

So, I will have to modify the code of tCassandraOutput as per my requirements right?


best regards

Offline

#4 2012-04-26 10:21:15

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Data Synchronization

Hi

You can report it on BugTracker for this component.
Developers might add this new feature into roadmap.

Regards,
Pedro


Only Paranoid Survive.

Offline

#5 2012-04-26 11:45:36

pratik.borkar
Member
Registered: 2012-04-18
Posts: 11

Re: Data Synchronization

Well thanks,

I've TOS_MDM. I've downloaded the tCassandraOutput component and is visible and can be dragged in jobs. So Is MDM the right ETL Tool for my project or shall i download TOS_DataIntegration. 

Best Regards.

Offline

#6 2012-04-26 11:49:41

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Data Synchronization

Hi

TOS_MDM also contains Integration feature.
You can create job under it.

Regards,
Pedro


Only Paranoid Survive.

Offline

#7 2012-04-26 14:10:15

pratik.borkar
Member
Registered: 2012-04-18
Posts: 11

Re: Data Synchronization

Hi,

Thanks for your support.

Best Regards.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Suggestions
  •  » Data Synchronization

Board footer

Powered by FluxBB