Steve Sauer (I'm guessing that is his name) is writing a diploma thesis in which he is comparing various data integration suites including BO Data Integrator, Informatica and various others. And SSIS of course (otherwise why would I be writing this post).
He has been asking alot of interesting questions on the SSIS forum about SSIS's capabilities and I was disappointed to read that he doesn't class SSIS as what he terms a "professional data integration platform". In fairness he does give reasons and he cites SSIS's lack of what he believes are enterprise-class features such as:
- Impact analysis
- Data lineage
- Metadata exchange
- No out-of-the-box support for enterprise systems
None of which I would dispute (much).
I don't have much experience to speak of in regard to the other tools that Steve is covering so I can't really talk about the areas in which, in Steve's opinion, SSIS is falling short. Nor can I argue to the contrary - much as I would like to. I do have a very strong belief however that SSIS more than fulfills the requirements of a professional data integration tool due to its huge range of features, ease of extensibility and fantastic performance.
I look forward to hopefully being able to read Steve's final thesis submission. In the meantime, I am interested to see what other people think about this subject.
- Do you think SSIS qualifies as a Professional Data Integration Platform?
- Do you agree with Steve's assertion that SSIS falls short in some important areas?
- What, in your opinion, constitues a Professional Data Integration Platform?
Feel free to post comments up here, or write your opinions elsewhere (perhaps on your own blog) and let me know. I'm interested to read people's thoughts around this subject.