Overview – SAP BusinessObjects BI OnDemand for Salesforce.com
February 25th, 2010
SAP just released their BusinessObjects™ BI OnDemand solution for Salesforce.com which is a subscription-based, SaaS solution empowering sales professionals to explore, report and share data from Salesforce.com. It looks like SAP is trying to play nicely with Salesforce.com and is positioning this product as a BI alternative to actual reporting in Salesforce.com. There was no bashing of Salesforce.com in the text and the solution is AppExchange certified.
For companies concerned about the speed of reporting or size of Salesforce data sets, SAP BusinessObjects BI OnDemand provides a preconfigured data warehouse that can be implemented in as little as a day. The data warehouseprovides a duplicate set of data that can dramatically improve reporting time and speed information delivery.
Since they offer a free trial and I have a few years of SAP experience I thought I’d give it a spin. The signup process was pretty painless and after logging in I set up my connection to a production org (looks like sandbox connections are not an option).
The entire application is essentially a series of Flex applications. After logging into my org I was presented with the following screen displaying the metadata for the org and allowing me to drag and drop fields from any object to create a dataset.
It then presents you with a preview of the dataset and the associated SOQL query. Once you confirm the query and save the dataset the data is imported from your org into the warehouse’s datastore.
You can then see your newly created dataset in the list of available datasets.
After clicking on the dataset you are presented with the main UI for that dataset. Your options here include:
- View data in the dataset
- Perform ad-hoc queries against the dataset
- Explore the dataset to slice and dice it to create more specific datasets or visualizations
- Share the dataset with other uses (similar functionality to Google Docs sharing). I also noticed that you can share the actual web service address.
- Download the data in CSV format
- Combine with other datasets for more detailed reporting
- Duplicate the dataset
- Delete the dataset
With the Explore tab you can drill down into your data and run various scenario to create your own dataset and save results as a visualization that you can share or display with an iframe.
The product has a ton of features (it’s based off of Crystal Reports which SAP bought in 2007) and I only had time to try a few. If you are looking for a simple way to access and externally report on your Salesforce.com data, you might want to give SAP’s BusinessObjects™ BI OnDemand solution good look.
Categories: SAP, Salesforce
Hi Jeff,
This is fantastic, appreciate the review and screenshots.
One question: did you happen to note whether the same hosted Business Objects environment can be configured to accept data from other sources, allowing customers to create a true multi-source data warehouse?
Thanks!
Brian
I just looked and there is an option to upload a file (it didn’t say what type) and one to “Create from Query” (see the first screenshot). It gave me a message, “Please log in as an OnDemand user to add a dataset from Explorer. ” HTH
jeff, looks great. Do you have a sense of how this is different from crystalreports.com? We’ve used that with some success over the last couple of years. any sense of pricing?
Sorry, unfortunately I don’t. I haven’t used the hosted version of CrystalReports before.
Kevin — in time, it will have most of the crystalreports.com features but will also have the new features of bi.ondemand.com including the features that Jeff showed (data sets, explorer, etc). Right now, it already has the SSO and the ability to upload Crystal Reports and run them seamlessly against your Salesforce.com data. If you already have crystalreports.com, you should talk to your sales rep — they should be able to set you up with a trial bi.ondemand.com Essential edition account (the Essential edition would give you the folder/user group mgmt that you have in crystalreports.com).