Microsoft Releases Hadoop Connector CTPs for SQL Server -- Redmondmag.com

Microsoft Releases Hadoop Connector CTPs for SQL Server

By Kurt Mackie
08/25/2011

Microsoft released two community technology preview (CTP) test versions of its Hadoop connectors today, one that works with Microsoft's current flagship SQL Server and other with its data warehouse product.

One of the connectors is designed to work with SQL Server 2008 R2 and is currently available for download here as a CTP test release. The other connector is for SQL Server Parallel Data Warehouse (PDW), but there's no download page. Microsoft's PDW customers can get a copy of the Hadoop connector CTP release for PDW by requesting it through Microsoft's customer support service, according to Microsoft's announcement.

The announcement indicates that the Hadoop connector for SQL Server 2008 R2 is also compatible for use with SQL Server code-named "Denali," Microsoft's next-generation relational database management system. Denali is currently available as a CTP3 release.

Both connectors are designed to enable two-way movement of data between the systems, including structured and unstructured data. The SQL to Hadoop (SQOOP) command-line tool is used by the connector to transfer data from the Hadoop File System to SQL Server. The connector also uses the bulk load/extract tool in PDW to quickly import or export data.

Microsoft had signaled its planned rollout of the two Hadoop connector CTP releases earlier this month. Hadoop is an Apache project-fostered open source framework for running applications on clusters using commodity hardware. Organizations might use Hadoop to run "big data" business intelligence-type operations. Practical applications for using Hadoop might include supply-chain management, sales analytics, call-center record analysis, Web event analysis and financial reporting.

Microsoft's announcement hinted that there will more to come next year on such big data integrations. The company already offers two other connector solutions: The Microsoft Informatica connector for SQL Server PDW and the Microsoft SAP Business Objects DI connector for SQL Server PDW. Both of those connectors are currently available by contacting Microsoft's customer support services.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.