BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: BI + Analytics conference: Aug 9.

Business Objects integration with salesforce.com


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
bo_master
Forum Member
Forum Member



Joined: 19 Apr 2009

Posts: 4



PostPosted: Tue Apr 21, 2009 8:50 am 
Post subject: Business Objects integration with salesforce.com

Can any body guide me about Business Objects XI 3.1 integration with salesforce.com.
Back to top
TL1GT228
Senior Member
Senior Member



Joined: 01 Oct 2008

Posts: 51



PostPosted: Thu Apr 23, 2009 5:57 pm 
Post subject: Re: Business Objects integration with salesforce.com

The easiest way would be to use a 3rd party tool that has a pre-built connector to the salesforce.com - MetaMatrix, Informatica, Relational Junction, etc.

http://sites.force.com/appexchange/results?filter=a0L30000001Qp7TEAS&sort=6

Otherwise, you need to create a connection to SFDC - ODBC, JDBC, etc.

If you are building complex reports, I would recommend caching/ETLing the sfdc data locally first, then building BOBJ/reports on top of the local database.
Back to top
kmcmanus
Principal Member
Principal Member



Joined: 01 Sep 2005
ASUG Icon
speaker.gif
Posts: 132



PostPosted: Thu Feb 19, 2015 11:02 am 
Post subject: Re: Business Objects integration with salesforce.com

When it comes to integrating BusinessObjects into Salesforce.com there are 3 areas of connection to address

1) the integration of the data for ETL and reporting using system accounts - Using the various drivers available for both SAP Data Services and the Information Design Tool (IDT Universe) it is straightforward to install a driver using a system account to query the data in SalesForce.com. Some drivers are better than others when it comes to providing the metadata needed to represent the tables and columns needed for the Universe design so test out the latest from Samba, Data Direct, and RSS Bus. at our company we have licensed Relational Junction from Sesame Software to be part of our products as ti provides some key advantages that we label as data caching which is more efficient then bulk data loads between cloud and on premise data sources.

2) The Integration of the logged in user - in order to get the data using the account of the user that is logged in using the security rules that have been implemented in SalesForce.com a query services needs to use the session of the user in real time. To address this need we developed a self service query tool called Touch that can pickup the session using the appropriate SalesForce.com API's so that the data returned via the web services has only the data the user is supposed to see but in a format that can be used in various tools including Webi, Dashboards and Design Studio. If you have a team of developers familiar with the SFDC API's this can be developed internally. Note these API's change often so don't underestimate the effort to keep them working.

3) The integration of the reports themselves into the user interface of SalesForce.com completes the picture so that users only need a single interface to do their jobs. They goal is a user can login to SalesForce.com from any device and have an effortless view of reports, graphs , dashboards and they don't have to jockey between SalesForce.com and their LaunchPad. If the user is only logging on to Salesforce.com through their desktop while on a SSO enabled network (i.e. Windows AD) there is some linking that can be done through a SSO enabled link to opendoc for meeting some basic needs. If users want access to a complete report list in a Tab or screen, report parts integrated into pages, SSO accross devices and without VPN or want to see both SalesForce.com reports and Webi reports in the same report list then click on the add above for the LaunchWorks SalesForce Integration Kit for SAP BusinessObjects aka Report Launch.

If you have other ideas, solutions or needs please post them here or contact me. We live and breath BOE Integration with Salesforce.com and want to know what people want and need to make it happen.

_________________
Kevin McManus
www.LaunchWorks.com
1-877-857-7407

Latest Blog Posts
• 2017-06-19 The Building Blocks of Embedded Analytics
• 2016-01-28 Embedding SAP Analytics into SalesForce, Sharepoint or any cloud application
• 2015-04-29 IF AT FIRST YOU DON’T SUCCEED,TRY,TRY AGAIN!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0102 seconds using 17 queries. (SQL 0.0027 Parse 0.0002 Other 0.0073)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo