Skip to Content
This was an SAP webcast from earlier this week.

Source: SAP

2cx.jpg

Source: SAP

Agenda is shown above

Source: SAP

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

Source: SAP

Who can create connections?  See the roles above

You can share connections with the team

Import Data to the Cloud

Source: SAP

 

Importing & storing it in the cloud

Updates can be scheduled

Limit on connection – 8K rows 100 columns

Source: SAP

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

 

Connect to Live Data

 

 

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

Source: SAP

Runs on external server to get the metadata

This is the most known method

 

Source: SAP

No external server needed

Some configuration needed on browser; install certificate

 

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

 

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

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

Source: SAP

Some final considerations are shown above

More upcoming webcasts:

November 13 Smart Predict

November 14 SAP Analytics Cloud Integration with SAP BW: Best Practices

Q&A (answered by SAP)

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

A: 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

Q: 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.

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

 

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

A: SAP Analytics Cloud supports generic OData version 2.0 compatible sources per https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be1f01.html#loio11b4e5ff76eb4747bc255d7037be1f01__p_connectimport

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

A: 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/

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

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

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

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

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

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

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

A: 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

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

A: 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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply