#datavault – interesting .NET ETL engine

I was told about this “ETL engine / Library” of functionality for Microsoft, MSSQLServer, and .NET.  It’s really interesting from the sense that the gentleman who wrote it, did a fairly good job of abstracting code layers and providing functions that are necessary to make things work.  It’s called Rhino ETL, and I believe it’s “open-source”, but you need an MS Visual Studio license to use it.

Upside:

  • custom access to transformation routines
  • not strong typed for data
  • Fast, easy access to SQLServer and standard .NET libraries and DLL functions
  • Cost, it’s cheap!
  • Windows Based

Downsides:

  • No GUI for development
  • No “metadata driven design”
  • May or may not be the “best” ETL engine to access other RDBMS systems, depends on the .DLL’s for connectivity

The BEST part about this?

You can adapt your existing ETL Code generation system to generate Rhino ETL scripts, and be on your way very very quickly in a Microsoft environment.

A good overview video is here: http://blip.tv/ineta-live/writing-etl-jobs-with-c-using-rhino-etl-by-paul-barriere-dallas-c-sig-ug-on-03-04-2010-3323370

Cheers,

Dan Linstedt

Tags: , , , , , , ,

No comments yet.

Leave a Reply

*