whereas a move to Talend would allow non-developer staff to handle integration task more easily due to it's drag and drop interface.
THAT RIGHT THERE is a very strong reason to NOT aquire such a tool. It's bad enough that, when it comes to data, many Developers don't actually have a clue especially about the ramifications of what they're doing to the underlying box. Putting such a took in the hands of people that are even more ignorant in that area is a series of accidents and bad data just waiting to happen.
I also find that demos are meant to be "sensational". And equally good demo can be and had been done for SSIS many times. Remember that everything is "perfect" in Demos. Of course, you stated...
the demo provided really didn't show me it's value over SSIS for the price
... and so you're already well aware of one of my favorite quotes:
"Change is inevitable... change for the better is not".
I would challenge the makers of Talend... have them set you up so that you and your people can do a head-to-head comparison because "One good experiment is worth a thousand expert opinions".
As for SSIS...I don't care for it either (I don't actually care for any of this drag'n'drop stuff because it turns out that's usually not all that's necessary) but it's free and, in the right hands, will get the job done well.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)