1cx.jpg

Source: SAP

 

2cx.jpg

Source: SAP

Agenda is shown above

3cx.jpg

Source: SAP

Left shows import data connections, the right shows live data connections

4cx.jpg

Source: SAP

Who can create connections?  See the roles above

You can share connections with the team

Import Data to the Cloud

5cx.jpg

Source: SAP

 

Importing & storing it in the cloud

Updates can be scheduled

Limit on connection - 8K rows 100 columns

6cx.jpg

Source: SAP

On premise system, use the Cloud Connector and the SAP Cloud Agent

 

Connect to Live Data

 

7cx.jpg

 

Source: SAP

Data sources are above

Create framework, metadata, then goes to firewall of connection, and data does not leave firewall

Do not have limit of 8K rows

8cx.jpg

Source: SAP

Runs on external server to get the metadata

This is the most known method

9cx.jpg

 

Source: SAP

No external server needed

Some configuration needed on browser; install certificate

 

10cx.jpg

Source: SAP

How to connect to several environments - BW Development, etc

Reverse proxy - redirect browser to as many paths / resources as needed

Direct - each system has a certificate

11cx.jpg

 

Source: SAP

Pros and cons are shown above

No additional server, better performance - direct is supported by SAP

 

Sometimes customers run into problems with reverse proxy and think something is wrong with SAP Analytics Cloud; usually it is reverse proxy problems

12cx.jpg

Source: SAP

See data sources/versions that can do the Live Data Connection

You can go to lower versions with support packs applied SAP Note 2541557 (BW) https://launchpad.support.sap.com/#/notes/2541557

13cx.jpg

Source: SAP

Some final considerations are shown above

 

 

 

 

Q&A

Dear SAP, will it be possible to connect SAP Data Services (former BODS) to SAC?

 

At the moment this data would be accessed via an SAP Universe stored on the Business Intelligence Platform per https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/3600be69a97a4b2888e73dcebbfa8ace.html

 

 

 

Hi, what are the risks if we don't install an SSL certificate in the direct connection scenario? Considering that the exposed data is metadata only.

SAP Analytics Cloud enforces the requirement for an SSL Certificate for direct connections so it is not optional.

 

 

 

Is connection with some of application like PeopleSoft (oracle) is possible with OData Connection ?

 

 

Can we have both reverse proxy and direct connection for a single SAC tenant?

 

The recommended approach is Direct connection which can be routed through a reverse proxy if you need access from a browser outside the firewall per https://blogs.sap.com/2017/04/10/direct-live-hana-connections-in-the-internet-scenario/

 

 

 

Can an SAC story/dashboard include data across different connections, for example a live connection and an imported data file

 

yes a Story can include data from both Live and Import connections.

 

 

Can we connect to social media data sources (i.e. twitter)?

I recommend looking https://www.sap.com/products/data-hub.html

 

I have been using SAC without an SSL certificate with a Direct Connection via CORS for over 6 months now.

 

this is possible if the certificate is accepted in the browser. This is not recommended.

 

That point that says no additional server required is incorrect as you need a server to manage the ssl certificates.

 

A certificate authority is required to sign the certificate. This can be an internal system such as Window 2012 or other software or a commercial certificate authority. More information is available on the SAP Trust Center at https://www.sap.com/about/cloud-trust-center.html

 

In a BW live connection there is no way to create hierarchies, how could you do them?

 

the BW Live connection can consume BW Hierarchies with some limitations which are being worked on. This information is detailed at https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/ba7ee8dc6dcd4069b210ec712be52a31.html