Overview of SAP BI 4.x Integration Option for Microsoft SharePoint
The integration option for SharePoint software (aka IOMS) enables SAP Business Intelligence (BI) solutions to work with the SharePoint software. In this blog post I will walk you through few of the key IOMS features in BI 4.x.
To start, here are some of the selected key highlights of IOMS
- Free download through service market place
- Deployed as a SharePoint Site template IOMS, IOMS provides instant access to content stored in BusinessObjects from SharePoint with native SharePoint look and feel.
- Provides Authentication/SSO support and allows users to search, manage, view and interact with BusinessObjects content from the SharePoint environment.
- Includes out of box webparts for extending other SharePoint sites with BusinessObjects reports, dashboards, and more.
- Supported platform: Microsoft SharePoint Server 2007 (64 bit), 2010, and 2013
- Note: IOMS for SharePoint 2013 is supported as of 4.1 SP03
During installation, the installer will deploy a BusinessObjects site template in your SharePoint Server allowing instant access to the BusinessObjects content directly.
When you access your IOMS portal URL (e.g. http://<machine_name>:80/), you will see the SAP BusinessObjects logon screen. Users can setup SSO to skip the logon page using their Active Directory, LDAP, or BusinessObjects Enterprise credentials.
Upon logging in, you will see a pre-deployed homepage composed of 4 main sections: Announcement, My Favorites, Recently viewed, and Recent Searches.
For those of you familiar with BI launch pad, the “Recently Viewed” webpart is equivalent to the “My Recently Viewed Documents” widget in the BI
launch pad landing page. The BI contents within IOMS are synchronized with your BusinessObjects servers where any changes you made in IOMS will
be reflected immediately in BI launch pad.
The BusinessObjects SharePoint site template is designed to provide a native SharePoint user experience. The familiar look and feel and navigation experience accelerate user adoption as users can move seamlessly from the IOMS to other SharePoint sites without having to change their basic working patterns or behaviors.
The deployed BusinessObjects template comes with 3 main tabs: SAP BusinessObjects, Browser, and Page. Within the Browser tab, you can navigate, manage, and view the BI content within SharePoint. The “Page” tab allows you to easily customize the homepage using the out of box BusinessObjects webparts. I will cover more on this in the later part of the blog post.
The report (e.g. Crystal Reports, Web Intelligence reports, etc) can be viewed directly within the webpart (e.g. My Favorites). You can perform similar capabilities such as printing, refreshing, and interacting with the reports with the IOMS viewers.
The “Inbox” and “Report Repository” drawers are equivalent to BI launch pad’s “My Documents” and “Folders” drawers.
The close integration with SharePoint’s native functionalities includes the breadcrumb navigation allowing users to jump straight to a specific folder
without having to navigate through the folder hierarchy.
IOMS also provides flexible site searching option allowing users to search just the IOMS site or the IOMS site plus all the other SharePoint sites. When searching just the IOMS site, the contents returned are identical to the contents returned if you were to do a search within BI launch pad. Within the search result page, you can also view or manage the report directly via the context menu.
Within the “SAP BusinessObjects” tab, you will find functionalities such as “New”, “Action”, “Upload” menus or Category View mode which are similar
what you would see in BI launch pad.
The schedule option in the context menu also allows you to schedule and manage the BI reports within IOMS.
One of IOMS’s key functionalities is the ability to customize your landing page by enhancing other SharePoint sites by using the BusinessObjects
webparts that comes out of box. These webparts allow you to
- Viewing and interacting with Crystal Reports, Xcelsius (Dashboard Design), and Web Intelligence
- Opening Office and PDF documents
- Browsing the BusinessObjects repository
- Searching and displaying search results from BusinessObjects
- Helpful units for recent views and recent searches
It’s important to note that IOMS is meant to be used by the end users. The administration tasks (e.g. starting and stopping servers) are still to be done within CMC.
- IOMS Installation and Administration Guide
- IOMS Getting Started Guide
- Official Product Tutorials – Integration Option for Microsoft SharePoint Software
Is there a good document for using the SAP Analytics tools (like IDT) to report against the data/records held within SharePoint..?
oData looks like the only way to go if you want to write a report on "X number of documents" held in SharePoint by User X.
Any better ways to do it via SharePoint Integration with SAP BO-BI 4.1...?
I would be glad if we could be of any help as we specialises on SAP offerings and you can reach me to discuss how we can help you at firstname.lastname@example.org
Look forward to speak with you.
Could anyone direct me to integrate Microsoft Office 365 SharePoint with BusinessObjects 4.x?
IOMS does not support Sharepoint Office 365, it is a roadmap item
Thanks for the info. Just wanted to check if this is still a roadmap item? Thanks in advance.
We are also interested in IOMS support for Sharepoint Office 365 and would appreciate an update on its roadmap status.
I've also not been able to figure out how to connect an Adaptive Job Server SMTP to Office 365. If it's a support issue, I would also like to see it resolved in future patch of SAP BI.
I am with Dallas on this. Any updates on the roadmap for this?
Thanks for the nice document.. i got a quick question ..could you please let me know whether this integration supports version management like regular share point or not?.
No, it does not. the BI documents continues to reside in the BOE repository
We want that the end-users access the reports in Sharepoint for viewing and save their own versions (e.g. Analysis for Office) into their own folder but not to the public folder.
And they should not schedule any kind of reports.
Is it possible? Any hints or detailed documents about this topic would be very appreciated.
Is IOMS also compatible with SharePoint 2016? If not when would it be possible to work with SharePoint 2016?