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

Choosing the Right SSID for Your Network

Attracting attention, whether through a default or funny Wi-Fi name, could lead to a security issue.
Microsoft Outlines Latest Security Efforts at Ignite

In the wake of last year's CrowdStrike incident, Microsoft has worked to publicly rehabilitate its security image through new initiatives and public commitments to improve. That push continued this week at Ignite, where Microsoft announced a handful of new security tools and updates.
Nadella on Copilot: 'Major Platform Shifts Are in the Air'

As should be no surprise, Copilot took center stage during Microsoft CEO Satya Nadella's keynote speech to open Microsoft Ignite 2024.
Azure AI Foundry Revealed at Microsoft Ignite

Microsoft is consolidating its Azure generative AI tools into a unified platform named Azure AI Foundry.
Microsoft Bolsters Fabric at Ignite

While Fabric has improved in the year since its release, there are still some glaring issues with the platform.