Monday, March 31, 2014

EzETL - Intro

Dump database data to a file. Be it stored in a table or a result of a complex query. Or maybe your data source is a SharePoint list? That's fine too
Load data into database stage tables and then invoke some SQL to massage it and put into the permanent place. No matter what vendor the database comes from
Easy! Copy .NET binaries into a folder; configure connection strings; put together a configuration file in XML format. Test. Easy to read log files and console output are at your disposal. Now, just schedule the batch job with your favorite scheduler. Done.
Control. Your ETL tasks are defined with plain text files only. Use source control like SVN or Git to keep track of your changes
And, it's FREE
It's EzETL

0 Comments:

Post a Comment

<< Home