Open Source Drupal 7 CMS Gains Interoperability with Microsoft SQL Server

Microsoft this week showcased some of its interoperability accomplishments reflected with the release of the open source Drupal 7 content management system.

Drupal 7, produced by Drupal Association volunteer coders, now works with Microsoft's SQL Server relational database management system products and is distributed through the Microsoft Web Platform Installer. It's also distributed from the Drupal Web site and Commerce Guys, an organization dedicated to Drupal-based e-commerce apps. Drupal is an open source, PHP-based CMS for creating Web sites, blogs, and e-commerce sites.

Microsoft has also included Drupal 7 in its WebMatrix tool, which was released Jan. 13. WebMatrix is a free Web site creation tool that supports a number of open source applications integrated with Microsoft's IIS 7.5 Express Web server.

Version 7 of Drupal was released Jan. 5. It has been about two-and-a-half years since the last major release, according to Jim Taylor, owner of Columbus, OH-based Rooty Hollow LLC, in a Microsoft-produced video. Rooty Hollow provides development and IT backend support services. Taylor, one of the volunteer developers on the Drupal project, noted that the user interface of Drupal 7 has been improved and the database layer under the system was rewritten. The team added a new PHP Data Objects (PDO) layer and the CMS now works with multiple databases, both open source and proprietary.

Support for Microsoft SQL Server 2005 (and later versions) in Drupal CMS got rolling last year, according to a blog post by Jean Paoli, Microsoft's general manager for interoperability. It culminated in a SQL Server Driver for PHP 2.0 with PDO support release, which Microsoft made available in August. Those who use the free SQL Server Express edition with Drupal can tap into the database management system's business intelligence and reporting capabilities, according to Paoli.

Drupal runs on Apache or Microsoft IIS Web servers and supports PHP 5.2 or higher. In addition to working with SQL Server, Drupal integrates with MySQL 4.1 (or higher) or PostgreSQL 7.4 (or higher) relational database management systems.

Four new Drupal modules were created for administrators and developers. The modules include Bing Maps, Silverlight Pivot viewer, Windows Live ID and an OData module. Schakra and Mindtree developed the modules using funding from Microsoft.

Paoli also said in the blog post that Microsoft is supporting Drupal on Windows Azure, which is Microsoft's Internet cloud platform. "We're working, for example, on bringing the full elasticity and scalability of Windows Azure cloud to Drupal and other PHP applications," Paoli stated. Drupal 7 can be deployed to Microsoft's cloud-based operating system using a tool called the "Windows Azure Companion."

About the Author

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

Featured

  • laptop displaying cybersecurity and financial charts, next to a locked safe and stacked gold coins

    Majority of Districts Lack Dedicated Cybersecurity Funding

    According to a recent CoSN survey, most school districts (61%) do not have dedicated funding to keep networks and data secure, instead relying on general funds to pay for cybersecurity efforts.

  • The AI Show

    Register for Free to Attend the World's Greatest Show for All Things AI in EDU

    The AI Show @ ASU+GSV, held April 5–7, 2025, at the San Diego Convention Center, is a free event designed to help educators, students, and parents navigate AI's role in education. Featuring hands-on workshops, AI-powered networking, live demos from 125+ EdTech exhibitors, and keynote speakers like Colin Kaepernick and Stevie Van Zandt, the event offers practical insights into AI-driven teaching, learning, and career opportunities. Attendees will gain actionable strategies to integrate AI into classrooms while exploring innovations that promote equity, accessibility, and student success.

  • smartphone with a glowing lock and shield icon at its center, surrounded by floating security symbols like a fingerprint, key, and authentication checkmark

    Jamf to Acquire Identity Automation, Pairing Identity and Device Management in One Platform

    Apple mobile device management company Jamf has announced it will acquire Identity Automation, a provider of identity and access management (IAM) solutions for K-12 and higher education.

  • digital illustration of Estonia with glowing neural network-like connections spreading across the map

    Estonia to Roll Out ChatGPT Edu for all Secondary Schools

    In a nationwide artificial intelligence program dubbed "AI Leap 2025," the country of Estonia plans to provide free access to leading AI applications for all secondary school students and teachers. The initiative will launch with a rollout of ChatGPT Edu to 20,000 high school students in grades 10-11 and their 3,000 teachers, beginning Sept. 1.