SQL Server 2012 RC0 is Here – will work with Hadoop by 2012

Microsoft SQL Server 2012 Release Candidate (RC) is out, and it’s available for download:

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

Key Capabilities
  • Rapid data discovery with Power View and PowerPivot
  • Managed Self-Service BI with SharePoint and BI Semantic Model
  • Credible, consistent data with Data Quality Services
  • Robust DW solutions with Parallel Data Warehouse and Reference Architectures

Last month, Microsoft released MS SQL Server Connector for Apache Hadoop:

http://www.microsoft.com/download/en/details.aspx?id=27584

The Hadoop Connector is Sqoop-based, and is designed to facilitate efficient data transfer between SQL Server 2008 R2 and Hadoop.

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
  • result of queries executed on SQL Server to delimited text files on HDFS
  • result of queries executed on SQL Server to SequenceFiles files on HDFS
  • result of queries executed on SQL Server to tables in Hive

Note: importing data from SQL Server into HBase is not supported in this release. 

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

 

Technologist, parallel entrepreneur. Interests: travel, photography, big data, analytics, predictive modeling.

Tagged with: , , , , ,
Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: