Monday, April 21, 2008

A New Solution - SQL Server Connectivity Using Google!

Panorama Introduces New Enterprise Business Intelligence Solution for Google Apps - Cloud Computing Analytics for Business Productivity

New Support for SQL ServerTM Analysis Services Allows Enterprise Customers to Use
Google Docs to Analyze, Report, Visualize Their Corporate Data

TORONTO, ON (DATE) – Fresh from announcing their addition of Business Intelligence (BI) to Google Docs, Panorama Software, a global leader in Proactive Business Intelligence, has revealed a new solution for the enterprise level market. The beta version of its newly developed functionality for Google Docs will allow the support of its first enterprise data source – Microsoft SQL ServerTM Analysis Services, the most pervasive OLAP solution in the industry. This is the first of what will be many enhancements and new functionalities that Panorama will roll out for Google Docs in the next few months.

Microsoft Excel has been known to be the only spreadsheet tool capable of providing BI capabilities in the form of analytics and reporting for enterprise level data. By adding support for SQL ServerTM Analysis Services, enterprise companies can now use Google Docs, the most powerful Software as a Service (SaaS) based spreadsheet in the world with its strong collaborative capabilities, to get more out of their enterprise data in new and flexible ways.

Companies have long wanted a fresh way to analyze corporate data using a spreadsheet application, while also enjoying advanced collaboration, mobility and access-from-anywhere functionalities. With the new support for SQL ServerTM Analysis Services by Google Docs with Panorama Analytics, enterprise customers have exactly what they have been asking for.

“Enterprise customers that are using BI systems are looking for new ways to collaborate, share information and insights, work from anywhere, and better liaise with customers and suppliers,” said Oudi Antebi, Vice President of Marketing and Strategy for Panorama Software. “Leveraging the power of Google Docs in all those areas will add tremendous new value for them. We have received many calls from companies asking us to add native support to their enterprise systems from our newly announced solution for Google Docs, and now they have it.”

The new enhancement is being made available as a beta version and requires registration on Panorama’s website ( Two levels of integration will be offered; free and fee-based options. The solution will be free for customers that upload their data into Panorama’s PowerApps platform for Google Docs in the form of an offline cube file. Panorama will offer a unique application from SDG Computing as a download to help customers easily create and upload the offline cube files necessary for the free version.

“Enterprise customers increasingly want to use analytics in a variety of ways,” said Tim Peterson of SDG Computing. “Until today, the only spreadsheet option they had was Excel. Now, with Google Docs powered with Panorama’s unique capabilities, enterprise users have a new and highly powerful option for performing analytics and reporting.”

The solution will also be offered as a premium, fee-based service that will enable a live connection to SQL ServerTM Analysis Services. For the premium version, Panorama is partnering with Data Intelligence Ltd.

“As a leading provider of hosted solutions for SQL ServerTM Analysis Services, we are pleased to be partnering with Panorama on this solution,” said Mike Askew, Director of Data Intelligence Ltd. “This partnership will allow Panorama to offer its Google customers an end-to-end solution that provides both the creation, hosting and front-end capabilities of fully scalable Business Intelligence solutions.”

Panorama Analytics for Google Docs, launched on March 19th, represents an advanced analytics, reporting and data visualization solution for Google applications. Focused on pivot table and charting functionality, Panorama’s solution is a high-value capability that makes spreadsheets in Google Docs and dashboards in iGoogle even more useful. Users at both the enterprise and small-to-medium business levels will benefit from the enhanced ability to drill into data to gain valuable business insights quickly, resulting in better decision-making in the short term, and more effective strategic planning and performance in the long term.

Users of SQL ServerTM Analysis Services can register now for the beta version of Panorama Analytics by visiting For more information about Google Docs, please visit; to learn more about Panorama Software, go to


Anonymous said...
This comment has been removed by a blog administrator.
Panorama Software said...

Thank you for posting your comment! We have actually officially launched the first beta-level phase of this initiative and hope to be ready to launch it to the public in the near future. If you would like to participate in the beta program to help test out the new connectivity to SQL Server, please feel free to contact us.

Anonymous said...

I tried 4 month ago to participate in the beta program and signed up, but was ignored. The link to sign up today leads to a dead end.

Anonymous said...

its look quite good but i didn't see if it is possible to make an average or others functions in each category. in pivot of MS excel one can chose if to sum or to average or whatever.

Shimon Shlevich said...

It's easy to sum up or apply other formula on columns or rows in Panorama Analytics. Select the columns/rows you'd like to apply formula on by holding the Ctrl key and clicking the captions. Once selected choose the desired formula from the context menu (click the small triangle for the menu).