Skip to Content
Author's profile photo Tammy Powlas

SAP BusinessObjects Cloud Data Integration Deep Dive Webcast Notes

Note:

This was posted on SCN beta, but beta is going away so I am posting it here

 

This was an SCN webinar last month

 

SAP said “SAP BusinessObjectsCloud is the new name for SAP Cloud for Analytics”

 

/wp-content/uploads/2016/06/1fig_979236.png

Source: SAP

 

The legal disclaimer applies

 

/wp-content/uploads/2016/06/2fig_979155.png

Source: SAP

 

The above is the agenda

 

/wp-content/uploads/2016/06/3fig_979156.png

Source: SAP

 

HANA Cloud platform is the foundation

 

SAP BusinessObjects Cloud is self-service, analytical workflow, mix and mashing, presenting data

 

Digital Boardroom is based on the BusinessObjects Cloud

 

Above shows the positioning

 

/wp-content/uploads/2016/06/4fig_979217.png

Source: SAP

 

How shape, how model the data

/wp-content/uploads/2016/06/5fig_979218.png

Source: SAP

 

The above shows the workflow

 

It was released last year

 

It changes rapidly

 

Every two weeks there is a release

 

Enhancements are at a fast pace

 

Already on the 9th release of the year

 

Where is my data located?

 

/wp-content/uploads/2016/06/6fig_979219.png

Source: SAP

 

Today 5 deployments of BusinessObjects Cloud

 

Go to sapdatacenter.com page for details on how data centers are running


Overview

/wp-content/uploads/2016/06/7fig_979223.png

Source:SAP

 

HCP DBaas offering

 

Empty arrows show remote

 

On-premise – connect to BPC, BW, universes, SAP ECC

 

Connects to local files

/wp-content/uploads/2016/06/8fig_979224.png

Source: SAP

/wp-content/uploads/2016/06/9fig_979225.png

Source: SAP

 

Users will see only what they have access to see

/wp-content/uploads/2016/06/10fig_979226.png

Source: SAP

 

Steps from an end user perspective

/wp-content/uploads/2016/06/11fig_979227.png

Source: SAP

 

Remote connection is covered above

/wp-content/uploads/2016/06/12fig_979228.png

Source: SAP

 

Remote reverse proxy to connect to on-premise

/wp-content/uploads/2016/06/13fig_979237.png

Source: SAP

 

Drag data source and it will model..

/wp-content/uploads/2016/06/14fig_979239.png

Source: SAP

 

Install 2 agents; see Harjeet’s blog

 

/wp-content/uploads/2016/06/15fig_979234.png

Source: SAP

 

Drag and drop experience

Understand prompts from universe

BI4.1 SP5 minimum

 

/wp-content/uploads/2016/06/16fig_979235.png

Source: SAP

 

BW online connection is planned

/wp-content/uploads/2016/06/17fig_979240.png

Source: SAP

/wp-content/uploads/2016/06/18fig_979241.png

Source: SAP

Data wrangling, semantic enrichment, geomaps (ESRI)

/wp-content/uploads/2016/06/19fig_979242.png

Source: SAP

 

System provides visual feedback to act on issues

/wp-content/uploads/2016/06/20fig_979243.png

Source: SAP

 

A summary of what have seen during the demo

/wp-content/uploads/2016/06/21fig_979244.png

Source: SAP

 

Rights to a model, dimension

 

/wp-content/uploads/2016/06/22fig_979245.png

Source: SAP

Provide autonomy to end users

Enabling partners/customers to add their own data source

/wp-content/uploads/2016/06/23fig_979246.png

Source: SAP

 

Looking at SAP cloud solutions and non-SAP

/wp-content/uploads/2016/06/24fig_979247.png

Source: SAP

Big effort in data preparation this year

 

Question & Answer

Q: I noticed SDA (Smart Data Access) for traditional database access… so, that will be a link to underlying HCP..

 

A: SDA via HANA is just one way to “access” non-SAP data. indirectly. We plan for a direct data acquistion approach as well.

 

Q: Slide #10 showed SAP C4A and Browser separately with differeent data sources. What is the difference between Browser and SAP C4A?

A: Browser is the client which users will access BusinessObjects Cloud. Both content and data are shown directly within the Browser client

 

Q: Can we share the Lumira Story Boards or Design Studio dashbaords to this cloud ?

 

A: It is possible today to share a Lumira “dataset” which the data can be acquired into BusinessObjects Cloud as a data acquistion approach

 

Q: Then we need to redoo the visualizations and storyboards all over again for the same data …if we want to use the Cloud ?

 

A: There is no migration path for on-prem created content into BusinessObjects Cloud

 

Q: Question about compression

 

A: For data acquistion concept, there is no inbuilt data compression techniques used. Data volume is always under heavy consideration, thus as best practices, it’s recommended to carefully choose the specific metdata you need in order to build your visualization

 

Q: Can I connect to Successfactors from BI Platform? on-premise

 

A: BusinessObjects Cloud can conect to relational Universes (unx) from BI platform and acquire data. BOC does support directly connecting to SucessFactors, and acquired that data you need into BOC

 

Q: Can you elaborate on how SBOCloud specifically enhances user autonomy vs. its predecessors?

 

A: Best to have a conversation with Paul on this: But user autonomy/agility is described in this webinar under the concept of data acquistion. It is about bringing “agilty” to data analysts that want to play wiht the data, be able to explore the data, basically an agile modelling experience. Agility also comes withn we bring the data in smartly, so that users for users that dont’ want to do modelling, can simiply start playing with BOC and building visualizaitons quickly

 

Q: Not sure this question got answered: Is there a developer sandbox specifically for SBOCloud? Thank you!

 

A: There is no developer sandbox per say. But you can try out BusinessObjects Cloud via two method: trial account and POC account.

 

Q: What’s about bw connection? is still the process required to set up hana cloud connector etc. in orde rto connect to a remote system or will a direct access be possible?

 

A: it is possible to connect to BW today via data acquisition. To enable the data acquistion process, customer needs to install and configure two simiple components called the BusinessObjects Cloud agent and HANA Cloud Connector. You can find more information on the online help: https://cp.hana.ondemand.com/dps/d/preview/06d2c3deddfc425e920f2448e4f1e654/release/en-US/frameset.htm. As for online connection to BW, that is planned for later this year in Q4 as first release

 

Q: Connect to OData?

A: This is on the roadmap

 

Q: can we connect to an on-premise hana system directly or do we need a hcp gateway etc.?

A: You can connect to HANA on-premise today via a reverse proxy setup.

 

Q: Is there a way to setup SSO with remote connection to on-premise HANA?

A: Yes, SSO is posssible to on-prem HANA via Reverse Proxy in conjunction with SAML-2 complaint identity provider

 

Q: what’s about write-back functionality of planning data to on-premise system?

A:  write-back is possible for Planning, as part of the data acquistion workflow. This is on write-back capability possible for online connection to SAP backends

 

Q: Another user question: Are the “HANA” modeling features in BOC used with remote connect intended for business users, or only technical? Just trying to figure out the vision from SAP’s perspective

A: Connection to on-prem sources like HANA has no modelling concept. It only applies in the case where you are bringing data into BusinessObjects Cloud. Reason is because when connecting  on-premise SAP backends like HANA, the modelling is already done on the SAP backend, so BOC will simply leverage that

 

The modelling concepts today in BOC are geared for the data analysts workflow.

 

Q:  Do we have plans to support NULL values in the data set?

 

A: Yes, this is one of the areas of improvement which Dev team will plan to address

 

Q: Adrian mentioned data preparation features are used “only when the data is acquired”. Can you explain what that means? In other words, is this the same thing as uploading data via the browser or something else?

A: Correct. There are two connectivity methods today: online connection and data acquistion. For online connection, we support connection to SAP sources (HANA today, BW and S4 is planned) . Connection to SAP backends as mentioned before, we will leverage the underlying views/queries directly. Data prep and data modellig concepts as explained in webinar today would only apply for the data acquistion concept (i.e. bringing that data into Cloud)

 

Q: when loading data, can you use a kind of ‘delta’ mechanism or are these always full loads ? Are there differences depending on the source (ERP,BO, non SAP, …)

A: delta loading of acquired data is not possible today. But development team is investigating the concept. No roadmap timeline yet

 

Q: Will IE be supported?

A: No IE support yet. No timelines o this at the monment, but some discussions are looking towards Microsoft Edge instead, due to similarities with Chrome

 

Q: Can we push data from BOCloud into HANA or HCP? If so, where can we find more information about this?

A: Yes, you can bring data into BOC (which basically runs on top of HCP). This is via the data acquistion worfklow as explained by Paul today

 

Q: Can we write back to HCP on real time basis to control edge devices in IoT scenarios

 

A: NO write back is supported to HCP as DBaaS, or HCP which BOC tenant is running on

Write back to BPC is supported for Planning workflow in BusinessObjects Cloud via data acquisiton

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Wonderful Article! It clears many questions!

      I have one question: How does SAP plan to manage UNX connections in the future?

      Right now we would need to install (sell) an on-premise BO to install the universe that then connects with BO Cloud. This is a terrible solution and can only be temporary.

      Many Thanks!

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Mohammad - thank you for reading and replying

      I don't have any information on how SAP plans to manage UNX connections; I attended a similar session last month at ASUG Annual Conference - I haven't posted my notes there yet. 

      Author's profile photo Sandip Das
      Sandip Das

      Hi Tammy,

      Couple of customers are asking how do they connect SQL DB to BOcloud (aka C4A). Are we working on any connector for this? The best scenario will be if they have a standard connector to non-SAP DBs.

      If you have any update please share.

      Thanks,

      Sandip

      Author's profile photo Henry Banks
      Henry Banks

      Hi Sandip,

      Yes BOCloud has an SQL connector to MS SQL 2008, 2012, 2014 & MySQL5 .

      Please note that an an SAP employee you should ask in our internal JAM group for the same, instead of SCN which is a public forum.

      Henry

      Author's profile photo Henry Banks
      Henry Banks

      Hi Mo,

      interesting point - i can understand your frustration if you trying to position BOC as a way of phasing out BIP and replacing the old stack  .. for sure, it's not a substitute technology having a migration path...

      the Universe semantic layer is proprietory to the BusinessObjects platform, in the same was as BEx Queries are to SAP BusinessWarehouse, or as a Graphical Calc

      View is to HANA. so let's be honest - there is a heck of a lot more intelligence happening in those layer than just a data connection strategy.

      As you know, it's not easy modelling "intelligence" when going direct-to-data using DB table connectors ... so the decision would be: which modelling environment are you going to chose?  not forgetting BOCloud has its own too!

      Regards,

      H

      Author's profile photo Former Member
      Former Member

      Hi,

      Is it possible to watch the webinar afterwards?

      Regards

      Daniel

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I searched Youtube and found a more recent recording here: https://www.youtube.com/watch?v=Ja2GM7p-RZo

      Author's profile photo Former Member
      Former Member

      can we connect to SAP ECC tables in sap business objects cloud.If Yes, what is the procedure

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Rupa - the only tool that can connect directly to ECC tables is Crystal Reports.

      You can use embedded BW inside your ECC if you are above enhancement package 5

      I recommend creating a new question on this topic