Source: SAP
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/3600be69a97a4b2888e73dcebbfa...
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/11b4e5ff76eb4747bc255d7037be...
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/ba7ee8dc6dcd4069b210ec712be5...
