Wednesday, August 24, 2011

Microsoft SQL Server Connector for Apache Hadoop CTP1

Microsoft Downloads - Microsoft SQL Server Connector for Apache Hadoop

"Microsoft SQL Server Connector for Apache Hadoop (SQL Server-Hadoop Connector) CTP is a Sqoop-based connector that facilitates efficient data transfer between SQL Server 2008 R2 and Hadoop. Sqoop supports several databases including MySQL

Version: CTP 1.0
Date Published: 8/24/2011

EULA_SQL Server Connector for Apache Hadoop_CTP (Sept 2011).docx - 23 KB

Microsoft SQL Server - Hadoop Connector User Guide.pdf - 782 KB

sqoop-sqlserver-1.0.tar.gz - 782 KB

THIRDPARTYNOTICES FOR HADOOP-BASED CONNECTORS.rtf - 85 KB

The Microsoft SQL Server Connector for Apache Hadoop extends JDBC-based Sqoop connectivity to facilitate data transfer between SQL Server and Hadoop, and also supports all the features as mentioned in SQOOP User Guide on the Cloudera website. In addition to this, this connector provides support for nchar and nvarchar data types

With SQL Server-Hadoop Connector, you import data from:

  • Tables in SQL Server to delimited text files on HDFS
  • Tables in SQL Server to SequenceFiles files on HDFS
  • Tables in SQL Server to tables in Hive*
  • Queries executed in SQL Server to delimited text files on HDFS
  • Queries executed in SQL Server to SequenceFiles files on HDFS
  • Queries executed in SQL Server to tables in Hive*

  • With SQL Server-Hadoop Connector, you can export data from:

  • Delimited text files on HDFS to SQL Server
  • SequenceFiles on HDFS to SQL Server
  • Hive Tables* to tables in SQL Server
    * Hive is a data warehouse infrastructure built on top of Hadoop (http://wiki.apache.org/hadoop/Hive)
  • ..."

    Not sure how/if I can use this, but since I've been keeping a wider eye open for Hadoop stuff, I thought it interesting...

     

    Related Past Post XRef:
    Do you Hadoop? Angel has your links, news and resources round-up...

    No comments: