使用SQL Server 2008 R2 Express创建ETL [英] Create an ETL with SQL Server 2008 R2 Express
问题描述
我最近安装了最新版本的SQL Server(2008 R2 x64)，现在正尝试着创建ETL的第一步.
I've recently installed the latest version of SQL Server (2008 R2 x64) and I'm now trying get my first steps to create an ETL.
是否可以使用SQL Server 2008 R2 Express创建ETL，如果没有，可以免费使用一些工具吗?
Is it possible to create an ETL with SQL Server 2008 R2 Express, and if not is there some tool that provides that for free?
我打算做的是从多个来源收集数据，例如Web服务，rss feed，已解析的url请求，文件或其他数据库引擎.将此收集的数据转换为可理解的模式(出于我的目的)，并将其存储在我的SQL Server数据库中.
What I plan to do is collect data from multiple sources like a web services, rss feeds, a parsed url request, a file or maybe other database engine. Transform this collected data for an understandable schema (for my purposes) and store this in my SQL Server database.
推荐答案
如果您正在寻找一种非常简单但非常灵活且基于代码的方法来替代SSIS(集成服务)，我建议您您可以看一下Ayende Rahien的Rhino ETL代码库.
If you are looking for a rather simple, yet very flexible and more code-based approach as an alternative to the SSIS (Integration Services), I'd recommend you have a good look at the Rhino ETL code library by Ayende Rahien.
查看这些资源:
- Rhino ETL 2.0
- Object-oriented ETL using Rhino ETL
- Write ETL jobs in pure C#
Rhino ETL是一种基于代码的面向程序员的方法-它为您提供了不错的，可用的基类，您可以从中继承并执行几乎所有事情-只需很少的努力.
Rhino ETL is a code-based, programmer-oriented approach - it gives you nice, usable base classes, from which you can inherit and do just about anything - with very little effort.
这篇关于使用SQL Server 2008 R2 Express创建ETL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
