LOGIN | REGISTER NOW | SUBSCRIBE
 

Next version of SQL Server creates business intel solutions from transactional data


By David Worthington
Email    print   
October 6, 2008 —  The next version of Microsoft SQL Server, code-named Kilimanjaro, will let end users build managed business intelligence solutions from transactional and stored data.

At the Microsoft Business Intelligence Conference in Seattle today, the company is announcing Gemini, an effort to integrate self-service analytics into its data platform. While the Gemini component in the next SQL Server release will let users tailor business analytics to suit their needs, IT will retain control over data access and sharing, said Fausto Ibarra, director of product management for SQL Server.

Gemini will include master data management (MDM) technology through which “IT can make certain authoritative data sources available,” Ibarra said. Data sources could include any JDBC- or ODBC-accessible database, as well as SAP line-of-business applications.

Microsoft acquired the MDM technology via its June 2007 purchase of Stratature.

Gemini will also access transactional data from Web services and correlate it in real time. According to Ibarra, data will be processed in memory, with capability for processing up to 10 million rows per second.

Microsoft Excel will be the rich client for Gemini; SharePoint and Excel Services will provide for remote access and peer ratings of reports. Reports will likewise be configurable as data services, Ibarra said.

Traditionally, “[business intelligence] has served only about 20% of an organization,” said Kristina Kerr, senior product manager for Business Intelligence at Microsoft. “There are still gut-feeling decisions being made.”

She added that “elitist” tools have prevented the “democratization”’ of business intelligence and that Microsoft would make it more accessible.

Customers will be given access to a preliminary version of Gemini via a community technology preview (CTP) within a year, Ibarra noted.

In that same time frame, the company will release CTPs of business intelligence appliances that Ibarra said would be scalable for data volumes in “the tens of hundreds” of terabytes.

The appliances are the fruit of Microsoft’s acquisition of DATAllegro, a maker of data warehouse appliances, in July.




Related Search Term(s): business intelligence, SQL, Microsoft


Share this link: http://sdt.bz/32934
 
Most Read Latest News Blog Resources
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
Top five apps to manage your workload
Web applications offer new ways to track your “to-do” lists
From the Editors: Node.js is unruly, but that’s where the fun is
The time to get involved with Node.js is now; Hadoop is about to break its own barriers
Zeichick’s Take: Looking for the best of the best of the best
It's time once again for readers to send in nominees for the SD Times 100
Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter


Add comment


Name*
Email*  
Country     


  • Comment
Loading




close
NEXT ARTICLE
Microsoft aims for top of business intelligence market with SQL Server release
SQL Server now has PowerPivot, a self-service analytics components that works with both transactional and stored data Read More...
 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 

Download Current Issue
FEBRUARY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?


 
blogs tab
Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
02/07/2012 11:57 AM EST

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
02/04/2012 01:57 PM EST

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
02/03/2012 12:17 PM EST

Facebook claims hacker cred
Facebook's SEC S-1 filing form includes a short essay on the Hacker Way by Mark Zuckerberg himself.
02/02/2012 08:26 AM EST

Ryan Dahl steps down
Ryan Dahl, creator of Node.js, steps back from his position as gatekeeper for the project.
02/01/2012 04:58 PM EST

Bloomberg opens its API
Bloomberg's APIs could lead to a future standard for accessing market data.
02/01/2012 04:41 PM EST

 
Events calendar tab
Cloud Connect
2/13/2012 to 2/16/2012
Santa Clara
TechWeb

SPTechCon: The SharePoint Technology Conf.
2/26/2012 to 2/29/2012
San Francisco
BZ Media

RSA Conf.
2/27/2012 to 3/2/2012
San Francisco
RSA

IBM Pulse Conf.
3/4/2012 to 3/7/2012
Las Vegas
IBM Tivoli

Game Developer Conf.
3/5/2012 to 3/9/2012
San Francisco
TechWeb