SSIS - Never expected it to be so good ...
For past 6 months I am looking into SSIS (SQL Server Integration Services) as a ETL technology. Frankly, I never expected that it would be so mature a platform. With SSIS Microsoft directly competes with Informatica (which has ben around for years) in ETL space. At first glance it looked as a battle between a mouse and a dinosaur. However, Microsoft's Business Intelligence Suite is gradually gaining pace and recognition. It is now a very mature platform. The suite consists of Integration Services, Analysis Services and Reporting Services. It has a development environment in form of BIDS (Business Intelligence Studio) which is ok. The provision for C# based custom scripts is quite good. The framework options are also reasonable. The SQL Data validation options are pretty ok. However, debugging the C# custom scripts is still a pain. Overall it is a decent bet given the fact that it ships free with SQL Server as compared to the costs associated with Informatica.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment